Answer Posted / 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.

how will add additional conditions in sql?

1012

---

How many levels of sp nesting are possible?

957

---

How to list all stored procedures in the current database using ms sql server?

1054

---

How to rebuild the master database?

1011

---

List some case manipulation functions in sql?

965

---

What is database dimension? : sql server analysis services, ssas

1031

---

Explain comment on transactions?

934

---

Explain some stored procedure creating best practices or guidelines?

869

---

Define clusters?

997

---

can an automatic recovery be initiated by a user? : Sql server administration

895

---

How can you ensure that the database and sql server based application perform well?

1012

---

What does it mean to be in union?

870

---

1 01 101 01010

2004

---

How to download and install microsoft sql server management studio express?

974

---

How use inner join in sql server?

1054

---