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

Answer Posted / monal

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

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is subreport?

141

What are different types of join?

1312

Do you know what are acid properties of transaction?

952

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

What are the steps you can take to avoid “deadlocks”?

974

How to list all dsn entries on your local machine using odbc_data_source()?

1037

What is unique key constraint?

1054

Define full outer join in sql server joins?

984

Working with TLogs

1832

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1676

How to create new databases with "create database" statements?

1017

How use inner join in sql server?

1130

Why would you call update statistics?

1013

Which sql server table is used to hold the stored procedure scripts?

1061

What do you mean by an execution plan? How would you view it?

912