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

How to rebuild all indexes on a single table?

0 Answers  

How do I find the port number for sql server?

0 Answers  

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

what is a transaction? : Sql server database administration

0 Answers  

How to rename an existing column with sql server management studio?

0 Answers  




How to modify an existing user defined function?

0 Answers  

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

What are different types of schemas?

0 Answers  

How to add more data to the testing table in ms sql server?

0 Answers  

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

How to find the second highest salary of an employee?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories