How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / nikita
i donot abt the SQLserver2000and MSaccess.But in ORACLE we
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;
| Is This Answer Correct ? | 32 Yes | 14 No |
Post New Answer View All Answers
What are the characteristics of modern DBMS?
How can you set the threshold at which sql server will generate keysets asynchronously?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What is mean by candidate key?
Distinguish between nested subquery and correlated subquery?
What is sql server programming?
Write down the syntax and an example for create, rename and delete index?
What is the difference in accessing db between sql server vs sql azure?
What are the 3 types of schema?
Which are the important points to note when multilanguage data is stored in a table?
What do you understand by physical_only option in dbcc checkdb?
What is the purpose of the master database?
What do you understand by user-defined function in the sql server?
What is the use of commit?
Explain the first normal form(1nf)?