How get current date in SQL server 2000

Answer Posted / sangeetha

select getdate()

Is This Answer Correct ?    27 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to list all login names on the ms sql server?

539


How to set database to be single_user in ms sql server?

573


Can you leave a union at any time?

547


How can we remove orphan records from a table?

529


What are policy management terms?

566






Can you please differentiate between a primary key and a unique key?

537


When you should use a low fill factor?

527


What is store procedure? When do you use?

530


What is a view in sql?

582


What is RAID? What are the different types of RAID configurations?

619


How to use copy and concatenate commands in SQL?

603


Explain four layers of abstraction microsoft architectured?

124


What it means to be triggered?

506


What are “phantom rows”?

1249


Explain the steps to use transact-sql cursor?

530