select datename(month,getdate())

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

Question Posted / test

11 Answers
53823 Views
I also Faced
E-Mail Answers

Answer Posted / test

select datename(month,getdate())

Is This Answer Correct ?

11 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use stored procedures in sql server?

895

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1059

What is the difference between insensitive and scroll cursor?

1070

Explain datetime2 data type in sal server 2008?

856

Define self join?

987

What is delete query?

896

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

944

What are the drawbacks of reporting in ssrs?

141

How to insert data with null values?

970

What is meant by indexing?

939

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

926

Is mysql the same as sql server?

913

Can we do dml on views?

914

What are the disadvantages of using the stored procedures?

1018