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

Question Posted / honeysukumar

Answers were Sorted based on User's Feedback

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

Answer / anil sharma

SELECT CONVERT(varchar,GETDATE(),0)
Return Value = Jun 6 2007

Is This Answer Correct ?

5 Yes

10 No

More SQL Server Interview Questions

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

Explain a differential backup?

what is normalization? Explain different levels of normalization? : Sql server database administration

Can you explain what is indexed view? How to create it?

Do you know what is fill factor and pad index?

What is the difference between delete and truncate statements?

Do you know hot add cpu in sql server 2008?

What is the use of keyword with encryption. Create a store procedure with encryption?

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

what are the different types of replication you can set up in sql server? : Sql server database administration

Explain magic tables in sql server?

Explain filtered indexes?

For more SQL Server Interview Questions Click Here