How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / rajiv rohilla
In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'
Is This Answer Correct ? | 43 Yes | 13 No |
Post New Answer View All Answers
how can you check the level of fragmentation on a table? : Sql server administration
What are the differences between having and where clause.
What is tabulation?
Why use view instead of a table?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Difference between drill down and drill through report.
your distribution database is full what will u do
How do you delete a trigger?
What is an index in a database?
How to join two tables in a single query in ms sql server?
Explain powershell included in sql server 2008?
Can two different columns be merged into single column? Show practically?
How can we solve concurrency problems?
Call by value and call by reference in procedure and function, with NOCOPY.
Explain what is public role in sql server?