1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which command using Query Analyzer will give you the version
of SQL server and operating system?

Question Posted / latha sree

Answers were Sorted based on User's Feedback



Which command using Query Analyzer will give you the version of SQL server and operating system?..

Answer / madhu

select @@version

Is This Answer Correct ?    34 Yes 6 No

Which command using Query Analyzer will give you the version of SQL server and operating system?..

Answer / koti-khammam

exec xp_msver

Is This Answer Correct ?    11 Yes 9 No

Which command using Query Analyzer will give you the version of SQL server and operating system?..

Answer / madhu

select serverproperty('productversion')

Is This Answer Correct ?    11 Yes 9 No

Post New Answer

More SQL Server Interview Questions

What is a function? Give some example?

3 Answers  

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

What is page-level compression?

0 Answers  

What is data source document?

0 Answers  

How to choose all records from the table?

0 Answers  




What is update_statistics command?

0 Answers  

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

Where do we use trace frag?

0 Answers  

Which joins are sql server default?

0 Answers  

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

Write a sql query to display the current date?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories