How to define output parameters in stored procedures?

0 Answers  

---

How do I completely remove sql server instance?

0 Answers  

---

How to handle error or exception in sql?

0 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

What different steps will a sql server developer take to secure sql server?

0 Answers  

---

Why is replication required on the sql server?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

Mention the command used to rename the database.

0 Answers  

---

What are constraints?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

What is store procedure? When do you use?

0 Answers  

---