What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?



What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?..

Answer / 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

More SQL Server Interview Questions

What is rtm version in sql server?

0 Answers  


Is sql server a database?

0 Answers  


Why is sql server log file full?

0 Answers  


What is an expensive query?

0 Answers  


What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  






How to create logins using windows Authentication mode?

2 Answers  


What is filestream?

0 Answers  


Is port 1433 secure?

0 Answers  


How can windows applications connect to sql servers via odbc?

0 Answers  


What is indexed view?

0 Answers  


Describe in brief system database.

0 Answers  


Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  


Categories