ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
can you any body tell me which service pack is installed in 
the sql server?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: can you any body tell me which service pack is installed in the sql server?
Answer
# 1		 
SELECT @@VERSION

Running the above SELECT statemet will give you the version 
of SQL server and its SP
 
Is This Answer Correct ?    4 Yes 0 No
Bharathi
 
  Re: can you any body tell me which service pack is installed in the sql server?
Answer
# 2		 
SELECT @@VERSION
 
Is This Answer Correct ?    3 Yes 0 No
Manohari
 
 
 
  Re: can you any body tell me which service pack is installed in the sql server?
Answer
# 3		 
Select serverproperty('product level')
 
Is This Answer Correct ?    0 Yes 2 No
Hari
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is a stored procedure and trigger?  2
Explain the storage models of OLAP?  1
What is Schema? and why we use schemas?  1
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
What is ACID Property of Transaction?  4
Difference between Function and Procedure-in general?  3
What value could be assigned to Varchar Type?  3
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30 DELL10
How to find the date and time of last updated table?  3
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)  1
how to know Who Is Blocking Your SQL Server?  3
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa11
how to change column into row in sql ESS2
please tell me the query to get details of the employee having the second largest salary 247Customer8
Why we need a group by clause?  3
what is Data Transformation Services (DTS) ?can u explain me in detail? TCS5
How do we rollback the table data in SQL Server  3
What are constraints? Explain different types of constraints?  6
could u plz explain about joins and views?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com