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 is autocommit mode in sql server?
plz send every query in sql server2000
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is meant by indexing?
What samples and sample databases are provided by microsoft?
Write the SQL query to drop, truncate and delete table.
0 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
How to write a query with a left outer join in ms sql server?
What stored by the msdb?
How do I setup a local sql server database?
What do you understand by a stored procedure?
How to get @@error and @@rowcount at the same time?
How to start sql server browser service?
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)