What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
Answer Posted / swapna
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 the
EXEC statement.
Yes, you can instantiate a COM (written in languages like
VB, VC++) object from T-SQL by using sp_OACreate stored
procedure.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to execute multiple stored procedures at one time in sql server?
How to connect to SQL Azure Database by using sqlcmd?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Can two tables share the same primary key?
What is the difference between dropping a database and taking a database offline?
In how many ways you can invoke ssrs reports?
What are the different types of lock modes in sql server 2000?
Can you name some of the dml commands in sql?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Explain what is it unwise to create wide clustered index keys?
Why use cursor in sql server?
How to change the password of a login name in ms sql server?
What is difference in performance between insert top (n) into table and using top with insert?
Difference between connected and disconnected database in .net with sql server?
How to create stored procedures with parameters in ms sql server?