How get current date in SQL server 2000

Answer Posted / anto

select getdate()

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create sub reports?

210


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

760


Define cross join in sql server joins?

752


what is a mixed extent? : Sql server administration

751


What is an entity-relationship diagram (erd)?

814






what is the difference between count(*) and count(1) ?

811


Explain different types of Normalization.

1188


Define Business Edition in SQL Azure?

98


What is transaction server auto commit?

745


What is perspective, have you ever created perspective? : sql server analysis services, ssas

673


What are the disadvantages of primary key and foreign key in SQL?

806


What do you mean by normalisation?

681


How raid can influence database performance?

753


What stored by the master?

718


How to throw custom exception in Stored Procedure?

764