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

Can multiple columns be used in sql group by clause in ms sql server?

1041

Define Business Edition in SQL Azure?

100

what is database replicaion? : Sql server database administration

1176

How can you know if the row fetched from cursor is still valid in underlying table?

993

How to get the definition of a trigger back?

995

What does it mean to invest in the index?

956

what is the difference between a primary key and a unique key? : Sql server database administration

989

What are the types of lock supported by ?

1037

What is standby servers? Explain types of standby servers.

988

How can you manage sql azure security?

101

What is measure group, measure? : sql server analysis services, ssas

999

Difference between DELETE and TRUNCATE?

1044

You want to implement the many-to-many relationship while designing tables. How would you do it?

993

Do you know what are acid properties of transaction?

949

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1036