Answer / swapna

An extended stored procedure is a function within a DLL
(written in a programming language like C, C++ using Open
Data Services (ODS) API) that can be called from T-SQL,
just the way we call normal stored procedures using the
EXEC statement.


Yes, you can instantiate a COM (written in languages like
VB, VC++) object from T-SQL by using sp_OACreate stored
procedure. For an example of creating a COM object in VB
and calling it from T-SQL

Answer / ajay kumar gupta

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.

SOme are the type of Extend Stored Procedure..
XP_Cmdshell, xp_logevent, xp_deletemail, xp_sendmail

Answer / dharmendra k. dixit

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.

SOme are the type of Extend Stored Procedure..
XP_Cmdshell, xp_logevent, xp_deletemail, xp_sendmail

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

---

How do I find information about the install locations for the various instances running on a computer?

0 Answers  

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

How to convert character strings into numeric values?

0 Answers  

---

How do you load large data to the SQL server database?

2 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

What is abstracting periodical?

0 Answers  

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---