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 benefit of normalization?

1029

What is resource db in sql server?

972

What is table constraint?

938

How to use user defined functions in expressions?

1014

How can you stop stored procedures from recompiling?

851

Do you know clustered and non-clustered index?

940

Explain primary key, foreign key and unique key?

940

How to modify an existing stored procedure in ms sql server?

1023

What is the maximum size per database for sql server express?

982

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1064

What is rs.exe utility?

152

Is sql different from sql server?

1011

What will be the maximum number of index per table?

960

What is the filtered index?

990

Can we add a cpu to sql server?

965