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 sql server management studio? : sql server management studio

0 Answers  

How to configure and test odbc dsn settings?

0 Answers  

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

What value could be assigned to Varchar Type?

3 Answers  

What is the default Port No on which SQL Server listens?

0 Answers  




how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

How you can move data or databases between servers and databases in sql server?

0 Answers  

Can we call future method from trigger?

0 Answers  

How do I view a stored procedure in sql server?

0 Answers  

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

What is de-normalization and when do you do it?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories