Answer / payal nath

We can determine the last time a user table was altered
using the below query.

SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC

The modify_date column is updated whenever a column is
added or altered for the table.
It is also updated if the clustered index is changed.

Answer / kavitha

getdate() doesnt work for the above query

Answer / ramendra kumar

TO FIND THE NEW DATE ABOUT LAST RECENT CONFIGURE TABLE
SYNTEX WE BRING IN USE TO SEE THE DATE IS
GETDATE()

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

What are wait types?

0 Answers  

---

What is the purpose of floor function?

0 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

What is intellisense?

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---