How get current date in SQL server 2000

Answer Posted / rajkumar

select getdate()

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the primary key column of a table an index in ms sql server?

543


Why I am getting this error when dropping a database in ms sql server?

594


How to delete duplicate rows?

556


What is the security principal at the server level that represents your session?

561


What is a trigger what are the advantages of trigger?

531






Explain data warehousing in sql server?

604


How many database files are there in sql server 2000?what are they?

583


Explain “@@rowcount” and “@@error” in sql server?

541


How to create an identity column?

644


What are a scheduled jobs or what is a scheduled tasks?

496


How to check parameter value in stored procedure sql server?

466


What’s the distinction between dropping a info and taking a info offline?

598


What is server-level principal?

100


What is similarity and difference between truncate and delete in sql?

591


What is the difference between writing data to mirrored drives versus raid5 drives

513