Alternative way to DetDate() function?

Answer Posted / vadivu

SELECT CURRENT_TIMESTAMP

(just searched in Help of SQL Server 2005)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by collation recursive stored procedure?

781


How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

791


What is the use of @@spid?

738


What is Extended user-defined?

710


What are the limitations in ssrs on sql server express edition?

158






Explain the concept of view and Types of views in SQL server?

772


How to convert numeric values to integers in ms sql server?

699


How to use transact-sql statements to access the database engine?

744


How to make conditional sum in ssrs?

148


Are semicolons required at the end of sql statements in sql server 2005?

732


What is a partition function in sql server?

699


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

748


Why can there be only one clustered index and not more than one?

732


Is sql server a database?

695


How do I determine how many instances of sql server are installed on a computer?

714