SELECT CURRENT_TIMESTAMP (just searched in Help of SQL Server 2005)

Alternative way to DetDate() function?

Question Posted / vadivu

Answer Posted / vadivu

SELECT CURRENT_TIMESTAMP

(just searched in Help of SQL Server 2005)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the security related catalog views? : sql server security

931

What happens if you add a new index to large table?

917

Some queries related to SQL

962

How to delete all rows with truncate table statement in ms sql server?

975

What are temporal tables in sql server 2016?

868

What is scd (slowly changing dimension)? : sql server analysis services, ssas

992

Explain what is lock escalation?

1040

What is difference between drop truncate and delete?

1067

Can two tables share the same primary key?

893

Please explain what is “asynchronous” communication in sql server service broker?

915

What are cascading parameters in ssrs reports?

228

What is bcp? When does it used?

964

How to create a store procedure with encryption?

984

How many database files are there in sql server 2000?what are they?

1026

How do I run a trace in sql server?

967