Skip to main content

Posts

Showing posts with the label 2008

SQL Server Build version

This is a list of ll SQL Server Build versions till Year 2014 6.50.201 SQL Server 6.5 RTM 6.50.213 SQL Server 6.5 SP1 6.50.240 SQL Server 6.5 SP2 6.50.258 SQL Server 6.5 SP3 6.50.281 SQL Server 6.5 SP4 6.50.415 SQL Server 6.5 SP5 6.50.416 SQL Server 6.5 SP5a SQL Server 6.5 7.00.0623 SQL Server 7 RTM 7.00.0699 SQL Server 7 SP1 7.00.0842 SQL Server 7 SP2 7.00.0961 SQL Server 7 SP3 7.00.1063 SQL Server 7 SP4 SQL Server 7 8.00.0194 SQL Server 2000 RTM 8.00.0384 SQL Server 2000 SP1 8.00.0534 SQL Server 2000 SP2 8.00.0760 SQL Server 2000 SP3 8.00.2039 SQL Server 2000 SP4 SQL Server 2000 9.00.1399 SQL Server 2005 RTM 9.00.2047 SQL Server 2005 SP1 9.00.3042 SQL Server 2005 SP2 9.00.3042.01 SQL Server 2005 "SP2a" 9.00.3054 SQL Server 2005 KB934458 9.00.3077 SQL Server 2005 Security Update 9.00.3152 SQL Server 2005 SP2 Cumulative Hotfix 9.00.3161 SQL Server 2005 SP2 CU1 9.00.3175 SQL Server 2005 SP2 CU2 9.00.3186 SQL Server 2005 SP2 CU3 9.00.3200

Move Reporting server database instance from one server to another in SQL Server

Following the steps below to Move Reporting server database instance from one server to another in SQL Server 2005,2008,2012 etc 1. Take the backup report server and report server temp db and restore in another server. ( if you want to move db also) 2. In the new server open reporting service configuration manage and re configure with new server details and start again. 3. Remove the encryption keys . Then reports will work from new server.

Important SQL Questions for Exam Preparation

1. Which of the following queries can you use to search for employees with the pattern 'A_B' in their names? A. SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\\'; B. SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE; C. SELECT last_name FROM employees WHERE last_name LIKE 'A_B%' ESCAPE '%'; D. SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\'; 2. The number of records in a table emp is given by statement A. Select total(*) from emp; B. Select count(*) from emp; C. Select sum(*) from emp; D. Select total from emp; 3. Write a query to Display the Name and studentid of all Students of branch CSE and ECE in alphabetical order by name. 4. Can you use the SQL JOIN and SQL HAVING clauses in one SQL statement? A .Yes. B . No. C . It depends. D . Don't know 5. # Which four are valid Oracle constraint types? A.