How get current date in SQL server 2000

Answer Posted / anto

select getdate()

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I check if a view exists in a sql server database?

561


What are two difference between sql azure and azure tables?

137


What are click through reports?

99


Which data type columns are the best candidates for full-text indexing?

598


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

740






Which are the olap features?

546


Explain the xml support sql server extends?

617


How to sort the query output with order by clauses in ms sql server?

630


How do I save a stored procedure in sql server?

493


What is resource governor in sql server?

544


What is the difference between the application object and session object?

597


What is the sql case statement used for?

557


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

532


What is difference between rownum and row_number?

514


How to insert new line characters into strings?

558