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.

What is an index. What are the types?

0 Answers  

---

What is difference between inner join and join?

0 Answers  

---

What are the different types of locks in the database?

0 Answers  

---

What is the difference between ddl and dml?

0 Answers  

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

---

What are different types of table joins?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What do you mean by an execution plan? How would you view it?

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---

What languages bi uses to achieve the goal?

0 Answers  

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

How do I open a .db file?

0 Answers  

---