USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH DEFAULT VALUE OF

How to find the date and time of last updated table?

Question Posted / ram

6 Answers
9636 Views
Teledata, I also Faced
E-Mail Answers

Answer Posted / ram

USE TRIGGER OR ADD DATETIMESTAMP COLUMN IN A TABLE WITH
DEFAULT VALUE OF GETDATE()

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

935

What do you know about normalization and de- normalization?

906

System requirements for sql server 2005 express edition?

992

How to use old values to define new values in update statements in ms sql server?

1241

What is default constraint?

975

What are the properties and different types of sub-queries?

990

What is data compression?

972

Explain the difference between clustered and non-clustered index?

904

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

971

Write the syntax for stuff function in an sql server?

1010

What are functions in the sql server?

1186

What is a trigger what are the advantages of trigger?

973

what is the different types of backups available in sql server? : Sql server database administration

906

What is a transact-sql statement batch in ms sql server?

994

What is the default value of an integer data type in sql server 2005?

941