Which command using Query Analyzer will give you the version
of SQL server and operating system?
Answer Posted / madhu
select serverproperty('productversion')
| Is This Answer Correct ? | 11 Yes | 9 No |
Post New Answer View All Answers
How to find tables without indexes?
What is CTE in SQL
How to delete existing rows in a table?
What part does database design plays a role in performance of an sql server-based application?
What is the chart in report?
What is difference between materialized view and view?
What information is maintained within the msdb database?
What are a scheduled jobs or what is a scheduled tasks?
Does order by actually change the order of the data in the tables or does it just change the output?
What is the difference between getdate and sysdatetime?
What is the use of =,==,=== operators?
Define indexes?
How to define and use table alias names in ms sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is spid in sql server profiler?