How get current date in SQL server 2000

Answer Posted / shyamsri83

select getdate()

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by coalesce in sql server?

726


What the different components in replication and what is their use?

714


What is function of ROLLUP ?

801


Define cursor locking

744


What are sp_configure commands and set commands?

721






Explain left outer join and right outer join?

761


How to run queries with sql server management studio express?

758


What do you mean by stored techniques? How would we use it?

766


what is the system function to get current user's user id? : Sql server database administration

740


How to create a new login name in ms sql server?

703


What is primary key index?

706


How to write a query with a right outer join in ms sql server?

657


What the class forname () does?

709


What is the importance of three tier architecture?

817


What is 2nf example?

728