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 indexed views?
What are user-defined functions (udfs) in sql server?
What are the characteristics of modern DBMS?
How do you know if sql server is running on your local system?
How to backup encryption key ?
What is named query? : sql server analysis services, ssas
What are ddl triggers and types of ddl trigger?
Explain forward - only cursors?
Name three of the features managed by the surface area configuration tool? : sql server security
What are the limitations/drawbacks or ssrs 2008 r2?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Do you know what is normalization of database? What are its benefits?
What are system databases into sql server (2005/2008)?
What is wide table?
How to fine-tune reports?