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

Answer Posted / anil sharma

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

Is This Answer Correct ?    5 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does index slows down insert statements?

752


How to link tables in sql server?

658


How to list all objects in a given schema?

737


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

755


What is resource db in sql server?

751






Does group by sort data?

674


What is the stored procedure?

749


What are the dis_advantages of stored procedures, triggers, indexes?

1926


What is indexed view?

752


Explain the working of sql privileges?

800


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

735


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

696


What is row_number()?

771


What is transaction server distributed transaction?

725


What is meant by Active-Passive and Active-Active clustering setup?

749