Oracle trigger updating predicate multiple columns

14-Aug-2020 21:43 by 8 Comments

Oracle trigger updating predicate multiple columns - Chat sex sp

Cumulative Updates are not fully regression tested.* Since January 27, 2016: Microsoft recommends ongoing, proactive installation of SQL Server CUs as they become available.

oracle trigger updating predicate multiple columns-40oracle trigger updating predicate multiple columns-18

Applications of Bernoulli’s equation – Venturi meter, Orifice meter, Pitot tube Orifices and Mouth Pieces – Coefficients of Contraction, Velocity and Discharge, External and internal mouthpiece. Seth, Hydraulics and Fluid Mechanics, Standard Book House Delhi. Jagdishlal, Fluid Mechanics & Hydraulics, Metropolitan Book Co., Delhi. Module 2 Bending moment and shear force: Shear force and Bending moment diagrams for various types of statically determinate beams with various loading combinations- relation between load, shear force and bending moment. C, Strength of Materials and Mechanics of structures, Vol.1, Lakshmi Publications, New Delhi. Stores – Safe custody of stores – classification – works – administrative sanction, technical sanction – categories of works.

/* Compare SQL Version with Latest SP / CU / Security KB Data Taken from Last Updated: 2014-10-01 (SQL Server 2008 SP4) Release Details Column 1 = Latest Service Pack 2 - Latest Cumulative Update 3 = Latest Security Patch or KB 5 = Latest SP with no CU or KB released after 7 = Latest Security path / BC when there's no CU (SQL 2000) DEFINE WHAT YOU WANT TO COMPARE THE VERSION AGAINST 1 = SP 2 = CU 3 = Security / KB */ -- DEFINE WHAT YOU WANT TO COMPARE AGAINST -------------------------------------------------------------------------------------------------------------------------------------------------------- DECLARE @Compare TINYINT SET @Compare = 2 -------------------------------------------------------------------------------------------------------------------------------------------------------- IF OBJECT_ID('tempdb..#version') IS NOT NULL DROP TABLE #version; CREATE TABLE #version ( Version VARCHAR(50) , Build VARCHAR(100) , File Version VARCHAR(50) , KBDescription VARCHAR(MAX) , Release Date VARCHAR(100) , Release Details TINYINT , Build4 AS SUBSTRING(Build, LEN(Build) - 3, 4) ); DECLARE @v INT SET @v = CONVERT(INT, LEFT(CONVERT(VARCHAR(MAX), SERVERPROPERTY('Product Version')), CONVERT(INT, CHARINDEX('.', CONVERT(VARCHAR(MAX), SERVERPROPERTY('Product Version')))) - 1)) /* -------------------------------------------------------------------------------------------------------------------------------------------------------- -- SQL SERVER 2014 -------------------------------------------------------------------------------------------------------------------------------------------------------- */ IF ( @v = 12 ) BEGIN INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 4' , '' , '2014.120.2430.0' , '2999197 Cumulative update package 4 (CU4) for SQL Server 2014' , 'October 21, 2014' , 5 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 3' , '' , '2014.120.2423.0' , '3007050 FIX: RTDATA_LIST waits when you run natively stored procedures that encounter expected failures in SQL Server 2014' , 'October 22, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 3' , '' , '2014.120.2405.0' , '2999809 FIX: Poor performance when a query contains table joins in SQL Server 2014' , 'September 25, 2014*new' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 3' , '' , '2014.120.2402.0' , '2984923 Cumulative update package 3 (CU3) for SQL Server 2014' , 'August 18, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 3' , '' , '2014.120.2381.0' , '2977316 MS14-044: Description of the security update for SQL Server 2014 (QFE)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 2' , '' , '2014.120.2370.0' , '2967546 Cumulative update package 2 (CU2) for SQL Server 2014' , 'June 27, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CU 1' , '' , '2014.120.2342.0' , '2931693 Cumulative update package 1 (CU1) for SQL Server 2014' , 'April 21, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 RTM' , '' , '2014.120.2254.0' , '2977315 MS14-044: Description of the security update for SQL Server 2014 (GDR)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 RTM' , '' , '2014.120.2000.8' , 'SQL Server 2014 RTM' , 'April 1, 2014' , 1 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CTP 2' , '' , '2014.120.1524.0' , 'Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)' , 'October 15, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2014 CTP1' , '' , '2013.110.9120.0' , 'Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1)' , 'June 25, 2013' , 0 ) END /* -------------------------------------------------------------------------------------------------------------------------------------------------------- -- SQL SERVER 2012 -------------------------------------------------------------------------------------------------------------------------------------------------------- */ IF ( @v = 11 ) BEGIN INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP2 CU 2' , '' , '2011.110.9000.5' , 'Microsoft SQL Server 2012 With Power View For Multidimensional Models Customer Technology Preview (CTP3)' , 'November 27, 2012' , 3 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP2 CU 2' , '' , '2011.110.5548.0' , '2983175 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 2' , 'September 15, 2014*new' , 2 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP2 CU 1' , '' , '2011.110.5532.0' , '2976982 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 2' , 'July 24, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 2 ' , '' , '2011.110.5522.0' , '2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP2)' , 'June 20, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 2 ' , '' , '2011.110.5058.0' , 'SQL Server 2012 Service Pack 2 (SP2)' , 'June 10, 2014' , 1 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 12' , '' , '2011.110.3460.0' , '2977325 MS14-044: Description of the security update for SQL Server 2012 Service Pack 1 (QFE)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 12' , '' , '2011.110.3470.0' , '2991533 Cumulative update package 12 (CU12) for SQL Server 2012 Service Pack 1' , 'September 15, 2014*new' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 11' , '' , '2011.110.3449.0' , '2975396 Cumulative update package 11 (CU11) for SQL Server 2012 Service Pack 1' , 'July 21, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 10' , '' , '2011.110.3437.0' , '2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP1)' , 'June 10, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 10' , '' , '2011.110.3431.0' , '2954099 Cumulative update package 10 (CU10) for SQL Server 2012 Service Pack 1' , 'May 19, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 9' , '' , '2011.110.3412.0' , '2931078 Cumulative update package 9 (CU9) for SQL Server 2012 Service Pack 1' , 'March 18, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 8' , '' , '2011.110.3401.0' , '2917531 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 1' , 'January 20, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 7' , '' , '2011.110.3393.0' , '2894115 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 1' , 'November 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 6' , '' , '2011.110.3381.0' , '2874879 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 1' , 'September 16, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 5' , '' , '2011.110.3373.0' , '2861107 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 1' , 'July 16, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 4' , '' , '2011.110.3368.0' , '2833645 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 1' , 'May 31, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 3' , '' , '2011.110.3350.0' , '2832017 FIX: You can’t create or open SSIS projects or maintenance plans after you apply Cumulative Update 3 for SQL Server 2012 SP1' , 'April 17, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 3' , '' , '2011.110.3349.0' , '2812412 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 1' , 'March 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 2' , '' , '2011.110.3339.0' , '2790947 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1' , 'January 25, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 1' , '' , '2011.110.3335.0' , '2800050 FIX: Component installation process fails after you install SQL Server 2012 SP1' , 'January 14, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CU 1' , '' , '2011.110.3321.0' , '2765331 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 1' , 'November 20, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1' , '' , '2011.110.3153.0' , '2977326 MS14-044: Description of the security update for SQL Server 2012 Service Pack 1 (GDR)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1' , '' , '2011.110.3128.0' , '2793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1' , 'January 3, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1' , '' , '2011.110.3000.0' , 'SQL Server 2012 Service Pack 1 (SP1)' , 'November 6, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CTP 4' , '' , '2011.110.2845.0' , 'SQL Server 2012 Service Pack 1 Customer Technology Preview 4 (CTP4)' , 'September 20, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 SP 1 CTP 3' , '' , '2011.110.2809.24' , 'SQL Server 2012 Service Pack 1 Customer Technology Preview 3 (CTP3)' , 'July 5, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 11' , '' , '2011.110.2424.0' , '2908007 Cumulative update package 11 (CU11) for SQL Server 2012' , 'December 17, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 10' , '' , '2011.110.2420.0' , '2891666 Cumulative update package 10 (CU10) for SQL Server 2012' , 'October 21, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 9' , '' , '2011.110.2419.0' , '2867319 Cumulative update package 9 (CU9) for SQL Server 2012' , 'August 21, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 8' , '' , '2011.110.2410.0' , '2844205 Cumulative update package 8 (CU8) for SQL Server 2012' , 'June 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 7' , '' , '2011.110.2405.0' , '2823247 Cumulative update package 7 (CU7) for SQL Server 2012' , 'April 15, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 6' , '' , '2011.110.2401.0' , '2728897 Cumulative update package 6 (CU6) for SQL Server 2012' , 'February 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 5' , '' , '2011.110.2395.0' , '2777772 Cumulative update package 5 (CU5) for SQL Server 2012' , 'December 18, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 4' , '' , '2011.110.2383.0' , '2758687 Cumulative update package 4 (CU4) for SQL Server 2012' , 'October 18, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 3' , '' , '2011.110.2376.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 3' , '' , '2011.110.2332.0' , '2723749 Cumulative update package 3 (CU3) for SQL Server 2012' , 'August 29, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 2' , '' , '2011.110.2325.0' , '2703275 Cumulative update package 2 (CU2) for SQL Server 2012' , 'June 18, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM CU 1' , '' , '2011.110.2316.0' , '2679368 Cumulative update package 1 (CU1) for SQL Server 2012' , 'April 12, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM' , '' , '2011.110.2218.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM' , '' , '2011.110.2214.0' , '2685308 FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence' , 'April 6, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RTM' , '' , '2011.110.2100.60' , 'SQL Server 2012 RTM' , 'March 6, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RC1' , '' , '2011.110.1913.37' , 'Microsoft SQL Server 2012 Release Candidate 1 (RC1)' , 'December 16, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 RC0' , '' , '2011.110.1750.32' , 'Microsoft SQL Server 2012 Release Candidate 0 (RC0)' , 'November 17, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 CPT3' , '' , '2010.110.1440.19' , 'Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 3 (CTP3)' , 'July 11, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2012 CPT1' , '' , '2010.110.1103.9' , 'Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 1 (CTP1)' , 'November 8, 2010' , 0 ) END /* -------------------------------------------------------------------------------------------------------------------------------------------------------- -- SQL SERVER 2008 R2 -------------------------------------------------------------------------------------------------------------------------------------------------------- */ IF ( @v = 10 ) BEGIN DECLARE @r2 VARCHAR(100) DECLARE @r2b VARCHAR(5) SET @r2 = ( SELECT LEFT(CONVERT (VARCHAR(100), SERVERPROPERTY('Product Version')), 05) ) SET @r2b = ( SELECT SUBSTRING(@r2, 4, 2) ) IF ( @r2b = '50' ) BEGIN INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 3' , '' , '2009.100.6000.0' , 'SQL Server 2008 R2 Service Pack 3 (SP3)' , 'September 26, 2014*new' , 5 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 14' , '' , '2009.100.4331.0' , '2987585 Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012' , 'August 27, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 13' , '' , '2009.100.4321.0' , '2977319 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (QFE)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 13' , '' , '2009.100.4319.0' , '2967540 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 2' , 'June 30, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 12' , '' , '2009.100.4305.0' , '2938478 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 2' , 'April 21, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 11' , '' , '2009.100.4302.0' , '2926028 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 2' , 'February 18, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 10' , '' , '2009.100.4297.0' , '2908087 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 2' , 'December 16, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 9' , '' , '2009.100.4295.0' , '2887606 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 2' , 'October 29, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 8' , '' , '2009.100.4290.0' , '2871401 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 2' , 'August 30, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 7' , '' , '2009.100.4286.0' , '2844090 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 2' , 'June 17, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 6' , '' , '2009.100.4285.0' , '2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (updated)' , 'June 13, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 6' , '' , '2009.100.4279.0' , '2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (replaced)' , 'April 15, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 5' , '' , '2009.100.4276.0' , '2797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2' , 'February 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 4' , '' , '2009.100.4270.0' , '2777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2' , 'December 17, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 3' , '' , '2009.100.4266.0' , '2754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2' , 'October 15, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 2' , '' , '2009.100.4263.0' , '2740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2' , 'August 29, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CU 1' , '' , '2009.100.4260.0' , '2720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2' , 'August 1, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2' , '' , '2009.100.4033.0' , '2977320 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (GDR)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2' , '' , '2009.100.4000.0' , 'SQL Server 2008 R2 Service Pack 2 (SP2)' , 'July 26, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 2 CTP' , '' , '2009.100.3720.0' , 'SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP)' , 'May 13, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 13' , '' , '2009.100.2881.0' , '2868244 An on-demand hotfix update package for SQL Server 2008 R2 Service Pack 1' , 'August 12, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 13' , '' , '2009.100.2876.0' , '2855792 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 1' , 'June 17, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 12' , '' , '2009.100.2875.0' , '2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (updated)' , 'June 13, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 12' , '' , '2009.100.2874.0' , '2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (replaced)' , 'April 15, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 11' , '' , '2009.100.2861.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 11' , '' , '2009.100.2869.0' , '2812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1' , 'February 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 10' , '' , '2009.100.2868.0' , '2783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1' , 'December 17, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 9' , '' , '2009.100.2866.0' , '2756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1' , 'November 6, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 8' , '' , '2009.100.2861.0' , '2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 8' , '' , '2009.100.2822.0' , '2723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1' , 'August 29, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 7' , '' , '2009.100.2817.0' , '2703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1' , 'June 18, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 6' , '' , '2009.100.2811.0' , '2679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1' , 'April 16, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 5' , '' , '2009.100.2807.0' , '2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2' , 'March 12, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 5' , '' , '2009.100.2806.0' , '2659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1' , 'February 22, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 4' , '' , '2009.100.2799.0' , '2633357 FIX: "Non-yielding Scheduler" error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2' , 'February 22, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 4' , '' , '2009.100.2796.0' , '2633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1' , 'December 20, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 3' , '' , '2009.100.2789.0' , '2591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1' , 'October 17, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 2' , '' , '2009.100.2776.0' , '2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2' , 'October 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 2' , '' , '2009.100.2772.0' , '2567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1' , 'August 15, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1 CU 1' , '' , '2009.100.2769.0' , '2544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1' , 'July 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1' , '' , '2009.100.2550.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 SP 1' , '' , '2009.100.2500.0' , 'SQL Server 2008 R2 Service Pack 1 (SP1)' , 'July 11, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 14' , '' , '2009.100.1817.0' , '2703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2' , 'June 18, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 13' , '' , '2009.100.1815.0' , '2679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2' , 'April 17, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 12' , '' , '2009.100.1810.0' , '2659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2' , 'February 21, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 11' , '' , '2009.100.1809.0' , '2633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2' , 'January 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 10' , '' , '2009.100.1807.0' , '2591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2' , 'October 19, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 9' , '' , '2009.100.1804.0' , '2567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2' , 'August 16, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 8' , '' , '2009.100.1800.0' , '2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system' , 'October 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 8' , '' , '2009.100.1797.0' , '2534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2' , 'June 20, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 7' , '' , '2009.100.1790.0' , '2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011' , 'June 17, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 7' , '' , '2009.100.1777.0' , '2507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2' , 'June 16, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 6' , '' , '2009.100.1769.0' , '2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used' , 'April 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 6' , '' , '2009.100.1765.0' , '2489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2' , 'February 21, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 5' , '' , '2009.100.1753.0' , '2438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2' , 'December 23, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 4' , '' , '2009.100.1746.0' , '2345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2' , 'October 18, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 3' , '' , '2009.100.1734.0' , '2261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2' , 'August 20, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 2' , '' , '2009.100.1720.0' , '2072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2' , 'June 25, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM CU 1' , '' , '2009.100.1702.0' , '981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2' , 'May 18, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM' , '' , '2009.100.1617.0' , '2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 RTM' , '' , '2009.100.1600.1' , 'SQL Server 2008 R2 RTM' , 'April 21, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 CTP Nov' , '' , '2009.100.1352.12' , 'Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP)' , 'November 12, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 R2 CTP Aug' , '' , '2009.100.1092.20' , 'Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)' , 'June 30, 2009' , 0 ) END ELSE /* -------------------------------------------------------------------------------------------------------------------------------------------------------- -- SQL SERVER 2008 -------------------------------------------------------------------------------------------------------------------------------------------------------- */ BEGIN INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 4' , '' , '2007.100.6000.0' , 'SQL Server 2008 Service Pack 4 (SP4)' , 'September 30, 2014 *new' , 5 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 17' , '' , '2007.100.5869.0' , '2977322 MS14-044: Description of the security update for SQL Server 2008 SP3 (QFE)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 17' , '' , '2007.100.5861.0' , '2958696 Cumulative update package 17 (CU17) for SQL Server 2008 Service Pack 3' , 'May 19, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 17' , '' , '2007.100.5852.0' , '2936421 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 3' , 'March 17, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 16' , '' , '2007.100.5850.0' , '2923520 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 3' , 'January 20, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 15' , '' , '2007.100.5848.0' , '2893410 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 3' , 'November 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 14' , '' , '2007.100.5846.0' , '2880350 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 3' , 'September 16, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 13' , '' , '2007.100.5844.0' , '2863205 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 3' , 'July 16, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 12' , '' , '2007.100.5841.0' , '2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (updated)' , 'June 13, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 11' , '' , '2007.100.5840.0' , '2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 (replaced)' , 'May 20, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 10' , '' , '2007.100.5835.0' , '2814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3' , 'March 18, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 9' , '' , '2007.100.5829.0' , '2799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3' , 'January 23, 2013' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 8' , '' , '2007.100.5828.0' , '2771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3' , 'November 19, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 7' , '' , '2007.100.5826.0' , '2716435 Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 7' , '' , '2007.100.5794.0' , '2738350 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 3' , 'September 21, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 6' , '' , '2007.100.5788.0' , '2715953 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 3' , 'July 16, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 5' , '' , '2007.100.5785.0' , '2696626 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 3' , 'May 19, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 4' , '' , '2007.100.5775.0' , '2673383 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 3' , 'March 20, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 3' , '' , '2007.100.5770.0' , '2648098 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 3' , 'January 16, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 2' , '' , '2007.100.5768.0' , '2633143 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 3' , 'November 22, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CU 1' , '' , '2007.100.5766.0' , '2617146 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 3' , 'October 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3' , '' , '2007.100.5520.0' , '2977321 MS14-044: Description of the security update for SQL Server 2008 SP3 (GDR)' , 'August 12, 2014' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3' , '' , '2007.100.5512.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3' , '' , '2007.100.5500.0' , 'SQL Server 2008 Service Pack 3 (SP3)' , 'October 6, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 3 CTP' , '' , '2007.100.5416.0' , 'SQL Server 2008 Service Pack 3 CTP' , 'August 22, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 11' , '' , '2007.100.4371.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 11' , '' , '2007.100.4333.0' , '2715951 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 2' , 'July 16, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 10' , '' , '2007.100.4332.0' , '2696625 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 2' , 'May 20, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 9' , '' , '2007.100.4330.0' , '2673382 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 2' , 'March 19, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 8' , '' , '2007.100.4326.0' , '2648096 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 2' , 'January 30, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 7' , '' , '2007.100.4323.0' , '2617148 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 2' , 'November 21, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 6' , '' , '2007.100.4321.0' , '2582285 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 2' , 'September 20, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 5' , '' , '2007.100.4316.0' , '2555408 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 2' , 'July 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 4' , '' , '2007.100.4285.0' , '2527180 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 2' , 'May 16, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 3' , '' , '2007.100.4279.0' , '2498535 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2' , 'March 11, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 2' , '' , '2007.100.4272.0' , '2467239 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 2' , 'February 10, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CU 1' , '' , '2007.100.4266.0' , '2289254 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 2' , 'November 15, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2' , '' , '2007.100.4067.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2' , '' , '2007.100.4064.0' , '2494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2' , '' , '2007.100.4000.0' , 'SQL Server 2008 Service Pack 2 (SP2)' , 'September 29, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 2 CTP' , '' , '2007.100.3798.0' , 'SQL Server 2008 Service Pack 2 CTP' , 'July 7, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 16' , '' , '2007.100.2850.0' , '2582282 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 1' , 'September 19, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 15' , '' , '2007.100.2847.0' , '2555406 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 1' , 'July 18, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 14' , '' , '2007.100.2821.0' , '2527187 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 1' , 'May 16, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 13' , '' , '2007.100.2816.0' , '2497673 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 1' , 'March 22, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 12' , '' , '2007.100.2808.0' , '2467236 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 1' , 'February 10, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 11' , '' , '2007.100.2804.0' , '2413738 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 1' , 'November 15, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 10' , '' , '2007.100.2799.0' , '2279604 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 1' , 'September 21, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 9' , '' , '2007.100.2789.0' , '2083921 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 1' , 'July 21, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 8' , '' , '2007.100.2787.0' , '2231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8' , 'July 30, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 8' , '' , '2007.100.2775.0' , '981702 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 1' , 'May 17, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 7' , '' , '2007.100.2766.0' , '979065 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 1' , 'March 26, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 6' , '' , '2007.100.2757.0' , '977443 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 1' , 'January 18, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 5' , '' , '2007.100.2746.0' , '975977 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 1' , 'November 16, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 4' , '' , '2007.100.2740.0' , '976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\Agent Service. Only administrator can connect at this time.[SQLState 42000]"' , 'November 24, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 4' , '' , '2007.100.2734.0' , '973602 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 1' , 'September 22, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 3' , '' , '2007.100.2723.0' , '971491 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 1' , 'July 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 2' , '' , '2007.100.2714.0' , '970315 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 1' , 'May 18, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 1' , '' , '2007.100.2712.0' , '970507 FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint """' , 'July 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CU 1' , '' , '2007.100.2710.0' , '969099 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 1' , 'April 16, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1' , '' , '2007.100.2573.0' , '2494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1' , '' , '2007.100.2531.0' , 'SQL Server 2008 Service Pack 1 (SP1)' , 'April 7, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 SP 1 CTP' , '' , '2007.100.2520.0' , 'SQL Server 2008 Service Pack 1 - CTP' , 'February 23, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 10' , '' , '2007.100.1835.0' , '979064 Cumulative update package 10 (CU10) for SQL Server 2008' , 'March 15, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 9' , '' , '2007.100.1828.0' , '977444 Cumulative update package 9 (CU9) for SQL Server 2008' , 'January 18, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 8' , '' , '2007.100.1823.0' , '975976 Cumulative update package 8 (CU8) for SQL Server 2008' , 'November 16, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 7' , '' , '2007.100.1818.0' , '973601 Cumulative update package 7 (CU7) for SQL Server 2008' , 'September 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 6' , '' , '2007.100.1812.0' , '971490 Cumulative update package 6 (CU6) for SQL Server 2008' , 'July 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 5' , '' , '2007.100.1806.0' , '969531 Cumulative update package 5 (CU5) for SQL Server 2008' , 'May 18, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 4' , '' , '2007.100.1798.0' , '963036 Cumulative update package 4 (CU4) for SQL Server 2008' , 'March 17, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 3' , '' , '2007.100.1787.0' , '960484 Cumulative update package 3 (CU3) for SQL Server 2008' , 'January 19, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 2' , '' , '2007.100.1779.0' , '958186 Cumulative update package 2 (CU2) for SQL Server 2008' , 'November 19, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 1' , '' , '2007.100.1771.0' , '958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008' , 'October 29, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CU 1' , '' , '2007.100.1763.0' , '956717 Cumulative update package 1 (CU1) for SQL Server 2008' , 'October 28, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 RTM' , '' , '2007.100.1750.0' , '956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key that has a single row as the update source in SQL Server 2008' , 'August 25, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 RTM' , '' , '2007.100.1600.22' , 'SQL Server 2008 RTM' , 'August 7, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 RC0' , '' , '2007.100.1442.32' , 'Microsoft SQL Server 2008 RC0' , 'June 5, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CTP Feb' , '' , '2007.100.1300.13' , 'Microsoft SQL Server 2008 CTP, February 2008' , 'February 19, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CTP Nov' , '' , '2007.100.1075.23' , 'Microsoft SQL Server 2008 CTP, November 2007' , 'November 18, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CTP Jul' , '' , '2007.100.1049.14' , 'SQL Server 2008 CTP, July 2007' , 'July 31, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2008 CTP Jun' , '' , '2007.100.1019.17' , 'SQL Server 2008 CTP, June 2007' , 'May 21, 2007' , 0 ) END END /* -------------------------------------------------------------------------------------------------------------------------------------------------------- -- SQL SERVER 2005 -------------------------------------------------------------------------------------------------------------------------------------------------------- */ IF ( @v = 9 ) BEGIN INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 3' , '9.00.5324' , '20.0' , '2716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE' , 'October 9, 2012' , 3 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 3' , '9.00.5296' , '20.0' , '2615425 FIX: "Msg 7359" error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated' , 'October 24, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 3' , '9.00.5295' , '20.0' , '2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2' , 'May 21, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 3' , '9.00.5294' , '20.0' , '2572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005' , 'August 10, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 3' , '9.00.5292' , '20.0' , '2494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 3' , '9.00.5266' , '20.0' , '2507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4' , 'March 22, 2011' , 2 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 2' , '9.00.5259' , '20.0' , '2489409 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 4' , 'February 22, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CU 1' , '9.00.5254' , '20.0' , '2464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4' , 'December 24, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4' , '9.00.5069' , '20.0' , 'Microsoft Security Bulletin MS12-070' , 'October 9, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4' , '9.00.5057' , '20.0' , '2494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4' , '9.00.5000' , '20.0' , 'SQL Server 2005 Service Pack 4 (SP4)' , 'December 17, 2010' , 1 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 4 CTP' , '9.00.4912' , '20.0' , 'SQL Server 2005 Service Pack 4 (SP4) - Customer Technology Preview (CTP)' , 'November 3, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 15' , '9.00.4342' , '20.0' , '2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2' , 'May 21, 2012' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 15' , '9.00.4340' , '20.0' , '2494112 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 QFE: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 15' , '9.00.4325' , '20.0' , '2507766 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 3' , 'March 22, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 14' , '9.00.4317' , '20.0' , '2489375 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 3' , 'February 21, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 13' , '9.00.4315' , '20.0' , '2438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3' , 'December 23, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 12' , '9.00.4311' , '20.0' , '2345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3' , 'October 18, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 11' , '9.00.4309' , '20.0' , '2258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3' , 'August 16, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 10' , '9.00.4305' , '20.0' , '983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3' , 'June 23, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 9' , '9.00.4294' , '20.0' , '980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3' , 'April 19, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 8' , '9.00.4285' , '20.0' , '978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3' , 'February 16, 2010' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 7' , '9.00.4273' , '20.0' , '976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3' , 'December 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 6' , '9.00.4268' , '20.0' , '977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005: "Cannot create the subscription because the subscription already exists in the subscription database"' , 'December 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 6' , '9.00.4266' , '20.0' , '974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3' , 'October 19, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 5' , '9.00.4262' , '20.0' , '970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009' , 'October 13, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 5' , '9.00.4230' , '20.0' , '972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3' , 'August 17, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 4' , '9.00.4226' , '20.0' , '970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3' , 'June 16, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 3' , '9.00.4224' , '20.0' , '971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"' , 'June 16, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 3' , '9.00.4220' , '20.0' , '967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3' , 'April 20, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 2' , '9.00.4216' , '20.0' , '967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005' , 'April 20, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 2' , '9.00.4211' , '20.0' , '961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3' , 'February 17, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CU 1' , '9.00.4207' , '20.0' , '959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3' , 'December 20, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 ' , '9.00.4060' , '20.0' , '2494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011' , 'June 14, 2011' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 ' , '9.00.4053' , '20.0' , '970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009' , 'October 13, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 ' , '9.00.4035' , '20.0' , 'SQL Server 2005 Service Pack 3 (SP3)' , 'December 15, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 3 CTP' , '9.00.4028' , '20.0' , 'SQL Server 2005 Service Pack 3 (SP3) - CTP' , 'October 27, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 17' , '9.00.3356' , '20.0' , '976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2' , 'December 21, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 16' , '9.00.3355' , '20.0' , '974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2' , 'October 19, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 15' , '9.00.3353' , '20.0' , '970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009' , 'October 13, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 15' , '9.00.3330' , '20.0' , '972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2' , 'August 18, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 14' , '9.00.3328' , '20.0' , '970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2' , 'June 16, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 13' , '9.00.3325' , '20.0' , '967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2' , 'April 20, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 12' , '9.00.3320' , '20.0' , '969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"' , 'April 1, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 12' , '9.00.3318' , '20.0' , '967199 FIX: The host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider' , 'April 20, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 12' , '9.00.3315' , '20.0' , '962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2' , 'February 17, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 11' , '9.00.3310' , '20.0' , '960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009' , 'February 10, 2009' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 11' , '9.00.3301' , '20.0' , '958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2' , 'December 16, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 10' , '9.00.3294' , '20.0' , '956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2' , 'October 20, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 9' , '9.00.3282' , '20.0' , '953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2' , 'June 16, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 8' , '9.00.3260' , '20.0' , '954950 FIX: Error message when you run a distributed query in SQL Server 2005: "OLE DB provider "SQLNCLI" for linked server "" returned message "No transaction is active""' , 'July 14, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 8' , '9.00.3259' , '20.0' , '954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session' , 'August 14, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 8' , '9.00.3259' , '20.0' , '954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005' , 'July 14, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 8' , '9.00.3257' , '20.0' , '951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2' , 'June 18, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 7' , '9.00.3246' , '20.0' , '952233 FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance' , 'May 23, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 7' , '9.00.3244' , '20.0' , '952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005' , 'June 3, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 7' , '9.00.3240' , '20.0' , '951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005' , 'May 21, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 7' , '9.00.3239' , '20.0' , '949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2' , 'April 17, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 6' , '9.00.3232' , '20.0' , '949959 FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: "The merge process is retrying a failed operation made to article "Article Name" - Reason: "Invalid input parameter values.

Check the status values for detail.""' , 'March 19, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 6' , '9.00.3231' , '20.0' , '949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler"' , 'March 18, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 6' , '9.00.3231' , '20.0' , '949687 FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction"' , 'March 14, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 6' , '9.00.3230' , '20.0' , '949199 FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page"' , 'March 7, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 6' , '9.00.3228' , '20.0' , '946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2' , 'February 19, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 5' , '9.00.3224' , '20.0' , '947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005' , 'February 4, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 5' , '9.00.3221' , '20.0' , '942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005' , 'January 31, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 5' , '9.00.3221' , '20.0' , '945443 FIX: A query takes longer to finish in SQL Server 2005 than in SQL Server 2000 when you open a fast forward-only cursor for the query' , 'January 11, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 5' , '9.00.3221' , '20.0' , '945916 FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001"' , 'January 10, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 5' , '9.00.3221' , '20.0' , '945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005' , 'January 9, 2008' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 5' , '9.00.3215' , '20.0' , '943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2' , 'December 18, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 4' , '9.00.3208' , '20.0' , '944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005' , 'November 21, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 4' , '9.00.3206' , '20.0' , '944677 FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005' , 'December 11, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 4' , '9.00.3200' , '20.0' , '941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2' , 'October 17, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3194' , '20.0' , '940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005' , 'September 24, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940943 FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005' , 'August 29, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005' , 'August 24, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940269 FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"' , 'August 23, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940945 FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005' , 'August 22, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940937 FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object "Object Name" with unique index "Index Name""' , 'August 21, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940379 FIX: Error message when you use the UNLOAD and REWIND options to back up a database to a tape device in SQL Server 2005: "Operation on device "" exceeded retry count"' , 'August 20, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005' , 'August 20, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '937100 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:"Insufficient memory to continue the execution of the program"' , 'August 20, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005' , 'August 20, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005' , 'August 17, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940935 FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: Get Local Lock Partition ()""' , 'August 17, 2007' , 0 ) INSERT INTO #version ( Version , Build , File Version , KBDescription , Release Date , Release Details ) VALUES ( 'SQL Server 2005 SP 2 CU 3' , '9.00.3186' , '20.0' , '940221 FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider "Ora OLEDB.

Module 3 Forces influencing motion – Energy of fluids, Euler’s equation, statement and derivation of Bernoulli’s equation and assumptions made. Compound stresses: Two dimensional problems-principal stresses and principal planes-maximum shear stress-planes of maximum shear- Graphical method. PWD system of account – classification of transactions –heads of accounts – cash – precautions in keeping accounts – construction accounts.

Stream tube – continuity equation for one dimensional flow. Strain energy: Gradually applied and suddenly applied load. M., Analysis of Structures, Vol.1, Khanna Publishers, New Delhi. Module 5 Departmental organizational structure – staff pattern – powers and functions of officers in planning, organising, directing and controlling construction –PWD code.

Difference equations – Solution of difference equations.

Laminar Flow in circular pipes: Hagen poiseuille Equation, Laminar flow through porous media, Stoke’s law. Pressure vessels: Thin and thick cylinders-Lame’s equation-stresses in thick cylinders due to internal and external pressures.

Web Sphere V7.0 and Web Sphere V8.0 along with the underlying Java 6 used in Web Sphere V8.5 are going End Of Service in April 2018.

For more information, please review the announcement at: https://ibm.co/2q VOJCQ.

Module 2 Vector Integral Calculus Line, surface and volume Integrals – work done by a force along a path – Application of Green’s theorem, Stokes theorem and Gauss divergence theorem. Derivations of dimensionless parameters, Froude’s, Reynold’s, Webber, Mach numbers. L., Fluid Mechanics, Mc Graw Hill, International Students Edition. Combined bending and direct stresses: Core of different sections- wind pressure on structures.

Module 3 Function of Complex Variable Definition of analytic functions and singular points – derivation of C. equations in Cartesian co-ordinates – harmonic and orthogonal properties – construction of analytic function given real or imaginary parts – complex potential – conformal transformation of function like zn, ez, 1/z, sin z, z k2/z – bilinear transformation – cross ratio – invariant property – simple problems. Hydraulic Models: Need, Hydraulic Similitude, geometric, Kinematic, Dynamic Similarity, Scale ratios of various physical quantities for Froude’s and Reynold’s model laws – problems, Selection of scale of models – Distorted models, Moving Bed models, Scale effects in models, Spillway models and Ship models. Unsymmetrical bending: Product of inertia-principal axes-stresses due to unsymmetrical bending.

Cumulative Update; Cumulative updates contain the bug fixes and enhancements–up to that point in time–that have been added since the previous Service Pack release and will be contained in the next service pack release.