How get current date in SQL server 2000

Answer Posted / saket

now()

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are window functions in sql server?

517


What are the differences between stored procedure and view in sql server?

628


What is scheduled job and how to create it?

556


Explain different types of lock modes in sql server 2000?

525


What are the hotfixes and patches in sql server?

547






What is federation member?

94


What are the kinds of subquery?

533


Define cursor locking

552


How to run queries with sql server management studio express?

573


What is encryption key?

84


List out the difference between union and union all in sql server?

525


What is the use of tempdb? What values does it hold?

569


How to add the custom code in Report?

99


What is a functions and types in sql server?

598


What is the return type of executeupdate ()?

527