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
Does index slows down insert statements?
How to link tables in sql server?
How to list all objects in a given schema?
How can you find out how many rows returned in a cursor?
What is resource db in sql server?
Does group by sort data?
What is the stored procedure?
What are the dis_advantages of stored procedures, triggers, indexes?
What is indexed view?
Explain the working of sql privileges?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
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?
What is row_number()?
What is transaction server distributed transaction?
What is meant by Active-Passive and Active-Active clustering setup?