select datename(month,getdate())

How do we get month name in SQL Server 2000, Oracle, MS Access?

Question Posted / test

Answer Posted / test

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to resolve the orphan use problem? : sql server security

970

How can you find out how many rows returned in a cursor?

988

Are connections to sql server encrypted?

955

What is a bit datatype?

939

Detail about query optimizer?

1044

What is public role in sql server?

1088

How does clustered and non clustered index work?

856

What are different types of statement?

961

What is compound operators?

998

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1050

What is system stored procedures?

989

How to verify the port number of the sql server?

1070

Will sql server 2005 allow you to reduce the size of a column?

935

What are wait types?

1035

What is shrink log file?

857