select getdate()

How get current date in SQL server 2000

Question Posted / anto

Answer Posted / anto

select getdate()

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the tools available in market as an alternative to sql server reporting services?

131

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

What is self contained scalar sub query?

974

How many replicas are maintained for each sql azure db?

124

What is an index in sql?

997

what is a transaction? : Sql server database administration

990

How do clustered indexes store data?

1097

Why use cursor in sql server?

1075

Can we update data in a view?

1021

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1040

Explain the first normal form(1nf)?

1021

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1099

How much space does sql server 2016 take?

952

What is difference between views and stored procedures?

985

What is a primary key?

950