select getdate()

How get current date in SQL server 2000

Question Posted / sangeetha

Answer Posted / sangeetha

select getdate()

Is This Answer Correct ?

27 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to execute a sql statement using mssql_query()?

1051

What is sub-query in sql server? Explain its properties.

1092

Explain intellisense for query editing

1029

How to search for a string in all stored procedure in sql server?

997

What is a view in sql?

976

What are two difference between sql azure and azure tables?

159

How exceptions can be handled in sql server programming?

1012

What are functions in the sql server?

1217

What is a non clustered primary key?

925

What's the information that can be stored inside a bit column?

1004

what is datawarehouse?

1113

What is the difference between Triggers and Stored Procedure?

1095

What is read committed?

1084

When would you use the stored procedures or functions?

1000

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137