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 to use online Backups?
Explain the role of indexing in databases?
Write the difference between case version and decode version.
Explain the cube operator?
What is denormalization and when would you go for it?
What are cursors? Explain different types of cursors?
Explain about xml databases?
what is the use of foreginkey
Can an extended stored procedure be called from inside a user-defined function?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Write short notes on XSU and JAVA
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
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)