ࡱ> {` n~bjbjFF .,,!!!!dl! %Vh"(""""#*# #UUUUUUUWhYUQt%##t%t%U""U+++t%""U+t%U++nIPM"x" x w!(:K `Q,U0%VZKZ)ZZ@MMZP#h1$J+{$<$###UU+###%Vt%t%t%t%D!! CAST & CONVERT Functions in T-SQL For more information on MS SQL Server Functions go to:  HYPERLINK "http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_9dyr.asp" http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_9dyr.asp CAST & CONVERT explicitly convert an expression of one data type to another. They provide similar functionality. Syntax Using CAST: CAST (expression AS data_type ) Using CONVERT: CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Arguments expression is any valid Microsoft SQL Server"! expression. data_type is the target data type. User-defined data types cannot be used. length is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types. If it isnt specified, the default values are used. style is the style desired to convert the expression to character data (nchar, nvarchar, char, varchar, binary, or varbinary data types). See the following tables and information for the specific styles available. This table shows the style values for float or real conversion to character data. ValueOutput0 (default)Six digits maximum. Use in scientific notation, when appropriate.1Always eight digits. Always use in scientific notation.2Always 16 digits. Always use in scientific notation. This table shows the style values for money or smallmoney conversion to character data. ValueOutput0 (default)No commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 4235.98.1Commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 3,510.92.2No commas every three digits to the left of the decimal point, and four digits to the right of the decimal point; for example, 4235.9819.  In this table, the two columns on the left represent the style values for datetime or smalldatetime conversion to character data. Add 100 to a style value to get a four-place year that includes the century (yyyy). Without century (yy)With century (yyyy) Standard Input/Output**-0 or 100 (*) Defaultmon dd yyyy hh:miAM (or PM)1101USAmm/dd/yy2102ANSIyy.mm.dd3103British/Frenchdd/mm/yy4104Germandd.mm.yy5105Italiandd-mm-yy6106-dd mon yy7107-Mon dd, yy8108-hh:mm:ss-9 or 109 (*) Default + millisecondsmon dd yyyy hh:mi:ss:mmmAM (or PM)10110USAmm-dd-yy11111JAPANyy/mm/dd12112ISOyymmdd-13 or 113 (*) Europe default + millisecondsdd mon yyyy hh:mm:ss:mmm(24h)14114-hh:mi:ss:mmm(24h)-20 or 120 (*) ODBC canonicalyyyy-mm-dd hh:mi:ss(24h)-21 or 121 (*) ODBC canonical (with msec)yyyy-mm-dd hh:mi:ss.mmm(24h)-126(***)ISO8601yyyy-mm-dd Thh:mm:ss.mmm(no spaces)-130*Hijri****dd mon yyyy hh:mi:ss:mmmAM-131*Hijri****dd/mm/yy hh:mi:ss:mmmAM *The default values (style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121) always return the century (yyyy) ** Input when converting to datetime; output when converting to character data. *** Designed for XML use. For conversion from datetime or smalldatetime to character data, the output format is as described in the table. For conversion from float, money, or smallmoney to character data, the output is equivalent to style 2. For conversion from real to character data, the output is equivalent to style 1. ****Hijri is a calendar system with several variations, of which Microsoft SQL Server"! 2000 uses the Kuwaiti algorithm. Note: When you convert to character data from smalldatetime, the styles that include seconds or milliseconds show zeros in these positions. You can truncate unwanted date parts when converting from datetime or smalldatetime values by using an appropriate char or varchar data type length. Return Types Returns the same value as data type 0. Remarks Implicit conversions are those conversions that occur without specifying either the CAST or CONVERT function. Explicit conversions are those conversions that require the CAST (CONVERT) function to be specified. This chart shows all explicit and implicit data type conversions allowed for SQL Server system-supplied data types.  INCLUDEPICTURE "http://msdn.microsoft.com/library/en-us/tsqlref/lrdatahd.gif" \* MERGEFORMATINET  Notes Because Unicode data always uses an even number of bytes, use caution when converting binary or varbinary to or from Unicode supported data types. For example, this conversion does not return a hexadecimal value of 41, but of 4100: SELECT CAST(CAST(0x41 AS nvarchar) AS varbinary) Automatic data type conversion is not supported for the text and image data types. You can explicitly convert text data to character data, and image data to binary or varbinary, but the maximum length is 8000. If you attempt an incorrect conversion (for example, if you convert a character expression that includes letters to an int), SQL Server generates an error message. When the output of CAST or CONVERT is a character string, and the input is a character string, the output has the same collation and collation label as the input. If the input is not a character string, the output has the default collation of the database, and a collation label of coercible-default. To assign a different collation to the output, apply the COLLATE clause to the result expression of the CAST or CONVERT function. For example: SELECT CAST (abc AS varchar(5)) COLLATE French_CS_AS !"#YZ  ! / 1 S t wff^SB h5CJOJQJ\^JaJhh `CJaJhCJaJ hh `CJOJQJ^JaJ#h?hd[z5CJOJQJ^JaJhd[zCJOJQJ^JaJhd[zhd[z0JCJaJ#jhd[zhd[zCJUaJhd[zhd[zCJaJjhd[zhd[zCJUaJhd[zhd[z5CJaJh5CJaJh `CJ(aJ(hd[zCJ(aJ(hh `CJ(aJ("Y ! . 0 D Z V X f dgd dgdgd dgd$a$gdd[z$a$gdn~     & * , . 0 D X Z \ ̨̨̨̺̺̺̺̺̺ۗۏpbhCJOJQJ^JaJ&hh `6CJOJQJ]^JaJhh `CJaJhCJaJ h5CJOJQJ\^JaJ"hh `0J6OJQJ]^J"hh `0J5OJQJ\^Jhh `0JOJQJ^J hh `CJOJQJ^JaJ&hh `5CJOJQJ\^JaJ%  V X d f h   C D E J K L X } ʼʫʼʗʗʗʗʗʗʉʼʫʗʗʗʗuuʫ&hh{cj5CJOJQJ\^JaJhiQ*CJOJQJ^JaJ&hh `5CJOJQJ\^JaJ hh{cjCJOJQJ^JaJhCJOJQJ^JaJ hh `CJOJQJ^JaJ&hh `6CJOJQJ]^JaJ h6CJOJQJ]^JaJ.f D E K     q w ~ $Ifgd9 dgdiQ* dgd dgd      4 9 E J N R q v w } ~     ?@AӮӚӚӌzzoo`o`o`o`o`o`ohhiQ*B*CJaJphhhiQ*CJaJ#hhiQ*5B*CJ\aJphhhiQ*5CJ\aJ&hhiQ*5CJOJQJ\^JaJ&hhiQ*6CJOJQJ]^JaJ hh{cjCJOJQJ^JaJ hhiQ*CJOJQJ^JaJh{cjCJOJQJ^JaJhiQ*CJOJQJ^JaJ!~  {rr $Ifgd9kd$$If0.*! h0u!634abp {rr $Ifgd9kd$$If0.*! h0u!634abp  @{rr $Ifgd9kdg$$If0.*! h0u!634abp@ABCD{ooooff $Ifgd9 dgdiQ*kd*$$If0.*! h0u!634abpABHNY^dejpr}<=>?@RSTUܷˣˣ˕xxixixixixixix[hJCJOJQJ^JaJhhiQ*B*CJaJphhhiQ*CJaJ#hhiQ*5B*CJ\aJphhhiQ*5CJ\aJ&hhiQ*5CJOJQJ\^JaJ&hhiQ*6CJOJQJ]^JaJ hhiQ*CJOJQJ^JaJhiQ*CJOJQJ^JaJ)hhiQ*B*CJOJQJ^JaJph"={rr $Ifgd9kd$$If0.*! h0u!634abp=>@{rr $Ifgd9kd$$If0.*! h0u!634abpS{rr $Ifgd9kds$$If0.*! h0u!634abpST,BV`p{offff $Ifgd dgdkd6$$If0.*! h0u!634abpUZ\*,-ABUV_`oprs精}}}}rcrcrcrcrcrcrcrcrhh `B*CJaJphhh `CJaJ#hh `5B*CJ\aJphhh `5CJ\aJhhCJaJ hh{cjCJOJQJ^JaJ&hh `5CJOJQJ\^JaJ&hh `6CJOJQJ]^JaJhiQ*CJOJQJ^JaJ hh `CJOJQJ^JaJ&pqsB9999 $Ifgdkd$$If\yw)EV'0)634abp(B9999 $Ifgdkd$$If\yw)EV'0)634abp(B9999 $Ifgdkd $$If\yw)EV'0)634abp(  "#$%./125678BCEFIJKLTUWXef|}hh `CJaJhh `B*CJaJphZB9999 $Ifgdkd $$If\yw)EV'0)634abp(B9999 $Ifgdkd $$If\yw)EV'0)634abp( B9999 $Ifgdkd $$If\yw)EV'0)634abp(#%/B9999 $Ifgdkd $$If\yw)EV'0)634abp(/0268CB9999 $Ifgdkd$$If\yw)EV'0)634abp(CDFJLUB9999 $Ifgdkd$$If\yw)EV'0)634abp(UVXf}B9999 $Ifgdkd$$If\yw)EV'0)634abp(B9999 $Ifgdkd$$If\yw)EV'0)634abp(B9999 $Ifgdkd$$If\yw)EV'0)634abp(B9999 $Ifgdkd$$If\yw)EV'0)634abp(-B9999 $Ifgdkd $$If\yw)EV'0)634abp(,-014567HIKLZ[ij  12459:CD[\^w|̸̪̪hiQ*CJOJQJ^JaJ&hh `6CJOJQJ]^JaJ hh `CJOJQJ^JaJhCJaJhh `CJaJhh `B*CJaJph?-.157IB9999 $Ifgdkd#$$If\yw)EV'0)634abp(IJL[jB9999 $Ifgdkd&$$If\yw)EV'0)634abp(B9999 $Ifgdkd)$$If\yw)EV'0)634abp(B9999 $Ifgdkd,$$If\yw)EV'0)634abp( 2B9999 $Ifgdkd/$$If\yw)EV'0)634abp(235:D\B9999 $Ifgdkd2$$If\yw)EV'0)634abp(\]^)B=))Jdx^J`gdiQ*gdkd5$$If\yw)EV'0)634abp(()W_cpt}&0`hp#    5>BC۹۹۫۝۹ۂhCJaJh1ICJaJhh `CJaJh|CJOJQJ^JaJhCJOJQJ^JaJ&hh `6CJOJQJ]^JaJhiQ*CJOJQJ^JaJ hh `CJOJQJ^JaJ&hh `5CJOJQJ\^JaJ1)     BCEM!"  Jdgdc:u dgdgdgd dgdJdx^J`gdiQ*CDEM "\ԵԠԠziUA5hc:uh `>*CJaJ&hc:uhc:u5CJOJQJ\^JaJ&hc:uh `5CJOJQJ\^JaJ hc:u5CJOJQJ\^JaJ hiQ*5CJOJQJ\^JaJ)j8hhc:uCJOJQJU^JaJ)jhh `CJOJQJU^JaJ hh^MCJOJQJ^JaJh0}CJOJQJ^JaJ hh `CJOJQJ^JaJhh `CJaJhc:uCJaJhiQ*CJaJ\cfp W\agilrsR|||||m}r}}Ƚr^rr^r&hc:uh `5CJOJQJ\^JaJ hc:uh `CJOJQJ^JaJU hc:uhc:uCJOJQJ^JaJhc:uhc:uCJaJhc:uh `6CJ]aJhc:uh `5CJ\aJhc:uh `CJaJhc:uhc:u>*CJaJhc:uh `0J>*OJQJ^Jhc:uh `>*CJaJhc:uh `5>*CJ\aJ$ R|}n~ & F Jd^`gdc:u & F J^`gdc:u & F J^`gdc:uWhen data types are converted with a different number of decimal places, the value is truncated to the most precise digit. For example, the result of SELECT CAST(10.6496 AS int) is 10. When data types in which the target data type has fewer decimal points than the source data type are converted, the value is rounded. For example, the result of CAST(10.3496847 AS money) is $10.3497. SQL Server returns an error message when non-numeric char, nchar, varchar, or nvarchar data is converted to int, float, numeric, or decimal. SQL Server also returns an error when an empty string (" ") is converted to numeric or decimal. }}}}}}}}}}}}}}}~~~~ ~Z~b~e~l~n~&hc:uh `5CJOJQJ\^JaJ hc:uh `CJOJQJ^JaJ hc:uhc:uCJOJQJ^JaJ,1h/ =!`"`#`$`% DyK [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_9dyr.aspyK http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_9dyr.asp$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5y5#vy#v:V 0u!65 5h/ 34p$$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p($$If!vh5*55 5x#v*#v#v #vx:V 0)65E55V5'/ 34p(EDd#$QRV  S 2AlrdatahdbE?<+ҒxֿQD|nD?<+ҒxֿQPNG  IHDRcpTzPLTEx`X@ ` @ @@@`@@@@@` `@``````` @` @` @` @`@ @@@`@@@@@ @ @@ @` @ @ @ @ @@@ @@@@@`@@@@@@@@@@`@ `@@`@``@`@`@`@`@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@@ @@@`@@@@@ @` @ ` @ @@@`@@@@@` `@``````` @` @`ࠀ @` @` @` @ ` @ @@@`@@@@@` `@``````` @` @` @`Ƞ:bKGDH cmPPJCmp0712HsAwIDATx^]Y*͟QTwOr1g?&$/CQµz  $_}:Q-96w~˱{ˋ _-hƎGX >s=B 0+7va,ēNI;n0Sd1 pZqXK+ܼ{d{7|].F^ c|21݀7Ø r#$nMUV![\V1)eSF vߊOMUyN raqOc~,vqs.la(YSɗ#K1&(r4> $"1٩&0&]Vn96Yәa,H!_c(>.wx#;@L(d1tE,w%7%/&{afk)WtN.[1 LpS-+![zVRYq^~[ƒdgRCKsӷHkpoѾV1ۆ1c7&>@9l1 `,G/,v+yzCa"ա%wYn17nd+qM #NJy=v'E2%1C$/yɚ-6+݇IG-A@b/9n HHB/pZR9Acq`1a7.BW2iqD@h]~i9i0Jl78rq~11ٳf':is7m%H͘kU9[J:Ȋ#iNBOO kM3?c"tȿ߫YTgĕ.o"g"-NjڗG@0!{v^ @.S-=M+i &z,X&f?V[Ss}{x c"w|[ w(ʨ(xg'1bO*``1tr2ǩw˜+g'V1CJ.u@Cq߿!'LQs7Yԝs*%yX?+ٳH|eRri J>$~_չ Xo$/ zK0&{#7g_;e+L+m cZk`؉Gc:sε+8;"]IfcM~A޷=S_j,]-Sǰ z[Iל!x'" S3ѡ ޵~O}A clVޓwOb9`EO9[l%,e2ډ8om1vlbw"SGu\O| %ڷ=otz:Lnc!KmO+Ane,93V0RB0_M~Nŋ`B @ə՛\%S&5Y f73ݝ|~GT}JQ)),MR/K06ȵK&/Pf1&cg6^{űə(#kW*f+@l,1ܚ< Cb{lZn+Bȏ81x=H:s HI#~9'<ƀsnћ?jvḺ\TMf8kzehŌŦSO"&߫g+%cǠcI9% s:Z=|XT\`VOYuH68`ԋ^;i?+=ZFsjEtV"Qcn זӲ}Y!laL-}GPV>|:/#qKjt @ 1co0"ExT[m)`yĕ0pBcA0x#ZO74ܕ?>V-TK ZMC s}z&>/fmB䳸qM[/SL`w"le5o^W'Ơ+J@Jɜ+L@5=nX_ A]9.P8fYXaZS}\= j1;1m%\ԀPX$HRzԶDVV%vLMhbdBK8} ]8 XeX-m/X㭾[y)Pzjx<@u?VK[6CE3#P_ztE ǃ c7~QfO88YHNʧv8ANun}X>cq@:ZOd](d@qORu\[{A rrEH@:'m[ɉ,(&d+&\~ce_.' Jw:7+[ ,p"?7D܋ R"=>^ʆ^ h{ լEDOsMM`\ 1 s@~1dP}^v,.H6*˦G "}KΊ:~b'nwڈqЕLJoDY^cz~W/h\`\]KwcAM9m P(hLcezqnf"#Eċ5L |Ca/C>/é{B@(`+IJ7g!.{ES4IlgHC$ȭYLV޸S:n)Et+a1i]$ V=^:Lq#:oR_~'U XLfnRP蓁j;D`{ m+e W:et^8'U C6?axt;}L IŕDSh_;<~Ǽ*tZ"{q1yByfw݉nWkkh ҶPG*C@= \Z %=%J}ܓ:&maH5asK$RFz§B@=WayX`N?QWbAA_)9b8tzc&Z4z"mxiհIԡ0.DTWYܗ9v1&d-qޞ+ "V/T]/^3`+tTpc{F[1&ɨp(I$pL(\t& LJ Sk:{͋Bsm $R8t⠺^1qA܄1/ֻ{"a?kcP1<(N=&/5{t,d"H0A 2U 0ٵ^DHlX6<$.>öcz]p@AѸx_d5x=TŠU}c~{BcQD5tHCǒ=grL_0\/:o>tEćޣ/촷ʹXzm~C/Npa,][0!U#1osXWAP^T2b,*-v1qJlSߧ:`2?4NP+⭁ ^$C*6|r"dƕ:Q`,ci[Z(=?܅.ˏQB+2q'TW һc1x1oo"Ͽ[u}~ =vZ+Oc-ePV_#a,43^.}K zl+#N~l[5ں !*tdܞ4q ]~F<NJ#qRXۓdcڟd߈1QBsD, =!ʑZ݇c61HbsxZREØq{(jaT 4XnjtTaJ c@Ɉ\h<$*Fb^O_5#r6" fl eGb:o26wozX^6";Gf֢DZëֶz#Whd-ZRa 6tlX`,$^b->e9xdK]8:czz v7{IJM}[#fAe1kSYq,vxEz;=RZc^A? F*>טMB2WFżelڳ a"?Lc^oYGccrTsGQHQkxUW e-`e|`>?-\{i$%y>)\Z4ƶ覙s c#3nd.p >><vmk۶r+nf3feD*Aom.A~'>\ yc;aIdg.l} ǵԼk0^ +˺kI#{?`ӲdRۿ ^HaJ^pt\(n(9j֢ͬa0yyXZ ^{g1X1<$l;Пr>իŐW޾0G Wj%,naMFΔ\QX38]Z$/"rfVX.PNd(fw,yf_֢+^9Gƾ3mcgq' \S|%q=d8 /hYdԫCGx8xn>AaEТ@{\9ϝqn~ CDOgcSq<HB%uz=7=}x{\x'2E]}j 9=vƍw%JT7|1c^6_uc2w gVny1 ^*?;(A67dNq>d3a0A{agEa0b](8" f GBa0$> B=le1Q Jx?9aa 8^p 0?(@$rzw hw4oYMǚH,UZSBī<+zRS\Y3iJØ=VWaycgڜtƍw@t3X~?BSDBzu W;.9(JΓdEs^Y-~N1{02pÔ&?waςz&>wIG\HQ- %5-Pss&8eIe0c-|$,/A6a (?͢<#f>g# *{Ȏ I= {=t2}(}c QXg(zmrUaeG[cE yzL~eg㶂N'~qzelT3ߩǐ/C}C]I)[⏷ c6^a,zqy ׾C+-:>ޕCxBa Oh4.]9K V&rFO1B T ;uzגj[q t:Ċ>mhNz[M0Øal 0ƾ3Hmcgq' \Ļ0>7Ba+?֑u*wAdא`ZRd;(ڍ` $[2$^QE]jpcj)X՜#Il,?wac{Sa8)M}۶ d6u(EfOlXwT|LRTk58Фv5GydLǕx O&~ҏ|Q,WJRaW(q'`0rӴ;eƇeQ$Rc0-kkIFu06`lw<ʃO#G[-:CRGn]mclO9nqo(E =_ja1&ڪƲ`s1`{KѨ cǘV~@f<Ɗ]~ >ʵܞ jxYt+dZ.,zԫEM c^P3Ic's\vV~  ;Uy1v>JVl`#1d)2|۳ʯ]0f;goc fqϐq 8E'Q b[:!v((ehܫrc`vl=\UĴ}0FGpa 8,>QDγekp@}X)uWGբ$Kg<)nM碞CØIQ0=pF|~{93m%1cXb^﷑ )cqē]n\oc1 F&&w'[~,adEh+_QyyT[>m3"ȣ}mWdW>^t H0ӏ?mغq0=VR{h՛cg0یxow(ʗ|~by^z/q=ԫ^Q@YJ)oE9.pIQpm_%z1/z E{ FWtrqYwpc[/rV/=,~"=rc;^pᚥ,2"*]Mdc,o(7ɑ׫_7ebp^\wE 3B)/\ cJs;6{u^WvE\2ƚx#:\WFChm#y@غX[ƈdj/ #d ,A]+Cu{aalƮ%ؚ|X Qط1va=$xp(W$/ʵo/K+^U7^D ŁGqY}YR$Z@k}?6j~t&{ <<7s+eS|g,dۓkB%mzeay^NF2qAܞb5uHƕmyg`97-?6W??Ę'G9lQ?|{IJ"xM-~aoEJqz㓴`R~Oϟwvl:&AJGWTפˁC*[s1f`amͿFbUcR?X5rf(F.d X%XQgqI]EfxMc0ޮ ԛ?Kj4z%&[vxϫWJR ˜7dcƻ ,BiXƩ/s!RIѩj eH}uIJXǕy^6ʏ!'y:}`e͡ 7y VsQC%cO7_(pM:/Q^8%xx/Yh^?Q?<ǎlnn1+Ҵ+1^؎B1k>w똄h[Q|?&%#+EM_Wv0T[@~yրR,?p 'a+glƚT8&RruVs֢ͤ[/7r#[[DGt݋1q'XpJ >?=;3oP?uyó' qHz%Fu8[v$pI-6oYgL.ថ,w2{"0 VZË>(0gy#NvaU$Ћ^^u^/}mE Mh:F,o1h1'VN(!E c-EdSb(,wd {슴wsns'a[a`4=fz,r."Sܳ>ύ%0Og}Ae]Hֺ]Vnj>gZ\iqekX'jpI.P42',?AwȆ՚M/iL$ɜ"9}D|b?u=`GĄ󌯼HY^ۘ%k3 CaM}#codx.].C7XKi+d]()8Y=D~d0}Qy<(/x>!` }^Aρ9޻m)[={/}[Q XX(mX /%@͹=8 \=R8e eWj{&6N s1cM!0v?Sle*VVV,9cO$͙wh5[nzGFy"*$.0vi165`SvQR%Jw;?;dCgOOX07حEër3}Y.ƄXXQ4[9/a1I|_Ѭ7tz.UΧ,,\ub͋Jb#ȑDlFFBCtΩ5Jw+# &<91S;vD1H1[NbS/i"Cʏa=Fꖉb2ڶ28ae9h^Egٿ? /s_ݨkoc7,ݵaNaCV$\ja,}pfc.w';w1-c 6](">Sq'y|̦I8߲gb8H8D(e[QCM= "lȧ 86^AQAPSl9scl}(*.%[SLp)l׺5j&!')b\z$(jaĝaρ$eU4r3fVB[,Xp^ [񨸌 c6 k7goceV_u j2|~DVQjb%>b*1"E7t[^0l 1i>lQtaq1}$g[ٷ3ݐysֲ`Mnx-9Љ^Qc4G19CY_z G:@eL/]OR\q{ $ha0aoإ]9Fk}[heA=G=Vx1fb-c9a,20 g ꚸŕ;pXڸ2}ܑ&t{Ķkƅkx/͏e΅g8ۖخ l"ۢ݅hFыc4nKN:_йk"<VƘ`RmR^$Øae83}cj+^{Xpc{.`>QZRXdL:s-?q(Gطm .b33ˏw /L>ԡ?waEkhq3]֫St{!8é_H`,8xy<^846;j0c{ Vʠ:${`ez R *XS>xy{M"!jq_05BBUEɋhLz>,Qƪ|تaLxOvlb=8E5|U0faŽXH1ŕ`+uiP;-?F&}X% šB2ǖ1ϧ$8hH<`ze QNxb6$yBEl jƻAX7݉A`T~ \0i5ZG鱏.N`X:p$~-5鱏1Dv0vxEx8pl+ cV;]%ܞrqJ07"Eb{uºS@c4-sQPqhUY ,ȃ08w*LgT DEhka*+ uy[xըq3XaLOc(~9uEī J+Gƽz?qR0^MǵvI,13y+0vvDaEXtV[|~us2jz,#|uwV"LW&mYH9rӃ &W?c'`D%Pn=rT\ZU^󯲘a܌ }rOx /r€Ken-GPp 惪=f,Xz,P' cΛC*Xp FѶ2F˼d?fzz,y_am_oR9<%z>?vnK\ZªŕBţAAz O+sHH¤Bt8̅O3L!:=Z'[~,E93UqeH3nּ~->X{y~'!4(j$,D{}DHEQ53c? |?M,PaſsAz:,OC+Ͻ@)rGXc섽żs `NqF޺qeV&'͖%} Xu;1P2I(L.қw׌(_yiA\W ~q\RaǢ6-])Øh p;)oa_fwxSun{|7?a_ﶂo{|˻>Wg" q#Kz.]BJ@.¸YD‘FTW5#*^<8{LWt .=}#h 4_)cwE(hc7=3OWߍ1B*ˌa(6=MnǙ5ZٻA64^蜭Y2GnWxItzc~+؆ ko:0MX8-|-V_+{%z1E:0a4囤A!B=+.gT@c?GEg"_2TP2[Oa&:a$Ƙ|ɺ9.{(e*ej8q7 E 1MpO35T1/L=W%5od9_oh?u*"bvhrؚqmxm7*d!_t%-ieݼ/N^~ &XPTI-X/YMr@c}ٌ+!R~<< c0&n1'O?scYg5m5EOOX>%sͧ&HI(|#eM_+YqUR(qZgNcGo?G #&XP,AEcQG {5bz*SXaiVF_MT-(1wκEcAX5n *q]K1ԑJk\L\/ѬCٵ`<1 oq#6h )gSuYcŅvb,>l==& hcc5mxARa,{)(Lڰ(*"*^\)zt_i!MPj|xzT= B'!dgDGWSQ =RB ʏP΋ᬜ4cV|]6ZtMPL_e\cR!eYg azӛK`=.ҧ>#g>e/jLa35]& ּIENDB`L@L Normal$CJOJQJ^J_HaJmH sH tH :@: Heading 1$@&5\8@8 Heading 2$@&>*P@P Heading 3 $ `@&^``>*N@N c1 Heading 5 <@&56CJ\]aJT@T ` Heading 6 <@&5CJOJQJ\^JaJDA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k(No List 4B@4 Body Text5\6U@6 Hyperlink >*B*phX^@X u Normal (Web)dhxB*OJQJ^JphLO"L c1indentdhxB*OJQJ^JphBb@1B 6ZB HTML CodeCJOJPJQJ^JaJDOBD 6ZBtldhxB*OJQJ^Jphe@R `HTML PreformattedP 2( Px 4 #\'*.25@9-DM B*CJOJQJ^JaJphJObJ `labeldhxB*OJQJ^JphHOrH `minidhxB*OJQJ^JphHH ", Balloon TextCJOJQJ^JaJjj c:u Table Grid7:V0"Y !"-]^hDEKqw~  @ABCD=>@ST,BV`pqs       # % / 0 2 6 8 C D F J L U V X f }  - . 1 5 7 I J L [ j     2 3 5 : D \ ] ^ ) m     BCEM!" RB 00000H0H0000000H0H00000000000000000 0 0 0 0 0 0 0 0 0 0 0 00000 0 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000000000H0H0H00 H0H0H00E0E0E0E0E0E0E 0 0 0 0 0 0 0 AUC\}n~ $08:;@f ~ @=Sp/CU-I2\)n~!"#%&'()*+,-./12345679<n~YXC8@0(  B S  ?_cast_and_convert^Q;l_Q;俊`Q;aQ;/= bQ;TcQ;'dQ;   B*urn:schemas-microsoft-com:office:smarttagscountry-region9*urn:schemas-microsoft-com:office:smarttagsplace 8M"%^gs}$(>@PT   % ' ( + , . < > @ B L T }        ' 7 C j t u }       " # 1 : ? D L M [ W _ c p q v #il`cho|69EJLSvy"X;B",-/hjEJKMA&+3333333333333"Xo"Eq  >@-pq}  . 7 J j   3 D ) C EM "% wvhD\ϲ.SnFl+8~2$6F>2^O5$FMc8'| QBp}qW) rd)X6vLbh ^`OJQJo(h ^`OJQJo(oh pp^p`OJQJo(h @ @ ^@ `OJQJo(h ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h @ @ ^@ `OJQJo(oh ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h   ^ `OJQJo(h ^`OJQJo(oh !!^!`OJQJo(hhh^h`OJQJo(hHh88^8`OJQJ^Jo(hHoh^`OJQJo(hHh  ^ `OJQJo(hHh  ^ `OJQJ^Jo(hHohxx^x`OJQJo(hHhHH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH8 ^`o(hH.8 ^`hH.8 pLp^p`LhH.8 @ @ ^@ `hH.8 ^`hH.8 L^`LhH.8 ^`hH.8 ^`hH.8 PLP^P`LhH.8 ^`o(hH.8 ^`hH.8 pLp^p`LhH.8 @ @ ^@ `hH.8 ^`hH.8 L^`LhH.8 ^`hH.8 ^`hH.8 PLP^P`LhH.h^`.h ^`OJQJo(hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.^`CJOJQJo(^`CJOJQJo(pp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L.h @ @ ^@ `OJQJo(oh ^`OJQJo(oh ^`OJQJo(h ^`OJQJo(h ^`OJQJo(oh PP^P`OJQJo(h   ^ `OJQJo(h ^`OJQJo(oh !!^!`OJQJo(^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L. w$6F}qhD\) r\5 | QO5$X6vpc8.Sl+                                                                                                    :5CJ8% R o9u1- Fg 7BsXd#,}a$5CJY v')+C.S/~Tb051{D4k810+G)2H+5Zq.8o9">SV?}@7B0nZD}@{DNF G 0+GfGC2I)+ 6IY v'2M.8!N,TaiNvZS8% S,T3UfG W! ]sX! ]~TbhwdyyIe)2Fg)X_lV?plvcnC.(oIpQxZq\saiNvQxyf|NF,}I('C iQ*",T.06ZByB,E1ISzR `f{cj*sc:ud[zt$~YA c b9BtJ | uK:?c1^M0}qw~  @A=>@ST,BV`pqs       # % / 0 2 6 8 C D F J L U V X f }  - . 1 5 7 I J L [ j     2 3 5 : D \ ] @L 0@0 0@000@0@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New5& zaTahoma;Wingdings"qhDZ&ډ&4cUd +d +#``724d 2QHX(?,E2*You want to create tables with SQL because Engineering ENGINEERING@         Oh+'0   4@ ` l x ,You want to create tables with SQL because Engineering Normal.dot ENGINEERING85Microsoft Office Word@ @p@PP@&[d՜.+,D՜.+,t0 hp   City College of San Francisco+ G +You want to create tables with SQL because Title8 8@ _PID_HLINKSA*'[http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_9dyr.asp  !"#$%&'()*+,-./0123456789:;<=>?@ACDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuvwxyz{|}~Root Entry F wData Bc1TabletZWordDocument.SummaryInformation(DocumentSummaryInformation8CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q