Answer / guest

The pros are that you can implement additional
functionality and access data from DLLs from within SQL
Server. If you need to do something that can be done only
in C or C++, or if you have data that can be accessed only
outside of SQL Server, you can still provide a link to it.
The biggest con to extended stored procedures is that they
run in the same process space as SQL Server. So an errant
DLL could overwrite memory and cause SQL Server to crash or
even corrupt data. The biggest safeguard against these
problems is thorough testing of the procedure

How to list all columns in a table using odbc_columns()?

0 Answers  

---

What are cursors and when they are useful?

0 Answers  

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What are three major types of constraints?

0 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

Is truncate a dml command?

0 Answers  

---

How many types of the database links?

0 Answers   MCN Solutions,

---

What is difference between view and materialized view?

0 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

Explain left outer join and right outer join?

0 Answers  

---