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 / manoj

select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)

Answer / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

What is “asynchronous” communication in sql server service broker?

0 Answers  

---

How can we check the sql server version?

0 Answers  

---

What is abstracting periodical?

0 Answers  

---

How to create a new schema in a database?

0 Answers  

---

What are the joins in sql server? : sql server database administration

0 Answers  

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

Mention the differences between local and global temporary tables.

0 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

What are the advantages of passing name-value pairs as parameters?

0 Answers  

---