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
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is entity data services?
What are a scheduled jobs?
What language is sql server written in?
How to check status of stored procedure in sql server?
What is data source document?
What is difference between rownum and rowid?
How many replicas are maintained for each SQL Azure database?
How to identify current user in ssrs report?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What new data source types were added in ssrs 2014?
How to create an index on a view?
What are the parts of a function?