ࡱ> qsp5@ kbjbj22 "lXXkZ$Z$Z$Z$ f$,2%%%%%%%%G2I2I2I2I2I2I2$3R6m2](%%](](m2%%2-,-,-,](%%G2-,](G2-,F-,s,s,%% 5@Z$o)"s,,202s,6)6s,6s, %v&T-,h&D&%%%m2m2"Z$#, Z$DATATYPES AVAILABLE IN SQL SERVER Numeric Integer Datatypes  Used to store Approximate range Amount of storage used NotesINT or INTEGERwhole numbers-231 2314 bytes (31 bits for magnitude and 1 for sign)SMALLINTwhole numbers-32768 - 327672 bytes (15 bits for magnitude and 1 for sign)TINYINTwhole positive numbers0 - 2551 byte Numeric Floating Point Datatypes  Used to store Approximate range Amount of storage used NotesREALnumbers with up to 7 digits of precisionnegative or positive numbers within the range of 3.4e-38 to 3.4e+384 bytesPlatform dependentFLOAT (n)numbers with up to 15 digits of precisionnegative or positive numbers within the range of 1.7e-308 to 1.7e+3088 bytes (if value for n is omitted)If you specify a value of n between 1 and 7, youve defined a REAL datatype. If you specify a value of 8 15, it is identical to not specifying at all.DECIMAL (p,s) NUMERIC (p,s)decimal numbers with exact storage allowances(1038 - 1) to (-1038)2 17 bytes (depends on p)p = precision (number of digits that can be stored to the left and right of the decimal point. Default: 18) s = scale (number of digits to the right of the decimal point. Default: 0) Character Datatypes  Used to store  Approximate range Amount of storage used NotesCHAR (n)character data fixed length8,000 ANSI charactersn bytesEach symbol or char is stored as 1 byte. If a text string is entered that is fewer than n chars, blanks are addedNCHAR (n)character data fixed length4,000 Unicode charactersn bytesVARCHAR (n)character data variable length8,000 ANSI charactersn bytesCan also specify this by the keyword char varyingNVARCHAR (n)character data variable length4,000 Unicode charactersn bytes Date/Time Datatypes Used to store Approximate range Amount of storage used NotesDATETIMEDate and time values (stored together)1/1/1753 AD to 12/31/9999 AD8 bytes (4 bytes for the number of days after or before the base date of Jan 1, 1900 and 4 bytes for the number of msec after midnight.)Accuracy to 1/300th sec. Values are rounded downward. For example: 4.003 is stored as 4.000 4.006 is stored as 4.003 4.009 is stored as 4.006 Default format is MMM DD YYYY hh:mmAM/PMSMALLDATETIMEDate and time values (stored together)1/1/1900 AD to 6/6/2079 AD4 bytes (2 bytes for the number of days after Jan 1, 1900 and 2 bytes for the number of minutes after midnight.)Accuracy to 1 minute. Specialized Datatypes  Used to store Approximate range Amount of storage used NotesBITData that can be represented in only two states.1 or 0 only1 bitWill not allow nulls. Corresponds to Boolean datatype in other DBMSes and programming languages. Cant index columns with this datatype.TIMESTAMPCounters (Actually it is a VARBINARY (8) datatype Not a date/time)A counter value is automatically added to the column whenever you insert a new row or update one. Specifies sequence of operations SQL Server has performed. Always unique. Can allow nulls. Only one column of a table can be this datatype.UNIQUEIDENTIFIER16 bytesGlobally unique identifier (GUID) It is used to maintain uniqueness among all records when data is collected from many different tables in many different databases.BINARY (n)Bit patterns that consist of up to 8,000 bytes.n specifies the length of all bit patterns for 1 8,000 bytes. VARBINARY (n)Bit patterns that consist of up to 255 bytes.n specifies the maximum length of all bit patterns for 1 8,000 bytes.  Text and Image Datatypes  Used to store Approximate range Amount of storage used NotesTEXTLarge amounts of character (text) dataCan store from 1 2,147,483,647 bytes For example an entire resume.Data is stored in fixed-length strings of characters in an initially allocated 8KB unit. Additional 8KB units (pages) are dynamically added and linked together.When you insert data into a column with this datatype, you must enclose the data within single quotation marks. Cant use in ORDER BY, GROUP BY or COMPUTE clauses. Lots of other restrictions.NTEXTLarge amounts of unicode character (text) dataCan store from 1 1,073,741,823 bytesData is stored in fixed-length strings of characters in an initially allocated 8KB unit. Additional 8KB units (pages) are dynamically added and linked together.When you insert data into a column with this datatype, you must enclose the data within single quotation marks. Cant use in ORDER BY, GROUP BY or COMPUTE clauses. Lots of other restrictions.IMAGELarge amounts of binary data. Sometimes used for embedded OLE objects that are part of a row.Can store patterns from 1 2,147,483,647 bytes in length For example a picture or drawing.Data is stored in fixed-length byte strings in an initially allocated 8KB unit. Additional 8KB units (pages) are dynamically added and linked together.Usually, data stored in an image column isnt directly entered with an insert statement. Cant use in ORDER BY, GROUP BY or COMPUTE clauses. Lots of other restrictions. Money Datatypes  Used to store Approximate range Amount of storage used NotesMONEYSMALLMONEY #$f & T=?^MkhVe4 hE~H* hE~5hE~hE~5CJ aJ "#$%?@AOPbcz{ $$Ifa$$If$a$kKEEEEEE$Ifkd$$Iflr P(#|)t U T t0644 la 0 1 KEEEEEE$Ifkd$$Iflr P(#|)t U T t0644 la1 2 : Q Y ` a KEEEEE$Ifkd$$Iflr P(#|)t U T t0644 laa b c d e f g KIIIICC$Ifkd|$$Iflr P(#|)t U T t0644 la $$Ifa$$If , 8 @ H KEEEEEE$IfkdP$$Iflr ,0* p t0644 laH [ \ f Ekd$$$Iflr ,0* p t0644 la$If Ekd$$Iflr ,0* p t0644 la$If    Ekd$$Iflr ,0* p t0644 la$If    & $$Ifa$$If & ' 0 N d l KEEEEEE$Ifkd$$Iflr$ |)  t0644 la !)*KEEEEE$Ifkdt$$Iflr$ |)  t0644 la*+7YowKEEEEE$IfkdH$$Iflr$ |)  t0644 laKEEEEE$Ifkd $$Iflr$ |)  t0644 laKIIICC$Ifkd $$Iflr$ |)  t0644 la"#56MNT $$Ifa$TU^t,ICCCCCC$Ifkd $$Ifl.r$ ,8|)  P t0644 la,cp$If 8@KEEEEEE$Ifkd $$Iflr$ ,8|)  P t0644 laECkdp $$Iflr$ ,8|)  P t0644 la$If $$Ifa$!R^dzKEEEEEE$IfkdD $$Iflr s)t k=l t0644 la>?@Ekd$$Iflr s)t k=l t0644 la$If@/0ABEkd$$Iflr s)t k=l t0644 la$IfBCLo.Ekd$$Iflr s)t k=l t0644 la$If./0rsEkd$$Iflr s)t k=l t0644 la$IfECCCCkdh$$Iflr s)t k=l t0644 la$If,-?@WX^ $$Ifa$$If ^_drKEEEEEE$Ifkd<$$Iflr s2)t k= t0644 la239h1Ekd$$Iflr s2)t k= t0644 la$If1WEkd$$Iflr s2)t k= t0644 la$IfLECkd$$Iflr s2)t k= t0644 la$If    ./FGM $$Ifa$$IfMNTUVWXKEEEEE$Ifkd$$Iflr s2)t k= t0644 laXYdefghKEEEEE$Ifkd`$$Iflr s2)t k= t0644 lahijkKIIkd4$$Iflr s2)t k= t0644 la 1h/ =!"#`$`%$$If!vh5t 55U5 5T#vt #v#vU#v #vT:V l t065t 55U5 5T$$If!vh5t 55U5 5T#vt #v#vU#v #vT:V l t065t 55U5 5T$$If!vh5t 55U5 5T#vt #v#vU#v #vT:V l t065t 55U5 5T$$If!vh5t 55U5 5T#vt #v#vU#v #vT:V l t065t 55U5 5T$$If!vh5 55p55 #v #v#vp#v#v :V l t065 55p55 $$If!vh5 55p55 #v #v#vp#v#v :V l t065 55p55 $$If!vh5 55p55 #v #v#vp#v#v :V l t065 55p55 $$If!vh5 55p55 #v #v#vp#v#v :V l t065 55p55 $$If!vh5 5555 #v #v#v#v#v :V l t065 5555 $$If!vh5 5555 #v #v#v#v#v :V l t065 5555 $$If!vh5 5555 #v #v#v#v#v :V l t065 5555 $$If!vh5 5555 #v #v#v#v#v :V l t065 5555 $$If!vh5 5555 #v #v#v#v#v :V l t065 5555 $$If!vh5 55 5P5 #v #v#v #vP#v :V l. t065 55 5P5 $$If!vh5 55 5P5 #v #v#v #vP#v :V l t065 55 5P5 $$If!vh5 55 5P5 #v #v#v #vP#v :V l t065 55 5P5 $$If!vh5t 5k5=55l #vt #vk#v=#v#vl :V l t065t 5k5=55l $$If!vh5t 5k5=55l #vt #vk#v=#v#vl :V l t065t 5k5=55l $$If!vh5t 5k5=55l #vt #vk#v=#v#vl :V l t065t 5k5=55l $$If!vh5t 5k5=55l #vt #vk#v=#v#vl :V l t065t 5k5=55l $$If!vh5t 5k5=55l #vt #vk#v=#v#vl :V l t065t 5k5=55l $$If!vh5t 5k5=55l #vt #vk#v=#v#vl :V l t065t 5k5=55l $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 $$If!vh5t 5k5=55 #vt #vk#v=#v#v :V l t065t 5k5=55 @@@ NormalCJ_HaJmH sH tH DAD Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List HH  Balloon TextCJOJQJ^JaJkl"#$%?@AOPbcz{ 012:QY`abcdefg,8@H[\f &'0Ndl!)*+7Yow"#56MNTU^t,cp  8 @     ! R ^ d z  > ? @ / 0 A B C L o . / 0 r s ,-?@WX^_dr239h1WL    ./FGMNTUVWXYdefghijmM90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M90M900*0*M90M90M90M90M90M90(M90(M90(M90(M90(M90(M90(M90(M90(M90(M903M903M903M903M903M903M903M90;M90;M90;M90;M90;M90;M90;M90CM90CM90CM90CM90CM90CM90CM90CM90CM90C0000 000 00 00 00 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 00000 00 00 00 00 0 0 00 0 00 00000000 0 0 00 0 00 0 0 00000 00 00 00 00 0 0 0 0 0 000 0 0 00 0 0 0000 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 00000000 00 00 00 00 0 0 0 00 0 000 0 0 0 0 0 000 0 0 0 00 0 000 0 0000000 00 00 00 00 0 0 0 0 0 0 0 0 0 0 0 0 0 00k1 a H & *T,@B.^1MXhk !"#$%&'()*+,-./012345ks ,s s Ds \s s  s s >! , f m)% 4 q m8*urn:schemas-microsoft-com:office:smarttagstime8*urn:schemas-microsoft-com:office:smarttagsdate 01121753190020793169999DayHourMinuteMonthYear                    5>~>F  " * % - JQ^f m0 1 m33%>AOPbcz{:bg,78f &'l\w"#56MNUp ?    R d C L ,-?@WXd3Y[hmm Alden Cramer Wendy KaufmynVe4E~$@Obz012:QY`abf@H[\f&'0Ndl!)*+7Yow"5MTU^, 8    ! R ^ d > ? @ / 0 A B C L . / 0 r s ,?W^_dr239h1WL .FMNTUVWXYdefghim@  7 k@@UnknownGz Times New Roman5Symbol3& z Arial5& zaTahoma"1hcrfwfZrF _ % _ %#`24daa3H(?Ve4!DATATYPES AVAILABLE IN SQL SERVER Wendy KaufmynOh+'0 (4 P \ h t"DATATYPES AVAILABLE IN SQL SERVERcrATA TATATA Normal.dotVWendy KaufmynLA3ndMicrosoft Word 10.0@Ik@÷@ @@ _՜.+,0  hp  CCSF E% aA "DATATYPES AVAILABLE IN SQL SERVER Title  !"#$%&'()*+,-./012345689:;<=>?@ABCEFGHIJKLMNOPQRSTUVWXYZ[\]^_abcdefgijklmnorRoot Entry F@tData 71TableD6WordDocument"lSummaryInformation(`DocumentSummaryInformation8hCompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q