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

Answer Posted / madhu

select @@version

Is This Answer Correct ?    34 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

530


Why should you use or avoid select * statements?

579


What are the advantages of the mirroring?

576


What are the purposes and advantages stored procedure?

501


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

505






What is plan freezing?

586


How to send a ssrs report from ssis?

125


Tell me what do we need queues in sql service broker?

524


List the types of recovery model available in sql server?

507


What is a matrix in ssrs?

101


When would you prefer to have a minimum number of indexes?

509


Do you know what are pages and extents? : SQL Server Architecture

556


what is a join and explain different types of joins? : Sql server database administration

542


What is the difference between varchar and nvarchar?

528


What is scd (slowly changing dimension)? : sql server analysis services, ssas

598