For oracle, OLD and NEW tables. For sql server, Inserted & Deleted. T

How do we get month name in SQL Server 2000, Oracle, MS Access?

Question Posted / aanshi

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

Please Help Members By Posting Answers For Below Questions

What is the difference between functions and stored procedures?

1091

What does asynchronous call backs means?

1071

What is the stored procedure?

948

How to execute a sql statement using odbc_exec()?

1057

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1079

How will you go about resolving deadlocks?

909

Why are views required in the sql server or in any other database?

907

Explain primary key, foreign key and unique key?

934

What is difference between primary key and foreign key?

834

What is master database? : SQL Server Architecture

949

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

862

What is after dml trigger?

954

Is the primary key column of a table an index in ms sql server?

918

What is the language structure to add a record to a table?

964

What are key, name and value columns of an attribute? : sql server analysis services, ssas

946