How do we get current date in SQL Server 2000, Oracle, MS
Access?
Answer Posted / jayesh l lolariya
select getdate(); in sql server 2000
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
How does recursive cte works in sql server?
Explain relational data?
When cursors are useful?
Define magic tables in sql server?
What are the properties and different types of sub-queries?
What are the grouping functions?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is updatable resultset?
How to configure odbc dsn with different port numbers?
What is the security model used in sql server 2005?
What is the maximum size of a row in sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How to delete a database in ms sql server?
What are the drawbacks of reporting in ssrs?