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 the difference between function and stored procedure in sql server?

1011

What are the different types of join?

1121

Where is my database stored on the hard disk in ms sql server?

1016

How do I open port 1433?

893

How important do you consider cursors or while loops for a transactional database?

925

Explain about service Broker functions?

1000

How to provide values to stored procedure parameters in ms sql server?

987

What do you understand by a stored procedure?

1056

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1049

Can we delete data from a view?

890

How to receive returning result from a query?

1065

What is Federation Root Database?

104

What is the use of “join” in sql server?

1039

What languages bi uses to achieve the goal?

967

What is the difference between for xml raw and for xml auto?

995