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)

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

Explain forward - only cursors?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---