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’s the use of custom fields in report?

944

What is a not null constraint?

1033

How will you find out if there are expensive SQL statements running or not?

1015

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1062

What is implicit cursors?

1085

What is scrollable cursor?

1041

What is 2nf example?

988

What is an identity column in insert statements?

1021

How to list all objects in a given schema?

1057

What happens if null values are involved in comparison operations?

970

What are the disadvantages of indexes?

1085

what is a self join? : Sql server database administration

1035

What is command parameter in ssrs?

161

How will you decide the active and passive nodes?

1126

What is an indexing strategy?

1010