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 you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is the maximum size of a dimension? : sql server analysis services, ssas
What is function of ROLLUP ?
what operator performs pattern matching?
How do I determine how many instances of sql server are installed on a computer?
Does a sql server 2005 select statement require a from?
What is the difference between coalesce() & isnull()?
Is sql server is free?
what is the difference between sql query and google query?
Tell me can we use custom code in ssrs?
What is a function? Give some example?
What is stretch database in sql server?
Oracle (3253)
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)