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 |
What are Row versions of DataRow?
What the different components in replication and what is their use?
How to modify the underlying query of an existing view?
How to fetch the next row from a cursor with a "fetch" statement?
What is sql server database?
What is Transaction?
What are the five major components of a dbms?
How to create nested stored procedure?
What is amo? : sql server analysis services, ssas
Explain relational data?
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
what is dbcc? : Sql server database administration
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)