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

Explain iaas, paas and saas?

What do you mean by acid?

999

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

How to change the ownership of a schema in ms sql server?

1193

What are sparse columns?

1013

What are the system database in sql server 2008?

1031

What is amo? : sql server analysis services, ssas

1089

What is database black box testing?

1033

What happens if you are trying to access a schema not owned by you?

968

What do we need queues in sql service broker?

1065

Explain magic tables in sql server?

1058

What is the default fill factor value?

1080

Explain the properties of sub-query in sql server?

1018

What is difference between temp table and cte?

1020

Some queries related to SQL

982