select datename(mm,getdate())

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

Question Posted / sairam

Answer Posted / sairam

Is This Answer Correct ?

173 Yes

30 No

Please Help Members By Posting Answers For Below Questions

What are the difference between “where” and “having” clause in sql server?

1025

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1021

What is the maximum size of column in sql server?

864

which backup strategy you are following at ur company

2110

Why do we use stored procedures in sql server?

909

How to grant a permission in ms sql server using "grant execute" statements?

1044

How can I get data from a database on another server?

943

What stored procedure would you use to view lock information?

916

Can primary key be null?

886

What are transactions and its controls?

1016

what are the new features introduced in sql server 2000? : Sql server database administration

881

What is difference between equi join and natural join?

979

what is sql server? : Sql server database administration

944

Write SQL queries on Self Join and Inner Join.

1086

Explain the truncate command?

927