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

Can you explain powershell included in sql server 2008?

0 Answers  


Do you know hot add cpu in sql server 2008?

0 Answers  


What is the difference between migration and upgradation in sql server?

0 Answers  


Explain primary key in sql server?

0 Answers  


Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  






How to provide default values to stored procedure parameters?

0 Answers  


Why is the need for data conversion transformations?

0 Answers  


How do you load large data to the SQL server database?

2 Answers  


How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  


How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  


Why use triggers?

0 Answers  


Will the writetext statement activate a trigger?

0 Answers  


Categories