PK\*4 le71Chapter13/1-CREATE TRIGGER trgInsTransactions.sqlN0E!*,3-A%AkuRxB*»>w|g,$fAbE ԽMНi&IUD_՜6EPjT<}cq ]7؆=PԦ5Dυ vd KyҟvfG_e\,;9`2Y=̋9cU>p"={&ZbŞ'Ku$Bv88K„qo*&F*_(f2MPK\*4Y:wh Chapter13/10-DatabaseTrigger.sql[O@ϳo^4&j,P  1 #)x#@x0Ι۞~+T7VMU$4SZTSCXŲsyUjk ɹ5$GLΈy[qukyBb" 9;KD}eOM7-غW!7 2' lZOVhHo)lA:ٺJT9SdLDC3=QO;TXzZwX*o7s5,U2tNPwhd*0v!]zTUXn-}[s:FOYs3TΡ9άӯf\bnm&:Vh0c m9PK\*4HLd&Chapter13/11-InvokeDatabaseTrigger.sqlϙ!!H*0y @ C(XF(PP`T >@ TT@^"VPK\*4 ]c=H$Chapter13/12-DropDatabaseTrigger.sql A 0)JEXGE !_lV](m_n$߉AWPK\*49&q$Chapter13/13-DatabaseTriggerDump.sqle 0\r(^sT~]#ʲ?ݑxFUrQDMONʅz`W^̓,nSLʕ^Fk_͋t2=ҚPK\*4 Oh$Chapter13/14-EventDumpInvokation.sql!!H*0y@1WPP&ޑ!(be}BA.D0KPK\*4Tzs1$Chapter13/2-Drop-Balance-by-$200.sqlO0ݛIc$ ܁ZӖ1|yK$d#)KAJw켙0݊xALc8+ E%kVi:?l(A _O S;8!_0jO{Zް HH2O%aPK\*4w3&Chapter13/3-ERROR-Cant-Insert-NULL.sqlO0ݛIc@g :7ph -oMs,0&jP% XWHgHSFN,z5BensY^6XKKYuKX $Y2Y;QӠuts2Q;CIqX6D,N(DbAͿPK\*4W-@I'Chapter13/4-Customer-1-Transactions.sql vquQRRPp U)J+NL.sI-I)C*) p rUp.-.M-L5PK\*4u%JChapter13/5-Alter-Trigger.sqlN0 ƿ3#peҡsU T*jˁ8ʶR!+KR?; >(ͽD*c%2 jNy.L?c=Gc's.x~;2)xxoM+;Ѷ61Xu qS!+ZqT+>!s (+V|Qx5PYzlc|ml-^ 2N0@39jeԺbF[?}o TI(dCW|:C]lSe&1pLZc7VIv7}t?gMr?PK\*4Chapter13/7-Invoke-Trigger.sql vquQRPp U)J+NL.sI-I)C* p rUp.-.M-LQU0 䜓X┘ 7f$_W"ܣ_Wj`7I%XS;PK\*4h #Chapter13/8-RaiseerrorInTrigger.sqlݖN@ƿ7P@H4ZM|yYJ ͦng7v&ǻ6<\ӅGagD#Ą\)9|z;"]tı\xٓ !$|"eJc 6ccxZwivWY u#V@jr1l@i@jŧ! [5NxT3;aqh[m^E[(ώ3&gk-x>Ϟhg*mFdEtqYc} ΏOA*sQh~Z}I-oӈw*gXPK\*4T*Chapter13/9-Invoke-Trigger-NoBalChange.sqlO P‚;EaFP}j?&==wٙY߻]7,l| zim0cROžge⽲XA *}IӪ2fT?=RMLE"LGՓr=UOc3`Xl_DPs;BdvU R9t=Ĥ/_fM_1u<^r`sg40a7IJiThpp;~ahRv4p/1ĒQlBG+8 ?P+N䀵r) =L=F`ԠX%onO=pӜ㴓w)<PK f\*4 Chapter01/PKg\*4Btk~Chapter02/readme.txtM10 H?@^pSUp=ac᤻)S%t!0Gn@QA| R}wGv_y̮dM;3 +L|B PK g\*4 Chapter02/PKh\*4I(Chapter03/CreateDatabase.sqlj0p7Dd MKL3C>iEw]]\ؠ >Lݰ]ePՔ | C,Ah3ȏߵ;@{5\o8#'B/eZ.%ٺ"9:|Aw|ߤkp8zQN uyz+kf`eh?gߛ CIm W$zHdel>DPKh\*4nj`kChapter03/readme.txt C'(Y7(lo}8[9y~82%`λ`Mo<18a;em65ZaTC PK h\*4 Chapter03/PKi\*4@,Chapter04/1-Logins.sql vUM,.I-rrru qUwS q,(J-.(O)M.w+)I-*Ur Us! .n>!.!Nvl閙j=PEZ%PKj\*4śChapter04/2-Users.sql a\4hB&8j?w;$A5Cí96uc*baDyV ~E}0J^&%tT$%=xH?hkP= 1(ϳ%hشqd;6PKj\*4OfT.X}Xo`ҫb`i+1k;+b$O'/PKn\*4MP3Chapter05/3.TransactionDetails.TransactionTypes.sqlPMk0 - $e.!sia )/e=, 'RpVh8LѼT~v κD9z:rǖ3f'+DhO.P&/ IK2V3@'rSK,^er]:[huuJF+u\0vS3|zL?8[hսPKo\*4vNU9Chapter05/4.TransactionDetails.TransactionTypes-ALTER.sqls q RqtqU)J+NL.sI-I)C ,H-rtqQpLKKM.qN,pJIKNUH,Q rPKo\*4QXb;Chapter05/5.TransactionDetails.TransactionTypes-ALTER-2.sqls q RqtqU)J+NL.sI-I)C ,H-rkp SpLKKM.qN,pJIKNUH,QQ rPKp\*4_8uChapter05/6.RemainingTables.sqlSAO0#KK"!A]նh%d:q5}MFcq*|~{Q$f DB\n֪5՝ki {̥4Nr]/f,;tz +UKKT@fRn}5JvSQ! gأ(PRW8Ε_OM |oHb4C8yG`NjBu;u7oӰ3n֚3Z86ȺgfKf چ]z8M g`/ڕOY1rq-NǦ g:4=PKr\*410Chapter06/11.CustomerDetails.Customers-Index.sqlMA 0DzlAO$$)m ]`M.f3!B>C %@}i~=9Ѱ&9c:l_;: || 6ilf`rT-0rL]2 +?\,QpXe2PKs\*4[κ_}6Chapter06/2.CustomerDetails.CustomerProducts-Index.sql vUp,(J-.vKKLrrru qUsqPw.-.M- (O)M.)S $f+RRg /&PKs\*44T9Chapter06/3.TransactionDetails.TransactionTypes-Index.sqlmMk1  =d;M|d+K}cU*sy}+zv~S9A+&q?m.VPkFonN7^>aňm. -w;pӬ sv}n(e'e 4!ځ:߂hwM34_1ΤNPKt\*4.e6Chapter06/5.TransactionDetails.TransactionTypes-PK.sqle 0D!&i ِl)E$AۋoJ<]30M@>a꯷q@~#8O)Cyl֩sԲ*) EV%ut+HyRNr<؆$l˲U0Ɔ'ѸQklk?sS@Ur&4p=YyPKu\*43Chapter06/6.Drop-Index.sqlj0E,.i%UP08})!ҁٜs8i؍;pVYΔ(lO8u9˱c?wazz+QDd5!:.89*"HΖEIlGi+L&GlZT7-UWݨ55umY[ ߃ v;<5۾PKu\*4%Zh.Chapter06/7.ShareDetails.SharePrices-Index.sqlmj0 ~]l%ul?4 cϒt(LOH) zi(g˙("B2N!Gdv@]e8 8Vkt̵Bdu#Bk !g[S|M"R$C6֣Ke +L&Glz)o]n1殥fِUry;F_[[ kh/ 8:OwξPKv\*4 ,Chapter06/8.CustomerDetails.Customers-PK.sqlM 0 EPKv\*4M~<Chapter06/9.TransactionDetails.Transactions-relationship.sqlm 0 9wm:J+]<(@7X[E9Gqgx S 4ΓRoqE@)A8۱GmV'|gPΓn,t:OQ5/ȓA!pKdPI&/ =PKw\*4[PUChapter06/readme.txt vN`\)P %AH|RO tqmЃXBVf.׀PK w\*4 Chapter06/PK x\*4neqf>>Chapter07/1.SetDBOffline.sqlUSE master GO ALTER DATABASE ApressFinancial SET OFFLINE PKx\*4n>"Chapter07/10.RestoreT-SQLPart1.sql]1k0wmYЭAԶRIi)U}NM+Hj@LwmGkC$g" nSD"Tuq[/vqLr(fkP)jԏ5eϴ??PK{\*4DxNbChapter07/15.DetachTSQL.sql1 0PK  5\LT\,HIAϐӸ'#5X1]'rPK{\*4_Chapter07/16.AttachTSQL.sql}; @Z?E`FMR9$@|`ğ-66rvv+&gID<".b(lqNMr)Cȴ7f#N&VuN@̌gz4+mRxhx/8HZӲ,H_ɷө7+<`bSYPK |\*402<<Chapter07/2.SetDBOnline.sqlUSE master go ALTER DATABASE ApressFinancial SET ONLINE PK|\*4!СChapter07/3.FullBackup.sql]= 0Ew6+u-tFY)i *Wqs:˽'"q6@ 'a HkS5+Ԯk^|>*-(Uo&;`4?iDɶE :{/q* LInzwr{1-m&? 3ȗH㾍kK_v@C l `b_!< ov3V;Y*d MXq,钾}GDϺ@őTf2ٞflʵ'yCO+*NTJsG?PK}\*4f{FiChapter07/5.VerifyBackup.sqlQQk0~/?[ªMgXnI 6AJR;lnSAH.ww݅dNa,7^4\GF&edV75@*[}XbJ\KV FYZ-w^A BJ΂Ӈ۠[]Fsc;&49 y{\]~@)N>1扯ޟM9 &I:,EsiLHwH.͛Ϧy3<ئlA0ʼ+xͦQF{PdA*?PK\*4D]$Chapter07/6.BackupTransactionLog.sql]0wXjP@P(%.]jSIE_ӗ})ʪLn&/Fj1# DٙN|УYo3O9^%<rN|=A9TL@|1&JĒuuh6ѽ[-&CANm\$ABOe} g[լO~|Rgc>>M`"2 Mo|PK\*4A#MBZ!Chapter08/10.SELECT 3 Columns.sql vquQp.-.M-r,*.KMՁ$rRRSsSy܂}\RK3s`b^.PK\*4f[Chapter08/11.SELECTAlias.sql vquQp.-.M-r,*.KMUp,VP@\u^.D`Ң<|NjbQjSbNb^rr [ZSrPK\*45j*Chapter08/12.InsertShareDetails.Shares.sql 0{w0K5tiP#Qz֟W;||jF VNN ~AϦ'P4$_q>iՃ:yL&+8Ҽ>b,$i[A`n:&ނU0 O:j5XQ.f EmFq̧QN#ʴw@,?oi7PK\*4i-/L\&Chapter08/13.SELECTSpecificCompany.sql vquQH,JuI-Nq.-*J+ (LNr I$f9ż\A} n!N>>z\PK\*4i[Chapter08/14.SELECTRanger.sql vquQH,JuI-Nq.-*J+ (LNr I$f9ż\A} 6v n!N>>z\\珤WPK\*4e7fChapter08/15.SELECTRowcount.sql v Qw Q0 vquQRp UH,JuI-I)sAJPK\*4gB#Chapter08/16.SELECTTopVRowcount.sql vquQP0VRp UH,JuI-I)sy]CÝCBA|F#5ho#PK\*4?> Uv$Chapter08/17.SELECTConcatenation.sql vquQp.-.M-r,*.KMUVPBmO"T1XAPrIM,JMqJIKNUҼ\nAp.%9z0~1/PK\*4}n,`)Chapter08/18.SELECTConcatenationALIAS.sql vquQqu p.-.M-r,*.KMUVPBmO"DB@S1XAQrIM,JMqJIKNUҼ\nAp.%9z0~1/PK\*4"Gj Chapter08/19.SELECTWithOrder.sql vquQqu p.-.M-r,*.KMUVPBmO"DB@S1XAQrIM,JMqJIKNUҼ\nAp.%9z0~1/kS$BPK\*4+UV.Chapter08/2.FixupCustomerDetails.Customers.sqln0EH;SijIYpZZ]cVyTYV!QTe̽ܔ!ή*N2+= \\S+oʶm8+I޳n"HMH &UdES޾ؖFg,z')'(Z㮓\)s$flG]j߿ŞSɻ-8#2qޒq1`6KGcxެǁFƅ:7ʾN)Ua`(cxPK\*4Cfq$Chapter08/20.SELECTWithOrderDESC.sql vquQqu p.-.M-r,*.KMUVPBmO"DB@S1XAQrIM,JMqJIKNUҼ\nAp.%9z0~1/kS$Lk3/PK\*4RyChapter08/21.SELECTWithLIKE.sql vquQp.-.M-r,*.KMUVPBmO"D-.ZSr{bSvUPWuϩSPK\*4\uU Chapter08/22.SELECTWithLIKE2.sql vquQp.-.M-r,*.KMUVPBmO"T1X!Ĉr +pI-I)փy=\\I1UA]5OU PK\*4\yUvChapter08/23.SELECT-ERROR.sql vquQp.-.M-r,*.KMUVPBmO"T1X!Ĉr +pI-I)փy=\\|<]UTyPK\*4eChapter08/24.SELECTINTO.sql vquQp.-.M-r,*.KMUVPBmO"T1X!ĈrIM,JMqJIKN KF [ 7%$13X/PK\*4&xfDYChapter08/25-UpdateToBrodie.sql pq qUp.-.M-rI-I)փy]C>%~ NE)\A p!,KiY| &(ܺY+V警;Պɚ O:ԶqSa/PK\*4B@Chapter08/35-RollbackDELETE.sqlsruS rRPPvquQRp Up.-. I-KB\Qp)qrtK*PK\*4l|mF Chapter08/36-Delete3Rollback.sqlsruS rRPPvquQRp Up.-. I-KB\B45Qpi qrtZKPK\*4}7#("Chapter08/37-TruncateCustomers.sql sv qUqtqUp.-.M-rI-I)փPK\*4Пnx@Chapter08/4.CheckConstraint.CustomerDetails.CustomerProducts.sql5A 0@} weO I%:H XL 4".?F2:):c뚟s)=u`v-րhR%aޟݗY%WxӨ)c1xV PK\*4,GqBChapter08/5.DefaultConstraint.CustomerDetails.CustomerProducts.sqls q RqtqUp.-.M-rI-I)փSJK=C<=\y]\C=B\Az@RRrR*]\C}B4 4!nA p5\PK\*4j5Chapter08/6.CHECKCustomerDetails.CustomerProducts.sqls q RqtqUp.-.M-rI-I)փSJK]\C=Bx8A@ }Ksr=\44`%yvHMM^.w^.^.PK\*4|I Chapter08/7.MultipleINSERTs.sqlݑN0 eH6c(VbZR֡$!W_|vY6omTm=Ld`\Chapter08/8.SelectTOP3.sql vquQ cM-^. _p.-.M-rI-I)փyPK\*4Wv"'Chapter08/9.SELECTALL.sql vquQRp Up.-.M-rI-I)փPK\*4cwChapter08/readme.txt% 0 EH  i"]%FS[BccF=n:yx^_7AZQpl)]qᘦ9Er'?,^=?PK \*4 Chapter08/PK\*4w`:U\(Chapter09/1.ShareDetails.Shares.view.sql}mKA04PXj/)h!!.%&˟nj 3sιwθ_- щ:tIMAEj3W =)՝jMkbP=U5TYJ{^넺K/X%ΐݙ:g&iXe +ֿ[ROM˥Z1~ lT=Nu8U zJ_sFwsl,3;GVkW&9g`[ cݗ\+zv4GDĺun}rY"d6ɾmr/bPK\*45Ftp+Chapter09/2.ShareDetails.vw_SharePrices.sqlRa A})]C'$IG͆ҡiwfw߾y3׋ rV3" ő03<=y q1D%rdp̡ Ӫ=|:p46OHj?޷x|vA,#ʹ':[݉.s1LuaE*C~)*kʝoER|4ocIfYeֽ6&߿ѿd*GoPK\*4_r#Chapter09/3.CustTrans-TSQL-Test.sqlMN0;7`QV *Dj鲄 " ͂C?.0t"gޛ7~{]hXZ]hjг ѝ:T>A;U鍻2_Ws[r_)t3@Tq8~Q 7wO؈܇N=sЇڢؙv@Zb%SXnrmQ?::Vʳ^M)d2VtvCF/LKU1uƊkvP9WZ|lAEʐ4#/PK\*4$4z,Chapter09/4.CustomerDetails.vw_CustTrans.sqlJ@E?CMSh#mP|X#f1%Yvwv;;kDCNWJٯb5ԳJ4b*T @z(>l3gp3c⎙XG ;fX|uN.!,U5F<_?.~4+TD3[U̒SFvcOLo/uƆ^W}hQ Ϋ%cP.Ёn7 g0Q6S?*yffL'cJN'm&;_u޹AqFF;Nuo:1]v;~3΀ 9PK\*4`hz 0Chapter09/5.Predata required for SCHEMA view.sqlUN@}g[5!BxŪ V#ŵ6Ajym*EbcCvg[!"1,UK@#L~s23$h"j;%DqP5ې![qD%ý)LOi|ؿ&'g9}F%\i)',"<jKYE !`lRәJOD(J[Ȍg}SykmÌㅨxZ=\8lO.ckL`oVE+&M*̅t|_wzCk%*EPK\*4'1`&Chapter09/6.SCHEMABINDING TestCode.sqluM 0w]JnЅXztLA0&ϢBY{Y IRpM;mlND;`԰j~! $ tu /EZAELesF5;>g(;Dm+p˺l0VyyXN Ny[h7;oׄ7_#PK\*4 /~5Chapter09/7.SCHEMABINDING View vw_CustFinProducts.sqln0EHhЅ&;VƑxG}1F"V\Ϙ@ީI$>$a8"<|GXR$荒ۂ;$&p||}'~^:T93o5bu[Oi^tlb~ 7ta[Gn[nL${((;aa[NZ!~v=KK ;pw ӥjS+UUφC{4h%A4YuQhOg~?] u6MOt;ZwlSPm@5 \;4_D]HJi.o) PK\*4=$'Chapter09/8.DROPandRECREATE of view.sql[O"A&yD 5$>cpX쐸rW.fd1LS{[MU\*ֈVӵԥXuu mհy[a_|{̷3b=s cP1`.y{ ^9^23e-rI{+'w~`ƺ2߻X-'W;"!j"U5-h)LUxUXE|>][ ;W%XNoWV8qӲ/;cb`ua֮N=hCDr6O[IZW=q~8&,+sӊgN8n_Z m_*L5/{YDv5=kܘ"8#ɼc9;=80k}MӢ~Fղj\z1j PK\*4Pgv$Chapter09/9.CREATE INDEX on view.sqlsru qU uUp q ruQsqPȬw.-.q (O)VS$f땕#+*M.)VpLN/++MJ-QJ%jrrPK\*4=CGChapter09/readme.txtH-JU(OUHIMQ(,P(/Kp2Sˋyx2\<^rݤԜJ\PK \*4 Chapter09/PK\*4+Chapter10/00-DemonstratingValueInOUTPUT.sqlPj@ m$C:BYM }tS<Жj9$drmp P!j]6Eb8'aT2lr>c1Y,',ab&fu2^:PK\*4WRGHM%Chapter10/2.RunningFirstProcedure.sqls.-.M-rI-I)K,H+N-*q({U먇gd&EPK\*4:1)&Chapter10/3.RunningSecondProcedure.sql5 0{- Hx 4饽KlVXHҒ Ɵ0M6hk߲irlNAsrBG#%UZ»F ꭪}ozxHQq<և \!xPK\*4b˝)Chapter10/4.SecondProcedureWithOUTPUT.sqlRN@}'j&~Iq*@f6혒P b-ԘO0{.;sfc[0IBԪJ[5=S{d&P )H-orѶѻ}'O{I=dhdi]vZOiO݇ n ih*џװqmH PK\*4;:<Chapter10/5.BREAK.sqlsquq rUp/p/+Q+QpI-.y]C*@b>((\=x0 Bh+" AquF6 `n @ DBԖwiMҗ&&?dVT=(ka0vg &Ym>yD!޼#D?'ёrmsȧ+Yic5gU$<8-e 9RY@cS>mbYPK\*4T#>m'Chapter10/7.FinalExampleAllTogether.sqlUMo@#FҮrrr:%`SEa R)?5>7syog=v& llC vҺ$ChK`w~+@uSNB d%A`EFH,`3]FUU^;E4/ ;)RrnxIK&dI"a;KW+9Kuj 8؀>Agr잱vCo1e(1>L;PMRו 0xo[H냀+T fz `|=!=;[h—&%éNWSRW\+J@`x2g=(S' # vvc֑624)ej)p]?v-#}9h{f 0PȒG8Ce,hQoS6 6Mu)1醴HGfw-kiHqO ǥxHY --[b-=-O؆&+ !PK\*4LMChapter10/readme.txt ; ;tƒg7S 5Ӹ۠ ſظd<+)BJFy;vIi ޙY8\Z{CPK \*4 Chapter10/PK\*4W=lTChapter11/1-JOIN.sql vquQ( H,JuI-N). (LN3\KRy܂}J3sA^~Xd&(Ig-N^.PK\*4U-#Chapter11/10-Variables-2batches.sqlsquq rUptI,IUH%: ΥEEEɩyΩy% y\!p !.! W,m@B@&XTAKKA-W!8#(%$13X)ʅ{]z 0rGX^*^.PK\*4GH|'Chapter11/11-Variables-MultipleRows.sqlsquq rUptI,IUH%: ΥEEEɩyΩy% y\!p !.! W,m@B@&XTAKKA-W!8#(%$13X)Up ,4$ xPK\*4(ĕChapter11/12-TempTable.sqlmN 0^Z)E/,X)MMF/̤;(u8 {cUQL83K[dF\2x<[@Eg3=n MkBJ(Y?%Y`c.,<(N`ts_,쨞%t͙5L^9 PK\*4Ȕq Chapter11/13-GlobalTempTable.sqlmNA 0/ZDڃKVSHI| @ZĤ}cevfwfʆ(5(jrF #FǕ6 >rRn}btz恭йaA'Q֒Feo[RRBHj{0api ;+dSGd\HIbDl ~PK\*4bL=?Chapter11/13.Count.sql vquQp Tp VP+MJ-ROS//Vr UH,JuI-I)syPK\*4TVXChapter11/14.CountFilter.sql vquQp Tp VP+MJ-ROS//Vr UH,JuI-I)sy=\\KRJ2S xPK\*4GIhChapter11/15-Sum.sql vquQp/+Tp VP\R 3KRSy܂}BK2\RK3s=\\KKsS! .!..:&:0}\PK\*4w޹Sc$Chapter11/25-DATEADD-SUBTRACTION.sqlsquq rUpI MUHI,I-2x]C¶ F& E Ff V  u>! .!..:f:0\PK\*4jChapter11/26-DATEDIFF.sqlsquq rUpp,*. MUHI,I-2tSRPDy]C*(&%g()[(CU"E1TscFn $34yPK\*4mWtChapter11/27-DATENAME.sqlsquq rUp.I,IM+q )@$37+5]VAD7(9CL@!W9D1U#\U/PK\*4WnChapter11/28-DATEPART.sqlsquq rUpH,)HuITHI,I-M v AUP72QM,JP0200S020PUquQpq q p HIAѫPK\*4NpoChapter11/29-DATEFormatted.sqle 0E@nIhP l6L!]jPuh.sϭuըNt .mj7û88Pk~M׀B=v)FW2gr:˽W&!`(To]P=iMRm4ʏ٪?RJ^PK\*4Y_Chapter11/3.LEFT-OUTERJOIN.sql vquQ( H,JuI-N). (LN3\KRy܂}J3sA>n! !A ^~X .PA[)\PK\*4wr?YChapter11/30-ASCII.sqlsquq rUp.)KI-.QHH,04 v AUp vPOSu2Wg\PK\*4ܤF_Chapter11/31-CHAR.sqlsquq rUp.)KI-.QHH,04 v AUp vPOSu2Wg $@PK\*4,vBZChapter11/32-CHAR-2.sqlsquq rUp.)KI-.Q+ v AUp vPOSuM2Wg $@PK\*4&HBZChapter11/33-LEFT.sqlsquq rUp.)KI-.QHH,04 v AUPOSus[:c^PK\*4w"5IaChapter11/34-Lower.sqlsquq rUp.)KI-.QHH,04 v AUPOSusk[jcMPK\*4PwChapter11/35-LTRIM.sqlsquq rUp.)KI-.QHH,04 v AUPWn! !A ^~X .PA[)\A 0<B}|xPK\*4ћNpChapter11/40-SUBSTRING.sqlsquq rUp.)KI-.QHH,04 v AUPOSusBpSpHbcW?dMPK\*4^AYChapter11/41-UPPER.sqlsquq rUp.)KI-.QHH,04 v AUPOSusBh@kBVPK\*4XcChapter11/42-CASE.sqlAK0G/UX*=dFvmRORmJ;=^ o&ƑSm=0TE9P0v+GS| m3%:v<%`Yrc/ +Wo~{>#ǜ7^nD `M| 4ÖR::m//%SEduHbP;&,"w~u}PK\*4όDNChapter11/43-CAST.sqlsquq rUppN,.Q+ v rm M@">! Ύ!b" CMMmu]׼u^.PK\*4JHWChapter11/44-CONVERT.sqlsquq rUpp+K-*Q+ v A*[}\C\B434 4u` 5u]RyPK\*4SAOChapter11/45-ISDATE.sqlsquq rUp,vI,IUHH,04 v **($}\C<]C\5ʀPK\*4L AOChapter11/46-ISDATe-VALID.sqlsquq rUp,vI,IUHH,04 v *(($}\C<]C\5ʀPK\*4f@PChapter11/47-ISNULL.sqlsquq rUp,+QHH,04 v *|\C^ݎwq# 2.95h9N"⍉D͒&9|tRï;OPn`RPK\*4*$Chapter11/53-RAISEERROR-improved.sql r v R05000A#cMPK\*4 ?.Chapter11/54-DOUBLE-@@ERROR.sql vquQ0407 \0PK\*4Ԡ'+'Chapter11/55-RAISERROR-With-@@ERROR.sql r v R05000A#cM^`WW`0V@#Ef qM)MŸgkw$^RוKs/PK\*4Y(0Chapter11/58-TryCatch-2.sqlmN0EJ}9Q:DZ%Rc&lqc@w;)xzУn}^ @M qCu=?9AH*Oxath7Pf) i˜=`nn;gWMD#D¡3(ДH=۵} ӯ%>VM#ZyDеZ AY^F5ge}yE8L㉯uj܊To喲/%tua8PK\*4mwChapter11/59-TryCatch-3.sqlmn0D#4?QB)jq=UıdTbW_'@P^̞"e󛳧Վy "Cun?ᅏ%6B]o/wlTdZP蕴 xq꬜4i@V&y<^عPYR8h<(Dآq-8&#yEq$PR;Q %uzqi/PK\*4J^oChapter11/6-InsertForTest.sql v Q WH,JuI-I)s2Sx4\rI,I s u VаC#=cuCt#SC+CG_uRPK\*4̮~z'Chapter11/60-TryCatch-LocalVariable.sqlmQk0'TꃃiZ7PӰj5IRRi[8'|fn E؂l1b!lu ?ps_A PyL0_[|U֭cT'S Z+ gQ6XCc@66 ut޵'(B$I{IsTSᤧZH-l9Ȱ~10瞉a42#L6NM{(Y/@84ǷWPK\*4_Chapter11/7-Full-OUTERJOIN.sql vquQ( H,JuI-N). (LN3\KRy܂}J3sj jB}|CC\=(T*p=Sla{rPK\*4q>LrChapter11/8-CROSS-JOIN.sql vquQ( H,JuI-N). (LN3\KRy܂}J3sj @j=*PK\*4LChapter11/9-Variables.sqlsquq rUptI,IUH%: ΥEEEɩyΩy% y\!p !.! W,m@B@&XTAKKA-W!8#(%$13X)ʅ{]z 0BZ^.PK\*4dUYChapter11/readme.txt ? ;t§*T!bkm;rn@$,4?.~X N-ƚE0VakT؆J.PK \*4 Chapter11/PK\*4BmK$Chapter12/1-MaxSharePriceExample.sqls q RqtqUH,JuI-I)sy]\|+2sKsBEɩ y\\.>A @5(R>!H `&/b$5,Ƃ!Xol[xPK\*4ps1Chapter12/10-CTE-NoCTE.sqlϊ0À|Q5K&]ݣ eі|{["=~0&Qd6fۿ{r(&uZzn+s-('b{4cCUdԌ@{ZbͱW,C0< 7G{Cɧ-%(_C/!!Th(PlXPDh?x ̍4dUWqWVF3%AԥTZ\]_FG +Y55%, г@ 0l,o8DoP;?zB~; XhX}f80w]͔˻뙏i̟\śL cO Yx .n`}NmNvl)X$a Q(ڦZ le{F! űyK"kS KIżt7X›>fϕxF{>?~agp唹--;i^^Kk>K.&,L"W[Ij$B~žYD^ǞWׇKKhKwk ?mum5UII'mzZk:mvW\.ʹV7PK\*4j:Chapter12/13-Pre-PIVOT.sql1 0P3`MI X7C"髿_M[ S*ό ^)@`68Pis fl[x"<8iՂ=N5U1 QhPpcr1VRuPK\*4団[Chapter12/14-PIVOT.sqlmP 0yD,3ՂFJ ! =Z;4Ñ;>?񥂗#eZ= KD^` pdu7% ;?#yXBJ%(qO +m[ DZj+4>Ng%ErR"1zWu/+CÖJ`P#9Jx%5RPK\*4'"Chapter12/15-UNPIVOT-Into-TEMP.sqlmPk0?;\,MѴIQS<W|~#:?o`) -1ΖԌUI"c&攩"L9UF#U !d4߮ PK\*4^Chapter12/17-RowNum-2.sqlen0EwMw]$` l4vuU` Įj6WsM)U>x]9Zđd;P Qr3Gx!#UBp/e.|=]VtKӒ $}ЦX0;-H mmIw.FwW־_ܧָ!Ն/OHޝBgts1q ƿ3_PK\*4uChapter12/18-Rank.sql 0{sW `fU!M3zYy9~W%2J=8+kc è$9YD"!|;xJ8$GHe'젼@\7wTLc+ 6:JB !b g;Y5n;hCz8L,Q %Mz6j@9g][ 2XD2RxGFI{#QOy\^PK\*4.DVKUChapter12/21-sp_tableoption.sql+./ILI/(SP)J+NLq\RK3suxsSsJSJ* RKKu yPK\*4\b#CrChapter12/22-LOB-1.sqlU1 1E@mDFeXI2boCR1z6s#I ]CEU3$) C_yN欕6xs:0nPK\*4?&-Chapter12/23-LOB-Select.sql vquQRp U)J+NL.sI-I)C*PK\*48!}$Chapter12/24-LOB-Update-Dolphins.sqlU1 0FBmU%n.B"vΧ$zv!dL59R@\|V*O;dI8 BA!'8̋)j $R5[kzNG?m>PK\*4W\ReChapter12/25-Update-Raiders.sql pq qU)J+NL.sI-I)C*V v Q/I-V  qPJLI-*V1б* p B13EV PK\*46.4EChapter12/26-Select-Raiders.sql vquQRp U)J+NL.sI-I)C*Vp rEV噢``PK\*4kqChapter12/27-Image-LOB.sqlMj0Db8=Ǜ JKH4)e_9μFzenL"8A힪 ϊ$>¬-$4v4RriǝlEQ+] P3ҼH6EgO9y,(ΨAe-%?PK\*4)z$Chapter12/3-Backup-ReferenceONLY.sqlQak0^oUE7&c 8ݠ Ѧ#LI:Bܽ˻%DQ-B Q #BV˭;F4cf&cc(Eakme%Hh6-a8ojq[1S|%A6D*/D$v3YS3^[ m89О-P̀cq0ٳfҌ0BR! d5kw=&yJW|0nϝz~Dbߣ37Qe$}sFG^0͟~7|#c\muY{N )L>b.;}K~\v:םN۽9?jx<ȑQ\d/$͢xP4,_PK\*4c8?Chapter12/4-IN.sql vquQRPp UH,JuI-I)srA9O? CcSMPK\*4C'rChapter12/5-IN-Subquery.sql vquQRPp UH,JuI-I)srA9O?`FH?H,bsiQQj^I@Qfr&_O? d)MV\G?T AhPK\*4+:>`Chapter12/6-IN-OR.sql vquQRPp UH,JuI-I)srA9[Cz $!cL!S^.PK\*4Y+bqChapter12/7-NOT-EXISTS.sql vquQRPp UH,JuI-I)sA ~! !  XظļgM$OvӅ4ퟘ`x/(a|E&dŞue[>HըWE|Mz^So!ʡ膈Em+$Vg121(PK\*4jMChapter12/9-OUTER-APPLY.sqlUOK 0rYve(Zy5:pI6GP*퇑6PM؏ i$X[F#*9ySݎ`ln'@Li]OX1yt%qHPK \*4R_2##Chapter12/readme.txt Robin Dewson www.fat-belly.comPK \*4 Chapter12/PK\*4 le71 Chapter13/1-CREATE TRIGGER trgInsTransactions.sqlPK\*4Y:wh HChapter13/10-DatabaseTrigger.sqlPK\*4HLd& Chapter13/11-InvokeDatabaseTrigger.sqlPK\*4 ]c=H$ Chapter13/12-DropDatabaseTrigger.sqlPK\*49&q$ Chapter13/13-DatabaseTriggerDump.sqlPK\*4 Oh$ Chapter13/14-EventDumpInvokation.sqlPK\*4Tzs1$ PChapter13/2-Drop-Balance-by-$200.sqlPK\*4w3& <Chapter13/3-ERROR-Cant-Insert-NULL.sqlPK\*4W-@I' +Chapter13/4-Customer-1-Transactions.sqlPK\*4u%J Chapter13/5-Alter-Trigger.sqlPK\*4*Љx# 5 Chapter13/6-DoubleUpdateTrigger.sqlPK\*4 Chapter13/7-Invoke-Trigger.sqlPK\*4h # Chapter13/8-RaiseerrorInTrigger.sqlPK\*4T* Chapter13/9-Invoke-Trigger-NoBalChange.sqlPK\*4QDGI Chapter13/readme.txtPK \*4 A_Chapter13/PK\*4p  Chapter14/1.NewTable.sqlPK \*4 AUChapter14/PKf\*4gr }Chapter01/readme.txtPK f\*4 A!Chapter01/PKg\*4Btk~ IChapter02/readme.txtPK g\*4 AChapter02/PKh\*4I( Chapter03/CreateDatabase.sqlPKh\*4nj`k AChapter03/readme.txtPK h\*4 AChapter03/PKi\*4@, Chapter04/1-Logins.sqlPKj\*4ś Chapter04/2-Users.sqlPKj\*4O> C,Chapter07/1.SetDBOffline.sqlPKx\*4n>" ,Chapter07/10.RestoreT-SQLPart1.sqlPKy\*4D" -Chapter07/11.RestoreT-SQLPart2.sqlPKy\*4'h*  .Chapter07/12.RestoreLogT-SQL.sqlPKz\*4  /Chapter07/13.DetachViaGui.sqlPKz\*4r 0Chapter07/14.AttachViaGui.sqlPK{\*4DxNb <2Chapter07/15.DetachTSQL.sqlPK{\*4_ 2Chapter07/16.AttachTSQL.sqlPK |\*402<< 3Chapter07/2.SetDBOnline.sqlPK|\*4!С 4Chapter07/3.FullBackup.sqlPK}\*4w8H" 4Chapter07/4.DifferentialBackup.sqlPK}\*4f{Fi 6Chapter07/5.VerifyBackup.sqlPK\*4D]$ 7Chapter07/6.BackupTransactionLog.sqlPK\*4K'SW( x8Chapter07/7.AlterTablePriorToRestore.sqlPK\*4*eh 9Chapter07/8.RestoreViaGui.sqlPK\*4K'SW, A:Chapter07/9.AlterTablePriorToTSQLRestore.sqlPK\*4FP]g :Chapter07/readme.txtPK \*4 Am;Chapter07/PK\*4o3« ) ;Chapter08/1.InsertShareDetails.Shares.sqlPK\*4A#MBZ! <Chapter08/10.SELECT 3 Columns.sqlPK\*4f[ =Chapter08/11.SELECTAlias.sqlPK\*45j* =Chapter08/12.InsertShareDetails.Shares.sqlPK\*4i-/L\& >Chapter08/13.SELECTSpecificCompany.sqlPK\*4i[ -?Chapter08/14.SELECTRanger.sqlPK\*4e7f ?Chapter08/15.SELECTRowcount.sqlPK\*4gB# 7@Chapter08/16.SELECTTopVRowcount.sqlPK\*4?> Uv$ @Chapter08/17.SELECTConcatenation.sqlPK\*4}n,`) QAChapter08/18.SELECTConcatenationALIAS.sqlPK\*4"Gj  AChapter08/19.SELECTWithOrder.sqlPK\*4+UV. BChapter08/2.FixupCustomerDetails.Customers.sqlPK\*4Cfq$ CChapter08/20.SELECTWithOrderDESC.sqlPK\*4Ry DChapter08/21.SELECTWithLIKE.sqlPK\*4\uU   SChapter08/8.SelectTOP3.sqlPK\*4Wv"' ]TChapter08/9.SELECTALL.sqlPK\*4cw TChapter08/readme.txtPK \*4 AKUChapter08/PK\*4w`:U\( sUChapter09/1.ShareDetails.Shares.view.sqlPK\*45Ftp+ WChapter09/2.ShareDetails.vw_SharePrices.sqlPK\*4_r# m' kChapter10/7.FinalExampleAllTogether.sqlPK\*4LM mChapter10/readme.txtPK \*4 A nChapter10/PK\*4W=lT 2nChapter11/1-JOIN.sqlPK\*4U-# nChapter11/10-Variables-2batches.sqlPK\*4GH|' oChapter11/11-Variables-MultipleRows.sqlPK\*4(ĕ [pChapter11/12-TempTable.sqlPK\*4Ȕq  ;qChapter11/13-GlobalTempTable.sqlPK\*4bL=? "rChapter11/13.Count.sqlPK\*4TVX rChapter11/14.CountFilter.sqlPK\*4GIh #sChapter11/15-Sum.sqlPK\*4K6OLb sChapter11/16-MaxMin.sqlPK\*4}BN >tChapter11/17-AVG.sqlPK\*4U+a tChapter11/18-GROUPBY.sqlPK\*4K#g IuChapter11/19-GROUPBY-2.sqlPK\*4h  vChapter11/2-JOINonTwoColumns.sqlPK\*4:A6 vChapter11/20-HAVING.sqlPK\*4W=lT }wChapter11/21-PREDISTINCT.sqlPK\*4*l7\ xChapter11/22-DISTINCT-1.sqlPK\*4g.IOy xChapter11/23-DISTINCT-2.sqlPK\*4b1Rb (yChapter11/24-DATEADD.sqlPK\*4w޹Sc$ yChapter11/25-DATEADD-SUBTRACTION.sqlPK\*4j EzChapter11/26-DATEDIFF.sqlPK\*4mWt zChapter11/27-DATENAME.sqlPK\*4Wn t{Chapter11/28-DATEPART.sqlPK\*4Npo |Chapter11/29-DATEFormatted.sqlPK\*4Y_ |Chapter11/3.LEFT-OUTERJOIN.sqlPK\*4wr?Y q}Chapter11/30-ASCII.sqlPK\*4ܤF_ }Chapter11/31-CHAR.sqlPK\*4,vBZ ]~Chapter11/32-CHAR-2.sqlPK\*4&HBZ ~Chapter11/33-LEFT.sqlPK\*4w"5Ia IChapter11/34-Lower.sqlPK\*4Pw Chapter11/35-LTRIM.sqlPK\*4E"{#C[ JChapter11/36-RIGHT.sqlPK\*4In Chapter11/37-RTRIM.sqlPK \*4? >Chapter11/38-STR.sqlPK \*4ϸ Chapter11/39-LTRIM-AND-STR.sqlPK\*4:Sq* ׁChapter11/4.LEFT-OUTERJOIN-WithNoPrice.sqlPK\*4ћNp Chapter11/40-SUBSTRING.sqlPK\*4^AY Chapter11/41-UPPER.sqlPK\*4Xc Chapter11/42-CASE.sqlPK\*4όDN Chapter11/43-CAST.sqlPK\*4JHW Chapter11/44-CONVERT.sqlPK\*4SAO Chapter11/45-ISDATE.sqlPK\*4L AO Chapter11/46-ISDATe-VALID.sqlPK\*4f@P Chapter11/47-ISNULL.sqlPK\*4' @N  Chapter11/48-ISNUMERIC-FALSE.sqlPK\*4E?N xChapter11/49-ISNUMERIC-TRUE.sqlPK\*4;Fa Chapter11/5.RIGHT-OUTERJOIN.sqlPK\*4rKL Chapter11/50-spaddmessage.sqlPK \*4_" Chapter11/51-CustomerOverdrawn.sqlPK\*4-es$ mChapter11/52-sp_addmessage_chage.sqlPK\*4*$ Chapter11/53-RAISEERROR-improved.sqlPK\*4 ?. nChapter11/54-DOUBLE-@@ERROR.sqlPK\*4Ԡ'+' ƊChapter11/55-RAISERROR-With-@@ERROR.sqlPK\*4Ty),% 2Chapter11/56-RAISERROR-Severity11.sqlPK\*4.Y Chapter11/57-TryCatch-1.sqlPK\*4Y(0 Chapter11/58-TryCatch-2.sqlPK\*4mw Chapter11/59-TryCatch-3.sqlPK\*4J^o Chapter11/6-InsertForTest.sqlPK\*4̮~z' Chapter11/60-TryCatch-LocalVariable.sqlPK\*4_ ېChapter11/7-Full-OUTERJOIN.sqlPK\*4q>Lr vChapter11/8-CROSS-JOIN.sqlPK\*4L Chapter11/9-Variables.sqlPK\*4dUY Chapter11/readme.txtPK \*4 AAChapter11/PK\*4BmK$ iChapter12/1-MaxSharePriceExample.sqlPK\*4ps1 8Chapter12/10-CTE-NoCTE.sqlPK\*4- NChapter12/11-CTE-WithCTE.sqlPK\*4 PChapter12/12-Recursive-CTE.sqlPK\*4j: Chapter12/13-Pre-PIVOT.sqlPK\*4団[ fChapter12/14-PIVOT.sqlPK\*4'" eChapter12/15-UNPIVOT-Into-TEMP.sqlPK\*48n Chapter12/16-ROW_NUMBER.sqlPK\*4^ wChapter12/17-RowNum-2.sqlPK\*4u wChapter12/18-Rank.sqlPK\*4q NChapter12/19-DenseRank.sqlPK\*4svzk# =Chapter12/2-Correlated-Subquery.sqlPK\*4u~։ Chapter12/20-NTile.sqlPK\*4.DVKU Chapter12/21-sp_tableoption.sqlPK\*4\b#Cr =Chapter12/22-LOB-1.sqlPK\*4?&- Chapter12/23-LOB-Select.sqlPK\*48!}$ BChapter12/24-LOB-Update-Dolphins.sqlPK\*4W\Re Chapter12/25-Update-Raiders.sqlPK\*46.4E Chapter12/26-Select-Raiders.sqlPK\*4kq Chapter12/27-Image-LOB.sqlPK\*4wҍ Chapter12/28-UpdateImage.sqlPK\*4)z$ Chapter12/3-Backup-ReferenceONLY.sqlPK\*4c8? yChapter12/4-IN.sqlPK\*4C'r Chapter12/5-IN-Subquery.sqlPK\*4+:>` Chapter12/6-IN-OR.sqlPK\*4Y+bq Chapter12/7-NOT-EXISTS.sqlPK\*4/L Chapter12/8-CROSS-APPLY.sqlPK\*4jM +Chapter12/9-OUTER-APPLY.sqlPK \*4R_2## Chapter12/readme.txtPK \*4 AMChapter12/PKCu