What is an extended Stored Procedure?
Answer / swaroop
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.
They are only available in master DB.
Is This Answer Correct ? | 2 Yes | 1 No |
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
How do I open port 1433?
How can we Use Linked Server? Uses of Linked server
Explain the properties of subqueries in sql server?
Where are sql server usernames and passwords stored in the sql server?
What is the purpose of self join?
How do I port a number to sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to delete duplicate rows from table except one?
How do I shrink an ldf file?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
What are the benefits of normalization?