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

What are the advantages of partitioning?

1178

What is sql stored procedure?

1148

Explain index in sql server?

1066

What is the difference between ‘having’ clause and a ‘where’ clause?

1088

How to generate create procedure script on an existing stored procedure?

1066

What is the difference between for auto and for nested?

1065

How to use clusters?

1016

Do you know what are acid properties of transaction?

1005

How would we use distinct statement? What is its use?

1124

How to recreate an existing index in ms sql server?

1117

How to run queries with sql server management studio express?

1153

What is acid db?

933

Define magic tables in sql server?

1121

Explain what stored procedure sp_replcounters is used for? : sql server replication

1577

Explain about SQL server 2005?

1026