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 |
Can you explain powershell included in sql server 2008?
Do you know hot add cpu in sql server 2008?
What is the difference between migration and upgradation in sql server?
Explain primary key in sql server?
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
How to provide default values to stored procedure parameters?
Why is the need for data conversion transformations?
How do you load large data to the SQL server database?
How do we return a record set from a Stored Procedure in SQl server 2000?
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?
Why use triggers?
Will the writetext statement activate a trigger?