select getdate()

How get current date in SQL server 2000

Question Posted / shyamsri83

Answer Posted / shyamsri83

select getdate()

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to get a list of columns using the "sys.columns" view in ms sql server?

954

What are the authentication modes in sql server? How can it be changed?

1128

What is report server project?

147

what are constraints? : Sql server database administration

1056

What is difference between table aliases and column aliases? Do they affect performance?

963

What is spid in sql server profiler?

1105

How can sql server instances be hidden?

967

Explain the disadvantages/limitation of the cursor?

963

How to create a new table in a given schema?

1185

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

984

How to convert a numeric expression from one data type to another?

1015

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1064

What are cascading parameters in ssrs reports?

229

Define model database?

976

What happens if null values are involved in arithmetic operations?

1011