SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 321 Page Views: 

How will you currently installed service pack of the SQL Server?



Posted By: Avi Date: 1 October 2010 12:01:08 PM
 Answer:

With the help of @@version one can determine the Service pack installed on th SQL Server. For this you have to open query analyzer and then have to connect to the server. After that execute the following command:- Select @@version GO The ouput will be as below:- Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) The last 3 digits 623 specifies the service pack.


Posted By: avibtech


Date: 1 October 2010 12:01:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image 8Gfpa9
Related Questions
SQL Server : While updating some rows there is some sort of failure such as power failure. So what will be the state of data?

While updating some rows there is some sort of failure such as power failure. So what will be the st....

There will be no changes done since commit operation was not performed. It will be in the last commi....
Category: SQL Server Date: 10/1/2010 11:57:08 AM
SQL Server : Differentiate between IN and EXISTS operator in SQL Server?

Differentiate between IN and EXISTS operator in SQL Server?

IN:- The IN operator tells the rule-based optimizer to run the inner query first and then drive the ....
Category: SQL Server Date: 10/1/2010 11:56:08 AM
SQL Server : How many types of backups are available in SQL Server?

How many types of backups are available in SQL Server?

The scope of data backup can be whole data, partial ,or some files. On this basis of scope the follo....
Category: SQL Server Date: 10/1/2010 11:55:07 AM
SQL Server : While generating a realtionship between two tables why is it recommended to use CASCADE constraint?

While generating a realtionship between two tables why is it recommended to use CASCADE constraint?

Cascade constraint is used to maintain the consistency of the data. It automatically deletes the row....
Category: SQL Server Date: 10/1/2010 11:54:07 AM
SQL Server : Write a query to join 3 tables naming stud,result,Address. Inner join is to be applied on stud and result table and left outer join on the stud and address table. Also the condition given is where stud.roll is equal to 100.

Write a query to join 3 tables naming stud,result,Address. Inner join is to be applied on stud and r....

select * from stud s1 inner join result r1 on s1.key = r1.key left outer join address a1 on s1.key....
Category: SQL Server Date: 10/1/2010 11:53:07 AM