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 is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

Explain primary key, foreign key and unique key?

0 Answers  

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

---

What are the differences between left join and inner join in sql server?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

What is check constraint in sql server?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

Can we use trigger new in before insert?

0 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

What is sql server used for?

0 Answers  

---