What is use of @@ spid in sql server?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How to create a user name in a database?

0 Answers  

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

How can change procedure in sql server?

0 Answers  

---

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

what is the maximum size of sql row in mssql?

1 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

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,

---

Explain the truncate command?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

what's the maximum size of a row? : Sql server database administration

0 Answers  

---