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. For an example of creating a COM object in VB
and calling it from T-SQL
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Which language rdl files made of?
How to Check if table exists in sql server?
What does it mean to be in union?
What is a non equi join?
Write a sql query to display the current date?
What are the properties and different types of sub-queries?
How to resolve the orphan use problem? : sql server security
How to apply cascading referential integrity in place of triggers?
What is sql collation?
what are the different types of replication you can set up in sql server? : Sql server database administration
Write an SQL query to obtain the 2nd highest salary.
What is best institute to Learn DotNET And SQL in chennai?
What is the partitioning method?
What is an indexing technique?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?