How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / lrk
SELECT GETDATE() AS 'Current Date'
GO
| Is This Answer Correct ? | 66 Yes | 20 No |
Post New Answer View All Answers
What is table valued function and scalar valued functions?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Which command is used for user defined error messages?
Distinguish between nested subquery and correlated subquery?
What information is maintained within the msdb database?
Can a table be created inside a trigger?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is tablix?
What is the template in sql?
What do you mean by table and field in sql?
Define a cross join?
How do database indexes work?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What is the index requirement in SQL Azure?
Can an entity have two primary keys?