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.

Explain left outer join and right outer join?

0 Answers  

---

Why would you call update statistics?

0 Answers  

---

Is sql server is free?

0 Answers  

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,

---

Define normalisation?

0 Answers  

---

Ms sql server index?

0 Answers  

---

What is read uncmmited?

0 Answers  

---

List the different normalization forms?

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

Explain what is row_number function?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---