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.
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 Question | Next 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? |