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
- 54640 Views
- I also Faced
- E-Mail Answers
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
what is an index? : Sql server database administration
What are the different SQL Server Versions you have worked on?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the command used to recompile the stored procedure at run time?
Mention a few common trace flags used with sql server?
How to disconnect from a sql server using mssql_close()?
what is a join? : Sql server database administration
How to delete multiple rows with one delete statement in ms sql server?
If a table does not have a unique index, can a cursor be opened on it?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Difference between connected and disconnected database in .net with sql server?
When I delete any data from a table, does the sql server reduce the size of that table?
Delete duplicate rows without using rowid.
What is the simplest way to create a new database in ms sql server?
What are the differences between DDL, DML and DCL in SQL?
