How get current date in SQL server 2000

Answer Posted / hajee

select sysdate from dual

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by collation recursive stored procedure?

593


What do you mean by an execution plan? How would you view it?

497


Where are SQL server users names and passwords are stored in sql server?

722


How to replace given values with null using nullif()?

578


Can we deploy SSRS reports on our personal website?

123






How do I port a number to sql server?

508


How to list all triggers in the database with sys.triggers in ms sql server?

542


What is the maximum size of sql server database?

513


What is code near application topology?

197


Explain different types of lock modes in sql server 2000?

525


What do you mean by 'normalization'?

610


Do you know what are the restrictions that views have to follow?

630


You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

110


What is dbcc command in sql server?

589


How to access the inserted record of an event?

576