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. For an example of creating a COM object in VB
and calling it from T-SQL
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the syntax for encrypting a column in SQL Server?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is equi join with example?
What are the system database in sql server 2005?
What is snapshot replication?
What are .mdf files?
Mention the differences between sql server and mysql.
Explain trigger and its types?
What is user defined datatypes and when you should go for them?
How to connect php with different port numbers?
What is create statement?
How will you optimize a stored procedure optimization?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
When should you use an instead of trigger?
Explain intellisense for query editing