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 |
How can i change the column name.
13 Answers HCL, Yardi Software,
what are the advanced features in sql 2008?
How can change procedure in sql server?
Can you move the resources after pausing the node? : sql server database administration
What is serializable?
how to know description of a table in sqlserver 2000
What is abstracting periodical?
List few advantages of stored procedure.
What do you understand by user-defined function in the sql server?
Explain datetime2 data type in sal server 2008?
What is molap and its advantage? : sql server analysis services, ssas
Can we insert data into a view?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)