How get current date in SQL server 2000
Answer Posted / rajkumar v
select convert( varchar(20), getdate(), 103)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by an execution plan? Why is it used? How would you view it?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What are views in ms sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is 3nf normalization?
What are the common performance issues in sql server?
Do you know what is sql service broker?
What to check if a User database is locked?
What are the disadvantages of using querystrings to send data from one page to another?
What does select 1 mean?
How do you trace the traffic hitting a sql server?
Explain multiserver query
How to execute function in stored procedure sql server?
what is spatial nonclustered index
How to get a list of columns in a view using the "sp_help" stored procedure?