How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / selvaraj.v
In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'
| Is This Answer Correct ? | 33 Yes | 7 No |
Post New Answer View All Answers
Explain different types of Normalization.
What is difference between count (*) and count column?
What do we have to check in database testing?
How data can be copied from one table to another table?
Is it possible in sql table to have more than one foreign key?
How to create a new login name in ms sql server?
What is the syntax for encrypting a column in SQL Server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain indexing and what are the advantages of it?
Explain different types of locks in sql server.
Is t sql the same as sql server?
what are the core components of SSRS?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the new security features added in sql server 2012? : sql server security
What is the contrast between sql and pl/sql?