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 force a query to use a specific index?
Define constraints and give an example of their use?
What is sql server database?
what is raid and what are different types of raid configurations? : Sql server database administration
on line cluster can we make if yes tell me the procedure
Explain an automatic checkpoint
Where do you find the default Index fill factor and how to change it?
Can two different columns be merged into single column? Show practically?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Explain about integration services of Microsoft SQL server?
What is log cache in sql server?
What is candidate key with example?