Sign Up Login


  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

Can we create clustered index on composite key?

0 Answers  

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

Explain filtered indexes benefits?

0 Answers  

How can I check if a view exists in a sql server database?

0 Answers  

What are transactions and its controls?

0 Answers  




Why I have to use stored procedures?

0 Answers   Cognizant,

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

What is sql server query analyzer?

0 Answers  

What is checkpoint in sql server?

0 Answers  

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

Explain the purpose of indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories