Answer Posted / abdul raziq
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. Tasks that are either
too complicated or just not possible using Transact-SQL can
often be performed with extended stored procedures.
Extended stored procedures are written using the Open Data
Services (ODS) API. ODS is written and supported by
Microsoft and is available on the Workstation version of SQL
Server and as a separate product (and in the Back-Office
Development Kit). The ODS development package includes both
a static-link library (Opends60.lib) and C header files that
let you create fully functional database services. ODS
applications are dynamically linked with Opends60.dll.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a trigger and its types?
What is the difference between set and select?
Explain how to integrate the ssrs reports in application?
What is the difference between cartesian product and cross join?
Explain the Ways to improve the performance of a sql azure database?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Is INSTEAD OF trigger directly applicable to Table ?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Is null vs coalesce?
Are resultset updatable?
What is Replication?
What is the command to change the recovery model?
Explain relational data?
What is a partitioned view?
What is Lock table in SQL?