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

What are the properties of the relational tables?

924

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1045

Ways to improve the performance of a SQL Azure Database?

125

How to define the name and server for a new dsn?

1193

How to find related tables in sql server?

997

What triggers long term care?

1083

when you create a database how is it stored? : Sql server database administration

1076

How to end a stored procedure properly in ms sql server?

1139

Explain in details security in SQL azure?

123

What stored procedure can you use to display the current processes?

939

What is serializable?

1083

Do you know clustered and non-clustered index?

1018

Is it important for a database administrator to understand the operating system and file access?

1036

Find nth lowest salary or get nth lowest salary?

1079

How to delete database objects with "drop" statements in ms sql server?

1145