select getdate();

How get current date in SQL server 2000

Question Posted / mt

Answer Posted / mt

select getdate();

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is use of @@ spid in sql server?

1203

Explain following error properties?

1004

What is constraints and its types?

935

What are the advantages of policy management?

993

Why I have to use stored procedures?

1029

Is there any difference between the primary key and unique key?

993

What is the command dbcc checkdb used for?

1002

How do you delete duplicate records in sql server?

1043

What is resource governor?

962

What is a hint?

985

What is the latest version of microsoft sql server?

1036

Can you explain powershell included in sql server 2008?

930

How to find the list of fixed hard drive and free space on server?

1183

What Are the Main Features of SQL Azure?

117

Define constraints and give an example of their use?

1037