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()

What are “lock” hints?

0 Answers  

---

What is collation sensitivity?

0 Answers  

---

What is buffer cash in sql server?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

How do you debug a procedure in sql server?

0 Answers  

---

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

---

What information is maintained within the msdb database?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

How to create and drop temp table in sql server?

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---