How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / abhirams
slect TO-CHAR(syssdate,'dd-mm-yy h:mipm') from dual; this is
oracle query..
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
Can you explain powershell included in sql server 2008?
How to enable tcp/ip protocol on a sql server?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is primary key, unique key, and foreign key?
how to define testing of network layers? : Sql server database administration
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to update values in a table with update statements in ms sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is built-in/administrator?
Explain trigger classes i.e. Instead of and after trigger?
What is sql sandbox in sql server?
what are database files and filegroups? : Sql server database administration
Why is replication required on the sql server?
Explain boyce and codd normal form(bcnf)?
What do you mean by recursive stored procedure?