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


Please Help Members By Posting Answers For Below Questions

What is the default order of an order by clause?

778


How to provide login information for a new odbc dsn?

692


What to check if a User database is locked?

768


What are the advantages of policy management?

749


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

683






Explain partitioned view?

808


Define ACID properties in a Database?

804


What is the difference between implicit and explicit transaction?

732


What is normalization process?

800


How will you monitor replication latency in transactional replication? : sql server replication

814


What methods do you follow to protect from sql injection attack?

702


What is 1nf normalization form?

741


What are commonly used odbc functions in php?

722


How do I start sql server?

698


What is row_number()?

771