What is an extended stored procedure?
Answer / muhammad usman(lahore)
An extended stored procedure is simply a procedure that is
implemented in a dynamic link library (DLL) — a library
that is called by an application at runtime. Extended
stored procedures can be used in much the same way as
database stored procedures, except that extended stored
procedures normally perform tasks related to the
interaction of SQL Server with its operating environment
| Is This Answer Correct ? | 1 Yes | 1 No |
How long can an error message be in raiseerror function?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Can you have a nested transaction?
Explain about a primary key?
What is an extended stored procedure?
How to generate OIDS
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the three basic rules which are to be followed for the relational model of the database?
Explain about relational operator join?
Explain about network model?
Explain the role of indexing in databases?
Which data type cannot be used as a parameter in a udf?
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)