Organizational Research By

Surprising Reserch Topic

Question:What is an extended stored procedure?



asked Sep 13, 2013 in Java Interview Questions by ashish singh
edited Sep 12, 2013
0 votes
21 views



Related Hot Questions

2 Answers

0 votes
An extended stored procedure is a function within a DLL (written in a programming language like C, C++ using Open Data Services (ODS) API) that can be called from T-SQL, just the way we call normal stored procedures using theEXEC statement. See books online to learn how to create extended stored procedures and how to add them to SQL Server. Yes, you can instantiate a COM (written in languages like VB, VC++) object from T-SQL by using sp_OACreatestored procedure. Also see books online for sp_OAMethod
answered Sep 13, 2013 by ashish singh
edited Sep 12, 2013
0 votes
An extended stored procedure is a function within a DLL (written in a programming language like C, C++ using Open Data Services (ODS) API) that can be called from T-SQL, just the way we call normal stored procedures using theEXEC statement. See books online to learn how to create extended stored procedures and how to add them to SQL Server. Yes, you can instantiate a COM (written in languages like VB, VC++) object from T-SQL by using sp_OACreatestored procedure. Also see books online for sp_OAMethod
answered Sep 13, 2013 by ashish singh
edited Sep 12, 2013

...