ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to find the date and time of last updated table?
 Question Submitted By :: Hari
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to find the date and time of last updated table?
Answer
# 1		 
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.
 
Is This Answer Correct ?    14 Yes 7 No
Payal Nath
 
  Re: How to find the date and time of last updated table?
Answer
# 2		 
TO FIND THE NEW DATE ABOUT LAST RECENT CONFIGURE TABLE 
SYNTEX WE BRING IN USE TO SEE THE DATE IS 
 GETDATE()
 
Is This Answer Correct ?    1 Yes 9 No
Ramendra Kumar
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C vsworx7
What is a Linked Server?  1
About DTS usage ? Cognizent2
What is Transaction?  2
What types of integrity are enforced by a foreign-key constraint  1
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
What are the two virtual tables SQL Server maintains for triggers?  2
Difference between Cluster and Non-cluster index? Oracle9
What is an extended Stored Procedure?  1
When do you use SQL Profiler?  2
What is the difference between login and a user? TCS7
what is IDE,DMV in sql server? Value-Labs1
logshipping is Any difference 2000 and 2005?  1
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?  2
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.  7
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?  1
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication? Microsoft4
where do you use Isolations?give me some exmpale?  1
What should we do to copy the tables, schema and views from one SQL Server to another?  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com