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
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?
State a few properties of relational databases?
List the types of recovery model available in sql server?
Which language is supported by sql server?
What is difference between sql and sql server?
What is difference between line feed ( ) and carriage return ( )?
What samples and sample databases are provided by microsoft?
What is partitioned view?
query processing
In what sequence sql statement is processed?
Is sql server free?
What are types of subqueries?
which table keeps the locking information? : Sql server administration
How to drop an existing table with "drop table" statements in ms sql server?
Can a database be shrunk with users active?