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

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

713


State a few properties of relational databases?

833


List the types of recovery model available in sql server?

665


Which language is supported by sql server?

703


What is difference between sql and sql server?

689






What is difference between line feed ( ) and carriage return ( )?

679


What samples and sample databases are provided by microsoft?

759


What is partitioned view?

670


query processing

1921


In what sequence sql statement is processed?

761


Is sql server free?

670


What are types of subqueries?

747


which table keeps the locking information? : Sql server administration

706


How to drop an existing table with "drop table" statements in ms sql server?

725


Can a database be shrunk with users active?

796