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 force a query to use a specific index?

0 Answers  


Define constraints and give an example of their use?

0 Answers  


What is sql server database?

0 Answers  


what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  


on line cluster can we make if yes tell me the procedure

0 Answers   Microsoft,






Explain an automatic checkpoint

0 Answers  


Where do you find the default Index fill factor and how to change it?

0 Answers  


Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  


Explain about integration services of Microsoft SQL server?

0 Answers  


What is log cache in sql server?

0 Answers  


What is candidate key with example?

0 Answers  


Categories