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
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Why should you use or avoid select * statements?
What are the advantages of the mirroring?
What are the purposes and advantages stored procedure?
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
What is plan freezing?
How to send a ssrs report from ssis?
Tell me what do we need queues in sql service broker?
List the types of recovery model available in sql server?
What is a matrix in ssrs?
When would you prefer to have a minimum number of indexes?
Do you know what are pages and extents? : SQL Server Architecture
what is a join and explain different types of joins? : Sql server database administration
What is the difference between varchar and nvarchar?
What is scd (slowly changing dimension)? : sql server analysis services, ssas