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 a schema in ms sql server 2005?

1024

What is the New in SQL server 2008?

1012

Can we insert data if clustered index is disabled?

981

List the different types of collation sensitivities in sql server?

1074

How can you know if the row fetched from cursor is still valid in underlying table?

1041

What command is used to create a database in the sql server and how?

1236

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1048

What are the methods used to protect against sql injection attack?

1114

What is nolock hint in sql server 2008

1178

What is a Join and explain its types?

1146

Explain filtered indexes benefits?

1042

What is in place upgrade in sql server?

1090

How to execute a sql statement using mssql_query()?

1102

What is the use of partition by in sql server?

968

What is normalization? Describe its different types.

1151