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 do I start sql server 2017?
Explain triggers in sql?
How do you persist objects, permissions in tempdb
Can you please explain the difference between primary keys and foreign keys?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
diffrence between Cluster Index and non Cluster Index
How the data stores in a page?
What are the main control-of-flow T-SQL constructs?
how to rename the table
How to display a past time in days, hours and minutes?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What objects does the fn_my_permissions function reports on? : sql server security
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)