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 can i Relate Tables in SSIS

0 Answers   HCL,

How would you use user_constraints table in DB?

0 Answers   Wipro,

How to create prepared statements using odbc_prepare()?

0 Answers  

What is the largest component inside a field?

0 Answers  

What is normalization process?

0 Answers  




How to get a list all databases on the sql server?

0 Answers  

What is the standby server?

0 Answers  

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

Explain error and transaction handling in sql server?

0 Answers  

How to delete existing triggers using "drop trigger"?

0 Answers  

Can you give an example of Stored Procedure?

4 Answers   Wipro,

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

For more SQL Server Interview Questions Click Here
Categories