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

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

Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does sql server run on? How can it be changed?

1044

Does any body please help me what question's have asked for SSRS in the interview?

2149

How to find the list of fixed hard drive and free space on server?

1203

What is difference between sql and sql server?

1009

What is the use of keyword with encryption.

1031

What are constraints?

1015

Define ACID properties in a Database?

1062

Does server sql treat char as a variable-length or fixed-length column?

1044

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1072

Describe and explain about SQL native client?

1112

what method you can use to reduce the overhead of Reporting Services data sources?

255

What is sql azure database?

206

How except clause is differs from not in clause?

956

What are acid properties of transaction?

950

What are the restrictions applicable while creating views? : SQL Server Architecture

1029