SQL Server Database Administrator Question:
Download Questions PDF

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

Answer:

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.

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What is a self join? Explain it with an example.?What are triggers?
How many triggers you can have on a table?
How to invoke a trigger on demand?