Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / swapna


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

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  

What Is Rdbms?

0 Answers   Accenture,

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

How to Update from select query in sql server?

0 Answers  

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

What is the difference between varchar and nvarchar datatypes?

0 Answers  

How check triggers in sql server?

0 Answers  

What is filtered index?

0 Answers  

Explain aggregate functions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories