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
Explain transaction server isolation?
what is the system function to get current user's user id? : Sql server database administration
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How self join is different from outer join?
Can a synonym name of a table be used instead of a table name in a select statement?
what's the difference between a primary key and a unique key? : Sql server database administration
What is BCP? When does it used in sql server 2012?
Do I need a report server to run reports in my application?
What number sorts of privileges are accessible in sql?
Mention what are the different types of ssrs reports?
How to check if a table is being used in sql server?
What do you understand by check constraint in sql server?
How to create a dynamic cursor with the dynamic option?
Can you insert NULL in unique column?
What is user-defined function?