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

Explain various data region available in ssrs with their use?

0 Answers  


What is truncate table?

0 Answers  


Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  


What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  


Do you know what is xpath?

0 Answers  


Define outer join in sql server joins?

0 Answers  


How many triggers you can have on a table?

0 Answers  


MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,


application server is slow what may be the problem

0 Answers   Microsoft,


How can I create a new template for import ? : sql server management studio

0 Answers  


You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  


I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  


Categories