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
How to list all tables in the database using odbc_tables()?
what is a live lock? : Sql server database administration
What is the maximum size of column in sql server?
Who is the owner of a schema in ms sql server?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Define left outer join in sql server joins?
Define right outer join in sql server joins?
What is filter index?
How to make remote connection in database?
What are the types of subscriptions in SQL Server replication?
How we can refresh the view?
What are the lambda triggers?
Are resultset updatable?
How to select an exiting database using mssql_select_db()?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?