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

Answer Posted / kongu karunakaran

select datename(month,parametername or columnname) from
tablename

Is This Answer Correct ?    33 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of user-defined functions over stored procedures in sql server?

455


What is key attribute?

502


Explain what is meant by replication of database?

522


What is data mart? : sql server analysis services, ssas

582


Can You Use Data Mining Models In Ssrs?

97






In what sequence sql statement is processed?

577


mention different types of relationships in the dbms?

498


What are sub reports?

149


Does sql server 2000 clustering support load balancing?

560


Can you please differentiate between a primary key and a unique key?

522


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2202


How to provide values to user defined function parameters?

549


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

660


How to locate and take substrings with charindex() and substring() functions?

502


what are defaults? : Sql server database administration

511