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
How to get a list of columns using the "sys.columns" view in ms sql server?
What are the authentication modes in sql server? How can it be changed?
What is report server project?
what are constraints? : Sql server database administration
What is difference between table aliases and column aliases? Do they affect performance?
What is spid in sql server profiler?
How can sql server instances be hidden?
Explain the disadvantages/limitation of the cursor?
How to create a new table in a given schema?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How to convert a numeric expression from one data type to another?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What are cascading parameters in ssrs reports?
Define model database?
What happens if null values are involved in arithmetic operations?