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
Name the different type of indexes in sql?
Do you know what are various aggregate functions that are available?
What will be the maximum number of indexes per table?
What are the restrictions that views have to follow?
How can a database be repaired?
Mention the different authentication modes in sql server.
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What are the aggregate and scalar functions?
What is an execution plan? When would you use it?
Tell me what is use of except clause? How it differs from not in clause?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is the difference between functions and scalar functions?
Do you know what are the ways available in sql server to execute sql statements?
What are partitioned views and distributed partitioned views?