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 many types of stored procedures are there in sql server?
What are cursors stored procedures and triggers?
How to use wildcard characters in like operations in ms sql server?
What is the rdl file?
What is a fan-out query in SQL Azure?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How can change procedure in sql server?
What are the types of sql server?
Explain what is analysis service repository?
How do I start and stop sql server?
Explain differences between web edition and business edition?
What are the hotfixes and patches in sql server?
What is use of except clause? How it differs from not in clause?
What is a data source or ds? : sql server analysis services, ssas
What is the sql case statement used for?