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

What is resource governor in sql server?

721


What do you mean by acid?

758


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

684


What are trace files?

705


How does recursive cte works in sql server?

711






User wants only to display only pdf as export option in report manager. How to achieve this?

212


What is the purpose of the tempdb database?

747


Is port 1433 secure?

736


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1807


Explain relational data?

703


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

795


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

129


Do you know what is normalization of database? What are its benefits?

734


Explain the use of containers in ssis and also their types?

704


What are built in functions?

756