How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / sridhar kumar nelanti
we use getdate()in SQL server to view current date and in
oracle we use sysdate().
| Is This Answer Correct ? | 27 Yes | 7 No |
Post New Answer View All Answers
How many ways to create table-valued functions?
What is the difference between primary key and unique constraints?
What different steps will a sql server developer take to secure sql server?
Is there any difference between the primary key and unique key?
What is a data source file?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is the use of tempdb? What values does it hold?
How many database files are there in sql server 2000?what are they?
How to delete a database in ms sql server?
Define constraints and give an example of their use?
Mention what are the different types of ssrs reports?
what are acid properties? : Sql server database administration
What action plan is preferred if sql server is not responding?
What do you mean by sql server 2005 express management tools?
Explain unique key in sql server?