Interested to Buy Any Domain ? << Click Here >> for more details...
How do we get month name in SQL Server 2000, Oracle, MS Access?
- 11 Answers
- 53822 Views
- I also Faced
- E-Mail Answers
Answer Posted / foram
select month(getdate())
select month(dateparametername) from tablename
---here u will get number of month
or
select datename(month,getdate())
select datename(month,dateparametername) from tablename
to get name of month
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
How to provide values to stored procedure parameters in ms sql server?
How will you go about resolving deadlocks?
When does a workload on SQL Azure get throttled?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Which Model uses the SET concept
What is tempdb database? : SQL Server Architecture
What does truncate do?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What command is used to delete a table from the database in the sql server and how?
What will be the maximum number of index per table?
Explain about protocol layer present in SQL server?
Define tool Manage Statistics in SQL Server 2000 query ?
What is the function of sql server agent windows service?
What is the purpose of forms?
In which files does sql server actually store data?
