How do we get month name in SQL Server 2000, Oracle, MS Access?
Answer Posted / aanshi
For oracle, OLD and NEW tables.
For sql server, Inserted & Deleted.
These two tables are also called as magic table.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is a performance monitor?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is the sql case statement used for?
If we delete pack Spec what will be the status of pack Body ?
Explain the dirty pages?
How to create an index on a view?
How to run queries with sql server management studio express?
Can I use sql azure as a backup with log shipping or database mirroring?
Can you explain different types of joins?
How to configure and test odbc dsn settings?
What should be the fill factor for indexes created on tables? : sql server database administration
how you can deploy an ssrs report?
What does it mean to normalize a database and why would you do it?