Answer / Jagesh Kumar

To list all the columns in a SQL Server database, you can use the INFORMATION_SCHEMA.COLUMNS view:nn```sqlnSELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS;n```

How to find the date and time of last updated table?

3 Answers  

---

Can you roll back the ddl statement in a trigger?

1 Answers  

---

Why do you need a sql server?

1 Answers  

---

Explain what is row_number function?

1 Answers  

---

Define candidate key, alternate key, and composite key.

1 Answers  

---

What are the database roles? : sql server security

1 Answers  

---

What is use of @@ spid in sql server?

1 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

What are various ways to enhance the ssrs report?

1 Answers  

---

last function used in MS Access to convert sql what function will use in sql

1 Answers   Cap Gemini,

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

How do you know if sql server is running on your local system?

1 Answers  

---