Answer / Nagpal Singh

To find the columns used in a stored procedure in SQL Server, you can use the following query:n```sqlnUSE your_database;nEXEC sp_helptext your_stored_procedure;nGOn``` This will return the text of the stored procedure, including the SELECT statement that defines the columns used.

What are the 2 types of classifications of constraints in the sql server?

1 Answers  

---

What is the purpose of a table?

1 Answers  

---

What is the sql server 2000 version number?

1 Answers  

---

What is data file in computer?

1 Answers  

---

How to turn on the mssql api module in php?

1 Answers  

---

Is a primary key unique?

1 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

1 Answers  

---

Can you roll back the ddl statement in a trigger?

1 Answers  

---

What is meant by dirty read?

1 Answers  

---

How to delete duplicate rows in sql server?

1 Answers  

---

List the various tools available for performance tuning?

1 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---