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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

528


What is a schema in ms sql server 2005?

568


How to provide values to user defined function parameters?

558


What are the triggers in sql?

561


What is data set in report?

98






What are views used for?

623


What is the difference between seek predicate and predicate?

592


What happens if strings are casted into wrong code pages in ms sql server?

569


Explain the usage of floor function in sql server.

509


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

560


What are the tables in sql?

633


Which language rdl files made of?

100


What does dml stand for?

512


Do you know what is a linked server in sql server?

555


What is the default port for SQL Server over a firewall?

593