How get current date in SQL server 2000

Answer Posted / sangeetha

select getdate()

Is This Answer Correct ?    27 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to override dml statements with triggers?

747


Explain in brief how sql server enhances scalability of the database system?

686


how you can list all the tables in a database?

739


What is tabulation?

706


How to add a new dsn with the odbc driver for sql server?

736






Do you know the isolation level that sql server support?

706


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

749


What is a transact-sql statement?

709


Can a synonym name of a table be used instead of a table name in a select statement?

768


difference between Clustered index and non clustered index ?

742


What is the difference between count () and rowcount ()?

706


What are the disadvantages of merge replication?

967


What are the differences between user defined functions and stored procedures?

739


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1477


Do you know the capabilities of cursors?

768