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

explain databases and sql server databases architecture? : Sql server database administration

523

What is the difference between update lock and exclusive lock?

498

What are the general features of sql server management studio? : sql server management studio

601

role of sql sever 2005 in database rather than any other database

1514

what is the difference between openrowset and openquery?

589

List out the difference between union and union all in sql server?

525

How to use union to merge outputs from two queries together in ms sql server?

562

How can you fetch alternate records from a table?

547

What is an identity?

572

What do you understand by triggers and mention the different types of it?

488

What is query cost in sql server?

564

How do I schedule a sql server profiler trace?

542

What is database isolation in sql server? : sql server database administration

570

What is serializable?

673

When would you use sql joins?

528