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


Please Help Members By Posting Answers For Below Questions

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

484


What is a performance monitor?

548


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

493


Other than truncate statement, which other command can by-pass the trigger on the tables?

611


What is the sql case statement used for?

553






If we delete pack Spec what will be the status of pack Body ?

961


Explain the dirty pages?

566


How to create an index on a view?

571


How to run queries with sql server management studio express?

561


Can I use sql azure as a backup with log shipping or database mirroring?

136


Can you explain different types of joins?

538


How to configure and test odbc dsn settings?

565


What should be the fill factor for indexes created on tables? : sql server database administration

617


how you can deploy an ssrs report?

127


What does it mean to normalize a database and why would you do it?

519