home *** CD-ROM | disk | FTP | other *** search
/ Piper's Pit BBS/FTP: ibm 0430 - 0439 / ibm0430-0439 / ibm0438.tar / ibm0438 / SQL42108.ZIP / SQL421A.008 / SQL / CLIENTS / WIN16 / NETSETUP / HELPSQL.HL_ / HELPSQL.bin
Windows Help File  |  1994-01-25  |  187.6 KB

open in: MacOS 8.1     |     Win98     |     DOS

browse contents    |     view JSON data     |     view as text


This file was processed as: Windows Help File (document/hlp).

ConfidenceProgramDetectionMatch TypeSupport
100% dexvert Windows Help File (document/hlp) magic Supported
100% dexvert Multimedia Viewer Book (document/multimediaViewerBook) magic Supported
1% dexvert Debian floppy split (archive/debianFloppySplit) ext Unsupported
1% dexvert Sound Images sound sample (audio/soundImagesSoundSample) ext Unsupported
1% dexvert STarKos tune (music/sTarKosTune) ext Unsupported
1% dexvert CADVANCE drawing (image/cadvanceDrawing) ext Unsupported
1% dexvert DESI-III drawing (image/desiIIIDrawing) ext Unsupported
1% dexvert MS-DOS PMODE extender executable (executable/msdosPMODEExtenderExecutable) ext Unsupported
1% dexvert Alien Trilogytextures (other/alienTrilogyTextures) ext Unsupported
1% dexvert APT cache data (other/aptCacheData) ext Unsupported
1% dexvert CADVANCE 2D symbol (other/cadvance2DSymbol) ext Unsupported
1% dexvert Cakewalk Groove (other/cakewalkGroove) ext Unsupported
1% dexvert Comic Book Creator Background (other/comicBookCreatorBackground) ext Unsupported
1% dexvert Comic Book Creator shape Table (other/comicBookCreatorShapeTable) ext Unsupported
1% dexvert CorelTRACE configuration (other/corelTRACEConfiguration) ext Unsupported
1% dexvert Dreamcast Disc (other/dreamcastDisc) ext Unsupported
1% dexvert EST flat binary (other/estFlatBinary) ext Unsupported
1% dexvert Finale Enigma Binary Format (other/finaleEnigmaBinaryFormat) ext Unsupported
1% dexvert Sega Genesis/Megadrive/32x ROM (other/genesisROM) ext Unsupported
1% dexvert Myth: The Fallen Lords game archive (other/mythTheFallenLordsGameArchive) ext Unsupported
1% dexvert Sega Saturn ROM (other/segaSaturnROM) ext Unsupported
1% dexvert Sound Images Sound Driver (other/soundImagesSoundDriver) ext Unsupported
1% dexvert Symantec/Norton Config (other/symantecNortonConfig) ext Unsupported
1% dexvert Vectrex ROM (other/vectrexROM) ext Unsupported
1% dexvert Adrenaline Rush Hour game data (other/adrenalineRushHourGameData) ext Unsupported
1% dexvert BIS raP encoded format (other/bisraPEncoded) ext Unsupported
1% dexvert Linksys RT31P2-NA firmware (other/linksysRT31P2NAFirmware) ext Unsupported
1% dexvert Pascal Script binary (other/pascalScriptBinary) ext Unsupported
1% dexvert 7th Level game data archive (other/seventhLevelGameDataArchive) ext Unsupported
1% dexvert Statistica MFM data (other/statisticaMFMData) ext Unsupported
1% dexvert Surf's Up game data archive (other/surfsUpGameDataArchive) ext Unsupported
1% dexvert TP-Link router firmware (other/tpLinkRouterFirmware) ext Unsupported
1% dexvert Binary Text (image/binaryText) fallback Supported
100% file MS Windows 3.1 help, Thu Jan 13 22:26:02 1994, 192146 bytes default
99% file data default
50% TrID Windows HELP File default
49% TrID Multimedia Viewer Book default
100% siegfried fmt/474 Windows Help File default
100% gt2 Windows 95/98 Hilfedatei default
100% detectItEasy Format: MS Help default
100% xdgMime application/winhlp default



hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 3f 5f 03 00 f3 00 00 00 | ff ff ff ff 92 ee 02 00 |?_......|........|
|00000010| e3 00 00 00 da 00 00 00 | 00 6c 03 15 00 01 00 ca |........|.l......|
|00000020| 10 36 2d 00 00 01 00 01 | 00 00 03 00 04 00 00 00 |.6-.....|........|
|00000030| 00 00 02 00 01 00 00 06 | 00 5a 00 87 02 6d 61 69 |........|.Z...mai|
|00000040| 6e 00 3f 47 01 9f 01 6d | 61 69 6e 00 00 13 02 03 |n.?G...m|ain.....|
|00000050| 54 72 61 6e 73 61 63 74 | 2d 53 51 4c 20 48 65 6c |Transact|-SQL Hel|
|00000060| 70 00 01 47 01 e0 09 f0 | 08 1c 20 6e 4f 00 00 9f |p..G....|.. nO...|
|00000070| 01 6d 00 23 00 23 00 aa | 4f b3 2b 87 01 68 08 47 |.m.#.#..|O.+..h.G|
|00000080| 01 90 03 9f 01 07 00 91 | 03 9f 01 00 00 d3 0e 9f |........|........|
|00000090| 01 c0 c0 c0 00 06 00 5a | 00 ff 02 73 65 63 6f 6e |.......Z|...secon|
|000000a0| 64 61 72 79 00 69 6e 64 | 65 78 6f 00 02 03 49 6e |dary.ind|exo...In|
|000000b0| 64 65 78 00 63 74 2d 53 | 51 4c 20 48 65 6c 70 00 |dex.ct-S|QL Help.|
|000000c0| 01 47 01 e0 09 f0 08 1c | 20 6e 4f 00 00 9f 01 69 |.G......| nO....i|
|000000d0| 00 23 00 23 00 aa 4f b3 | 2b 87 01 68 08 47 01 90 |.#.#..O.|+..h.G..|
|000000e0| 03 02 02 53 00 df 01 a3 | 03 00 00 d3 0e 9f 01 c0 |...S....|........|
|000000f0| c0 c0 00 2f 04 00 00 26 | 04 00 00 04 3b 29 02 04 |.../...&|....;)..|
|00000100| 00 04 7a 34 00 f7 70 0f | 05 ff 83 f7 70 0f 05 ff |..z4..p.|....p...|
|00000110| 83 f7 00 00 00 00 00 00 | ff ff 01 00 01 00 0e 00 |........|........|
|00000120| 00 00 5e 03 0e 00 ff ff | ff ff 7c 43 4f 4e 54 45 |..^.....|..|CONTE|
|00000130| 58 54 00 12 bd 02 00 7c | 43 54 58 4f 4d 41 50 00 |XT.....||CTXOMAP.|
|00000140| 13 78 02 00 7c 46 4f 4e | 54 00 ab 76 02 00 7c 4b |.x..|FON|T..v..|K|
|00000150| 57 42 54 52 45 45 00 b4 | 7c 02 00 7c 4b 57 44 41 |WBTREE..||..|KWDA|
|00000160| 54 41 00 1e 78 02 00 7c | 4b 57 4d 41 50 00 97 7c |TA..x..||KWMAP..||
|00000170| 02 00 7c 53 59 53 54 45 | 4d 00 10 00 00 00 7c 54 |..|SYSTE|M.....|T|
|00000180| 4f 50 49 43 00 22 05 00 | 00 7c 54 54 4c 42 54 52 |OPIC."..|.|TTLBTR|
|00000190| 45 45 00 e3 9c 02 00 7c | 62 6d 30 00 41 d5 02 00 |EE.....||bm0.A...|
|000001a0| 7c 62 6d 31 00 ed d6 02 | 00 7c 62 6d 32 00 95 d8 ||bm1....|.|bm2...|
|000001b0| 02 00 7c 62 6d 33 00 89 | ed 02 00 7c 62 6d 34 00 |..|bm3..|...|bm4.|
|000001c0| ce ed 02 00 75 6e 63 5f | 67 75 69 20 30 20 74 65 |....unc_|gui 0 te|
|000001d0| 78 74 69 6d 61 67 65 66 | 75 6e 63 5f 67 75 69 20 |xtimagef|unc_gui |
|000001e0| 63 3a 5c 74 73 71 6c 68 | 65 6c 70 5c 68 65 6c 70 |c:\tsqlh|elp\help|
|000001f0| 73 71 6c 2e 72 74 66 20 | 31 36 31 0a 00 44 00 39 |sql.rtf |161..D.9|
|00000200| 36 35 44 46 31 43 31 20 | 70 61 74 69 6e 64 65 78 |65DF1C1 |patindex|
|00000210| 5f 67 75 69 20 31 20 70 | 61 74 69 6e 64 65 78 5f |_gui 1 p|atindex_|
|00000220| 67 75 69 20 63 3a 5c 74 | 73 71 6c 68 65 6c 70 5c |gui c:\t|sqlhelp\|
|00000230| 68 65 6c 70 73 71 6c 2e | 72 74 66 20 31 36 31 0a |helpsql.|rtf 161.|
|00000240| 00 44 00 36 32 37 42 36 | 37 42 38 20 74 65 78 74 |.D.627B6|7B8 text|
|00000250| 73 69 7a 65 5f 67 75 69 | 20 31 20 74 65 78 74 73 |size_gui| 1 texts|
|00000260| 69 7a 65 5f 67 75 69 20 | 63 3a 5c 74 73 71 6c 68 |ize_gui |c:\tsqlh|
|00000270| 65 6c 70 5c 68 65 6c 70 | 73 71 6c 2e 72 74 66 20 |elp\help|sql.rtf |
|00000280| 31 36 31 0a 00 42 00 45 | 34 43 44 32 30 39 33 20 |161..B.E|4CD2093 |
|00000290| 74 65 78 74 70 74 72 5f | 67 75 69 20 31 20 74 65 |textptr_|gui 1 te|
|000002a0| 78 74 70 74 72 5f 67 75 | 69 20 63 3a 5c 74 73 71 |xtptr_gu|i c:\tsq|
|000002b0| 6c 68 65 6c 70 5c 68 65 | 6c 70 73 71 6c 2e 72 74 |lhelp\he|lpsql.rt|
|000002c0| 66 20 31 36 31 0a 00 46 | 00 45 34 30 46 43 39 33 |f 161..F|.E40FC93|
|000002d0| 39 20 74 65 78 74 76 61 | 6c 69 64 5f 67 75 69 20 |9 textva|lid_gui |
|000002e0| 31 20 74 65 78 74 76 61 | 6c 69 64 5f 67 75 69 20 |1 textva|lid_gui |
|000002f0| 63 3a 5c 74 73 71 6c 68 | 65 6c 70 5c 68 65 6c 70 |c:\tsqlh|elp\help|
|00000300| 73 71 6c 2e 72 74 66 20 | 31 36 31 0a 00 42 00 45 |sql.rtf |161..B.E|
|00000310| 34 43 44 32 30 39 33 20 | 74 65 78 74 70 74 72 5f |4CD2093 |textptr_|
|00000320| 67 75 69 20 30 20 74 65 | 78 74 70 74 72 5f 67 75 |gui 0 te|xtptr_gu|
|00000330| 69 20 63 3a 5c 74 73 71 | 6c 68 65 6c 70 5c 68 65 |i c:\tsq|lhelp\he|
|00000340| 6c 70 73 71 6c 2e 72 74 | 66 20 31 36 32 0a 00 46 |lpsql.rt|f 162..F|
|00000350| 00 45 34 30 46 43 39 33 | 39 20 74 65 78 74 76 61 |.E40FC93|9 textva|
|00000360| 6c 69 64 5f 67 75 69 20 | 30 20 74 65 78 74 76 61 |lid_gui |0 textva|
|00000370| 6c 69 64 5f 67 75 69 20 | 63 3a 5c 74 73 71 6c 68 |lid_gui |c:\tsqlh|
|00000380| 65 6c 70 5c 68 65 6c 70 | 73 71 6c 2e 72 74 66 20 |elp\help|sql.rtf |
|00000390| 31 36 33 0a 00 44 00 36 | 32 37 42 36 37 42 38 20 |163..D.6|27B67B8 |
|000003a0| 74 65 78 74 73 69 7a 65 | 5f 67 75 69 20 30 20 74 |textsize|_gui 0 t|
|000003b0| 65 78 74 73 69 7a 65 5f | 67 75 69 20 63 3a 5c 74 |extsize_|gui c:\t|
|000003c0| 73 71 6c 68 65 6c 70 5c | 68 65 6c 70 73 71 6c 2e |sqlhelp\|helpsql.|
|000003d0| 72 74 66 20 31 36 34 0a | 00 44 00 35 32 37 45 32 |rtf 164.|.D.527E2|
|000003e0| 38 42 44 20 61 64 64 61 | 6c 69 61 73 5f 67 75 69 |8BD adda|lias_gui|
|000003f0| 20 30 20 61 64 64 61 6c | 69 61 73 5f 67 75 69 20 | 0 addal|ias_gui |
|00000400| 63 3a 5c 74 73 71 6c 68 | 65 6c 70 5c 68 65 6c 70 |c:\tsqlh|elp\help|
|00000410| 73 71 6c 2e 72 74 66 20 | 31 36 35 0a 00 52 00 41 |sql.rtf |165..R.A|
|00000420| 34 46 43 46 31 33 41 20 | 61 64 64 65 78 74 65 6e |4FCF13A |addexten|
|00000430| 64 65 64 70 72 6f 63 5f | 67 75 69 20 30 20 61 64 |dedproc_|gui 0 ad|
|00000440| 64 65 78 74 65 6e 64 65 | 64 70 72 6f 63 5f 67 75 |dextende|dproc_gu|
|00000450| 69 20 63 3a 5c 74 73 71 | 6c 68 65 6c 70 5c 68 65 |i c:\tsq|lhelp\he|
|00000460| 6c 70 73 71 6c 2e 72 74 | 66 20 31 36 36 0a 00 44 |lpsql.rt|f 166..D|
|00000470| 00 43 39 45 33 39 35 44 | 34 20 61 64 64 67 72 6f |.C9E395D|4 addgro|
|00000480| 75 70 5f 67 75 69 20 30 | 20 61 64 64 67 72 6f 75 |up_gui 0| addgrou|
|00000490| 70 5f 67 75 69 20 63 3a | 5c 74 73 71 6c 68 65 6c |p_gui c:|\tsqlhel|
|000004a0| 70 5c 68 65 6c 70 73 71 | 6c 2e 72 74 66 20 31 36 |p\helpsq|l.rtf 16|
|000004b0| 37 0a 00 44 00 39 38 33 | 45 41 42 36 32 20 61 64 |7..D.983|EAB62 ad|
|000004c0| 64 6c 6f 67 69 6e 5f 67 | 75 69 20 30 20 61 64 64 |dlogin_g|ui 0 add|
|000004d0| 6c 6f 67 69 6e 5f 67 75 | 69 20 63 3a 5c 74 73 71 |login_gu|i c:\tsq|
|000004e0| 6c 68 65 6c 70 5c 68 65 | 6c 70 73 71 6c 2e 72 74 |lhelp\he|lpsql.rt|
|000004f0| 66 20 31 36 38 0a 00 46 | 00 43 46 45 33 32 43 36 |f 168..F|.CFE32C6|
|00000500| 31 20 61 64 64 72 65 6d | 6c 6f 67 5f 67 75 69 20 |1 addrem|log_gui |
|00000510| 30 20 61 64 64 72 65 6d | 6c 6f 67 5f 67 75 69 20 |0 addrem|log_gui |
|00000520| 63 3a 89 71 02 00 80 71 | 02 00 00 ff ff ff ff 0c |c:.q...q|........|
|00000530| 00 00 00 00 00 00 00 42 | 00 00 00 11 00 00 00 ff |.......B|........|
|00000540| ff ff ff 4e 00 00 00 31 | 00 00 00 02 05 02 00 00 |...N...1|........|
|00000550| ff ff ff ff ff ff ff ff | 00 00 00 00 4e 00 00 00 |........|....N...|
|00000560| 48 01 00 00 1c 03 00 00 | 54 72 61 6e 73 61 63 74 |H.......|Transact|
|00000570| 2d 53 51 4c 20 48 65 6c | 70 3b 00 00 00 14 00 00 |-SQL Hel|p;......|
|00000580| 00 0c 00 00 00 89 00 00 | 00 27 00 00 00 20 1e 80 |........|.'... ..|
|00000590| 28 00 80 00 00 1e 00 b8 | 98 42 98 80 03 00 82 ff |(.......|.B......|
|000005a0| 00 54 72 61 6e 73 61 63 | 74 2d 53 51 4c 20 48 65 |.Transac|t-SQL He|
|000005b0| 6c 70 00 00 96 00 00 00 | 56 00 00 00 4e 00 00 00 |lp......|V...N...|
|000005c0| 1f 01 00 00 40 00 00 00 | 20 50 80 ae 00 80 00 00 |....@...| P......|
|000005d0| 18 00 52 98 80 04 00 82 | 82 ef 06 00 01 ac 04 12 |..R.....|........|
|000005e0| 19 01 80 05 00 86 22 08 | 80 02 00 00 00 00 89 80 |......".|........|
|000005f0| 04 00 82 ff 00 54 72 61 | 6e 73 61 63 74 2d 53 51 |.....Tra|nsact-SQ|
|00000600| 4c 20 69 73 20 61 6e 20 | 65 6e 68 61 6e 63 65 64 |L is an |enhanced|
|00000610| 20 76 65 72 73 69 6f 6e | 20 6f 66 20 74 68 65 20 | version| of the |
|00000620| 53 51 4c 20 72 65 6c 61 | 74 69 6f 6e 61 6c 20 64 |SQL rela|tional d|
|00000630| 61 74 61 62 61 73 65 20 | 6c 61 6e 67 75 61 67 65 |atabase |language|
|00000640| 2e 00 00 00 00 00 00 00 | 00 00 29 00 00 00 03 00 |........|..).....|
|00000650| 00 00 89 00 00 00 48 01 | 00 00 26 00 00 00 20 1c |......H.|..&... .|
|00000660| 80 06 00 80 00 00 1a 00 | 90 52 98 80 06 00 82 ff |........|.R......|
|00000670| 00 00 00 d4 01 00 00 e6 | 00 00 00 1f 01 00 00 1c |........|........|
|00000680| 03 00 00 ee 00 00 00 20 | aa 81 df 01 00 80 00 00 |....... |........|
|00000690| 1e 00 98 8c 52 98 80 07 | 00 82 e7 ce 6b 40 55 80 |....R...|....k@U.|
|000006a0| 08 00 86 22 08 80 02 00 | 00 04 00 80 07 00 89 82 |..."....|........|
|000006b0| e7 05 e9 39 05 80 08 00 | 86 22 08 80 02 00 00 04 |...9....|."......|
|000006c0| 00 80 07 00 89 82 e7 51 | 7f d6 91 80 08 00 86 22 |.......Q|......."|
|000006d0| 08 80 02 00 00 04 00 80 | 07 00 89 82 e7 a0 c5 fa |........|........|
|000006e0| f4 80 08 00 86 22 08 80 | 02 00 00 04 00 80 07 00 |....."..|........|
|000006f0| 89 82 e7 f2 e2 4e b6 80 | 08 00 86 22 08 80 02 00 |.....N..|..."....|
|00000700| 00 04 00 80 07 00 89 82 | e7 a7 ae 82 4d 80 08 00 |........|....M...|
|00000710| 86 22 08 80 02 00 00 04 | 00 80 07 00 89 82 e7 31 |."......|.......1|
|00000720| 3b 6f 89 80 08 00 86 22 | 08 80 02 00 00 04 00 80 |;o....."|........|
|00000730| 07 00 89 82 e7 a4 71 c8 | 05 80 08 00 86 22 08 80 |......q.|....."..|
|00000740| 02 00 00 04 00 80 07 00 | 89 82 e7 dc 7a e9 81 80 |........|....z...|
|00000750| 08 00 86 22 08 80 02 00 | 00 04 00 80 07 00 89 82 |..."....|........|
|00000760| ff 00 43 6f 6e 74 65 6e | 74 73 00 00 00 00 00 20 |..Conten|ts..... |
|00000770| 20 43 61 74 61 6c 6f 67 | 20 53 74 6f 72 65 64 20 | Catalog| Stored |
|00000780| 50 72 6f 63 65 64 75 72 | 65 73 00 00 00 00 00 00 |Procedur|es......|
|00000790| 20 20 44 61 74 61 74 79 | 70 65 73 00 00 00 00 00 | Dataty|pes.....|
|000007a0| 00 20 20 45 78 70 72 65 | 73 73 69 6f 6e 73 00 00 |. Expre|ssions..|
|000007b0| 00 00 00 00 20 20 45 78 | 74 65 6e 64 65 64 20 53 |.... Ex|tended S|
|000007c0| 74 6f 72 65 64 20 50 72 | 6f 63 65 64 75 72 65 73 |tored Pr|ocedures|
|000007d0| 00 00 00 00 00 00 20 20 | 46 75 6e 63 74 69 6f 6e |...... |Function|
|000007e0| 73 00 00 00 00 00 00 20 | 20 4c 49 4b 45 20 61 6e |s...... | LIKE an|
|000007f0| 64 20 57 69 6c 64 63 61 | 72 64 73 00 00 00 00 00 |d Wildca|rds.....|
|00000800| 00 20 20 53 79 73 74 65 | 6d 20 50 72 6f 63 65 64 |. Syste|m Proced|
|00000810| 75 72 65 73 00 00 00 00 | 00 00 20 20 54 72 61 6e |ures....|.. Tran|
|00000820| 73 61 63 74 2d 53 51 4c | 20 53 74 61 74 65 6d 65 |sact-SQL| Stateme|
|00000830| 6e 74 73 00 00 00 00 00 | 00 20 20 55 74 69 6c 69 |nts.....|. Utili|
|00000840| 74 69 65 73 00 00 00 48 | 00 00 00 17 00 00 00 48 |ties...H|.......H|
|00000850| 01 00 00 64 03 00 00 31 | 00 00 00 02 96 06 00 00 |...d...1|........|
|00000860| ff ff ff ff ff ff ff ff | 01 00 00 00 64 03 00 00 |........|....d...|
|00000870| cd 03 00 00 32 0a 00 00 | 54 72 61 6e 73 61 63 74 |....2...|Transact|
|00000880| 2d 53 51 4c 20 53 74 61 | 74 65 6d 65 6e 74 73 41 |-SQL Sta|tementsA|
|00000890| 00 00 00 1a 00 00 00 1c | 03 00 00 a5 03 00 00 27 |........|.......'|
|000008a0| 00 00 00 20 1e 80 34 00 | 80 00 00 1e 00 b8 98 42 |... ..4.|.......B|
|000008b0| 98 80 03 00 82 ff 00 54 | 72 61 6e 73 61 63 74 2d |.......T|ransact-|
|000008c0| 53 51 4c 20 53 74 61 74 | 65 6d 65 6e 74 73 00 00 |SQL Stat|ements..|
|000008d0| 28 00 00 00 03 00 00 00 | 64 03 00 00 cd 03 00 00 |(.......|d.......|
|000008e0| 25 00 00 00 20 1a 80 06 | 00 80 00 00 18 00 52 98 |%... ...|......R.|
|000008f0| 80 06 00 82 ff 00 00 00 | 0f 02 00 00 48 01 00 00 |........|....H...|
|00000900| a5 03 00 00 dc 05 00 00 | c7 00 00 00 20 5c 81 91 |........|.... \..|
|00000910| 02 00 80 00 00 1a 00 90 | 52 98 e3 c8 64 dc 18 80 |........|R...d...|
|00000920| 04 00 89 82 e3 b3 fa 7f | 10 89 82 e3 87 86 62 74 |........|......bt|
|00000930| 89 82 e3 8d 14 47 cd 89 | 82 e3 11 05 95 f9 89 82 |.....G..|........|
|00000940| e3 e0 21 72 75 89 82 e3 | 8a 6a 9d 89 89 82 e3 5a |..!ru...|.j.....Z|
|00000950| ec cb fa 89 82 e3 05 98 | 56 1c 89 82 e3 84 6e ea |........|V.....n.|
|00000960| 25 89 82 e3 3d 98 22 61 | 89 82 e3 b0 8f cb 84 89 |%...=."a|........|
|00000970| 82 e3 3b a1 43 6a 89 82 | e3 79 8f a1 14 89 82 e3 |..;.Cj..|.y......|
|00000980| dc ca 63 bf 89 82 e3 0d | 1f 57 03 89 82 e3 1b ce |..c.....|.W......|
|00000990| eb d2 89 82 e3 21 bd cc | d3 89 82 e3 bc 20 ea 44 |.....!..|..... .D|
|000009a0| 89 82 e3 08 14 8b e9 89 | 82 e3 5c 4b 7d 3e 89 82 |........|..\K}>..|
|000009b0| e3 f9 22 09 3c 89 82 e3 | b6 75 86 a5 89 82 ff 00 |..".<...|.u......|
|000009c0| 00 41 4c 54 45 52 20 44 | 41 54 41 42 41 53 45 00 |.ALTER D|ATABASE.|
|000009d0| 00 00 41 4c 54 45 52 20 | 54 41 42 4c 45 00 00 00 |..ALTER |TABLE...|
|000009e0| 42 45 47 49 4e 2e 2e 2e | 45 4e 44 00 00 00 42 45 |BEGIN...|END...BE|
|000009f0| 47 49 4e 20 54 52 41 4e | 53 41 43 54 49 4f 4e 00 |GIN TRAN|SACTION.|
|00000a00| 00 00 42 52 45 41 4b 00 | 00 00 42 72 6f 77 73 65 |..BREAK.|..Browse|
|00000a10| 20 4d 6f 64 65 00 00 00 | 43 48 45 43 4b 50 4f 49 | Mode...|CHECKPOI|
|00000a20| 4e 54 00 00 00 43 4f 4d | 4d 49 54 20 54 52 41 4e |NT...COM|MIT TRAN|
|00000a30| 53 41 43 54 49 4f 4e 00 | 00 00 43 4f 4d 50 55 54 |SACTION.|..COMPUT|
|00000a40| 45 20 43 6c 61 75 73 65 | 00 00 00 43 4f 4e 54 49 |E Clause|...CONTI|
|00000a50| 4e 55 45 00 00 00 43 4f | 4e 56 45 52 54 00 00 00 |NUE...CO|NVERT...|
|00000a60| 43 52 45 41 54 45 20 44 | 41 54 41 42 41 53 45 00 |CREATE D|ATABASE.|
|00000a70| 00 00 43 52 45 41 54 45 | 20 44 45 46 41 55 4c 54 |..CREATE| DEFAULT|
|00000a80| 00 00 00 43 52 45 41 54 | 45 20 49 4e 44 45 58 00 |...CREAT|E INDEX.|
|00000a90| 00 00 43 52 45 41 54 45 | 20 50 52 4f 43 45 44 55 |..CREATE| PROCEDU|
|00000aa0| 52 45 00 00 00 43 52 45 | 41 54 45 20 52 55 4c 45 |RE...CRE|ATE RULE|
|00000ab0| 00 00 00 43 52 45 41 54 | 45 20 54 41 42 4c 45 00 |...CREAT|E TABLE.|
|00000ac0| 00 00 43 52 45 41 54 45 | 20 54 52 49 47 47 45 52 |..CREATE| TRIGGER|
|00000ad0| 00 00 00 43 52 45 41 54 | 45 20 56 49 45 57 00 00 |...CREAT|E VIEW..|
|00000ae0| 00 44 42 43 43 00 00 00 | 44 45 43 4c 41 52 45 00 |.DBCC...|DECLARE.|
|00000af0| 00 00 44 45 4c 45 54 45 | 00 00 00 44 49 53 4b 20 |..DELETE|...DISK |
|00000b00| 49 4e 49 54 00 00 00 06 | 02 00 00 38 01 00 00 cd |INIT....|...8....|
|00000b10| 03 00 00 e2 07 00 00 ce | 00 00 00 20 6a 81 71 02 |........|... j.q.|
|00000b20| 00 80 00 00 1a 00 90 52 | 98 e3 e0 1f 44 8d 80 04 |.......R|....D...|
|00000b30| 00 89 82 e3 24 87 da c7 | 89 82 e3 21 6a d3 6e 89 |....$...|...!j.n.|
|00000b40| 82 e3 a1 9c ec 14 89 82 | e3 7f ee dd c8 89 82 e3 |........|........|
|00000b50| 8f 7b 1f 90 89 82 e3 b0 | 3f 5c 51 89 82 e3 ee 2d |.{......|?\Q....-|
|00000b60| ba fb 89 82 e3 a9 4a 54 | 43 89 82 e3 ec 0a ab 0e |......JT|C.......|
|00000b70| 89 82 e3 b9 30 de 0c 89 | 82 e3 71 73 5f 83 89 82 |....0...|..qs_...|
|00000b80| e3 2a 07 d8 b7 89 82 e3 | 6c 73 e5 19 89 82 e3 a5 |.*......|ls......|
|00000b90| 7b 8e 55 89 82 e3 27 de | ef a5 89 82 e3 fd 05 14 |{.U...'.|........|
|00000ba0| 80 89 82 e3 0a 24 53 65 | 89 82 e3 21 81 cd 3c 89 |.....$Se|...!..<.|
|00000bb0| 82 e3 a3 c3 d1 27 89 82 | e3 5f 62 9b df 89 82 e3 |.....'..|._b.....|
|00000bc0| 37 d4 dd 56 89 82 e3 28 | 7c 47 8b 89 82 e3 ee 16 |7..V...(||G......|
|00000bd0| 57 73 89 82 ff 00 00 44 | 49 53 4b 20 4d 49 52 52 |Ws.....D|ISK MIRR|
|00000be0| 4f 52 00 00 00 44 49 53 | 4b 20 52 45 46 49 54 00 |OR...DIS|K REFIT.|
|00000bf0| 00 00 44 49 53 4b 20 52 | 45 49 4e 49 54 00 00 00 |..DISK R|EINIT...|
|00000c00| 44 49 53 4b 20 52 45 4d | 49 52 52 4f 52 00 00 00 |DISK REM|IRROR...|
|00000c10| 44 49 53 4b 20 55 4e 4d | 49 52 52 4f 52 00 00 00 |DISK UNM|IRROR...|
|00000c20| 44 52 4f 50 20 44 41 54 | 41 42 41 53 45 00 00 00 |DROP DAT|ABASE...|
|00000c30| 44 52 4f 50 20 44 45 46 | 41 55 4c 54 00 00 00 44 |DROP DEF|AULT...D|
|00000c40| 52 4f 50 20 49 4e 44 45 | 58 00 00 00 44 52 4f 50 |ROP INDE|X...DROP|
|00000c50| 20 50 52 4f 43 45 44 55 | 52 45 00 00 00 44 52 4f | PROCEDU|RE...DRO|
|00000c60| 50 20 52 55 4c 45 00 00 | 00 44 52 4f 50 20 54 41 |P RULE..|.DROP TA|
|00000c70| 42 4c 45 00 00 00 44 52 | 4f 50 20 54 52 49 47 47 |BLE...DR|OP TRIGG|
|00000c80| 45 52 00 00 00 44 52 4f | 50 20 56 49 45 57 00 00 |ER...DRO|P VIEW..|
|00000c90| 00 44 55 4d 50 20 44 41 | 54 41 42 41 53 45 00 00 |.DUMP DA|TABASE..|
|00000ca0| 00 44 55 4d 50 20 54 52 | 41 4e 53 41 43 54 49 4f |.DUMP TR|ANSACTIO|
|00000cb0| 4e 00 00 00 45 58 45 43 | 55 54 45 00 00 00 47 4f |N...EXEC|UTE...GO|
|00000cc0| 54 4f 00 00 00 47 52 41 | 4e 54 00 00 00 47 52 4f |TO...GRA|NT...GRO|
|00000cd0| 55 50 20 42 59 00 00 00 | 48 41 56 49 4e 47 00 00 |UP BY...|HAVING..|
|00000ce0| 00 49 46 2e 2e 2e 45 4c | 53 45 00 00 00 49 4e 53 |.IF...EL|SE...INS|
|00000cf0| 45 52 54 00 00 00 4b 49 | 4c 4c 00 00 00 4c 4f 41 |ERT...KI|LL...LOA|
|00000d00| 44 20 44 41 54 41 42 41 | 53 45 00 00 00 07 02 00 |D DATABA|SE......|
|00000d10| 00 40 01 00 00 dc 05 00 | 00 e9 09 00 00 c7 00 00 |.@......|........|
|00000d20| 00 20 5c 81 81 02 00 80 | 00 00 1a 00 90 52 98 e3 |. \.....|.....R..|
|00000d30| 97 71 54 5b 80 04 00 89 | 82 e3 58 c1 9b 78 89 82 |.qT[....|..X..x..|
|00000d40| e3 e6 b5 ce af 89 82 e3 | bb e8 d0 82 89 82 e3 f2 |........|........|
|00000d50| eb 8a 85 89 82 e3 68 d7 | b1 49 89 82 e3 d3 1c b7 |......h.|.I......|
|00000d60| e5 89 82 e3 7e 6f 7f 7b | 89 82 e3 f8 5d ef fa 89 |....~o.{|....]...|
|00000d70| 82 e3 0a 44 b5 ed 89 82 | e3 a6 c9 c6 b9 89 82 e3 |...D....|........|
|00000d80| 52 76 a6 15 89 82 e3 7c | 1f cd 42 89 82 e3 5f df |Rv.....||..B..._.|
|00000d90| e8 42 89 82 e3 f2 cf 33 | b0 89 82 e3 71 df 40 78 |.B.....3|....q.@x|
|00000da0| 89 82 e3 a9 75 e0 3e 89 | 82 e3 63 a1 b1 78 89 82 |....u.>.|..c..x..|
|00000db0| e3 af e1 f8 28 89 82 e3 | 29 b4 fb ab 89 82 e3 e1 |....(...|).......|
|00000dc0| 6c 6f 09 89 82 e3 c2 e0 | 6e 9a 89 82 e3 ed 19 57 |lo......|n......W|
|00000dd0| 78 89 82 ff 00 00 4c 4f | 41 44 20 54 52 41 4e 53 |x.....LO|AD TRANS|
|00000de0| 41 43 54 49 4f 4e 00 00 | 00 4f 52 44 45 52 20 42 |ACTION..|.ORDER B|
|00000df0| 59 00 00 00 50 52 45 50 | 41 52 45 20 54 52 41 4e |Y...PREP|ARE TRAN|
|00000e00| 53 41 43 54 49 4f 4e 00 | 00 00 50 52 49 4e 54 00 |SACTION.|..PRINT.|
|00000e10| 00 00 52 41 49 53 45 52 | 52 4f 52 00 00 00 52 45 |..RAISER|ROR...RE|
|00000e20| 41 44 54 45 58 54 00 00 | 00 52 45 43 4f 4e 46 49 |ADTEXT..|.RECONFI|
|00000e30| 47 55 52 45 00 00 00 52 | 45 54 55 52 4e 00 00 00 |GURE...R|ETURN...|
|00000e40| 52 45 56 4f 4b 45 00 00 | 00 52 4f 4c 4c 42 41 43 |REVOKE..|.ROLLBAC|
|00000e50| 4b 20 54 52 41 4e 53 41 | 43 54 49 4f 4e 00 00 00 |K TRANSA|CTION...|
|00000e60| 53 41 56 45 20 54 52 41 | 4e 53 41 43 54 49 4f 4e |SAVE TRA|NSACTION|
|00000e70| 00 00 00 53 45 4c 45 43 | 54 00 00 00 53 45 54 00 |...SELEC|T...SET.|
|00000e80| 00 00 53 45 54 55 53 45 | 52 00 00 00 53 48 55 54 |..SETUSE|R...SHUT|
|00000e90| 44 4f 57 4e 00 00 00 54 | 52 55 4e 43 41 54 45 20 |DOWN...T|RUNCATE |
|00000ea0| 54 41 42 4c 45 00 00 00 | 55 4e 49 4f 4e 20 4f 70 |TABLE...|UNION Op|
|00000eb0| 65 72 61 74 6f 72 00 00 | 00 55 50 44 41 54 45 00 |erator..|.UPDATE.|
|00000ec0| 00 00 55 50 44 41 54 45 | 20 53 54 41 54 49 53 54 |..UPDATE| STATIST|
|00000ed0| 49 43 53 00 00 00 55 53 | 45 00 00 00 56 61 72 69 |ICS...US|E...Vari|
|00000ee0| 61 62 6c 65 73 20 28 4c | 6f 63 61 6c 20 61 6e 64 |ables (L|ocal and|
|00000ef0| 20 47 6c 6f 62 61 6c 29 | 00 00 00 57 41 49 54 46 | Global)|...WAITF|
|00000f00| 4f 52 00 00 00 57 48 45 | 52 45 20 43 6c 61 75 73 |OR...WHE|RE Claus|
|00000f10| 65 00 00 00 49 00 00 00 | 16 00 00 00 e2 07 00 00 |e...I...|........|
|00000f20| 32 0a 00 00 33 00 00 00 | 20 36 80 2c 00 80 00 00 |2...3...| 6.,....|
|00000f30| 1a 00 90 52 98 e3 2f 75 | e5 26 80 04 00 89 82 e3 |...R../u|.&......|
|00000f40| 5a e2 03 dd 89 82 ff 00 | 00 57 48 49 4c 45 00 00 |Z.......|.WHILE..|
|00000f50| 00 57 52 49 54 45 54 45 | 58 54 00 00 00 42 00 00 |.WRITETE|XT...B..|
|00000f60| 00 11 00 00 00 e9 09 00 | 00 74 0a 00 00 31 00 00 |........|.t...1..|
|00000f70| 00 02 e8 06 00 00 ff ff | ff ff ff ff ff ff 02 00 |........|........|
|00000f80| 00 00 74 0a 00 00 82 0b | 00 00 45 42 00 00 73 79 |..t.....|..EB..sy|
|00000f90| 73 74 65 6d 20 70 72 6f | 63 65 64 75 72 65 73 3e |stem pro|cedures>|
|00000fa0| 00 00 00 14 00 00 00 32 | 0a 00 00 b2 0a 00 00 2a |.......2|.......*|
|00000fb0| 00 00 00 20 24 80 28 00 | 80 00 00 1e 02 b8 98 42 |... $.(.|.......B|
|00000fc0| 98 82 09 07 80 03 00 82 | ff 00 53 79 73 74 65 6d |........|..System|
|00000fd0| 20 50 72 6f 63 65 64 75 | 72 65 73 00 00 d0 00 00 | Procedu|res.....|
|00000fe0| 00 a6 00 00 00 74 0a 00 | 00 82 0b 00 00 2a 00 00 |.....t..|.....*..|
|00000ff0| 00 20 22 80 4d 01 00 80 | 00 00 18 00 52 98 80 04 |. ".M...|....R...|
|00001000| 00 82 80 06 00 82 ff 00 | 54 68 69 73 20 74 6f 70 |........|This top|
|00001010| 69 63 20 70 72 6f 76 69 | 64 65 73 20 72 65 66 65 |ic provi|des refe|
|00001020| 72 65 6e 63 65 20 69 6e | 66 6f 72 6d 61 74 69 6f |rence in|formatio|
|00001030| 6e 20 61 62 6f 75 74 20 | 73 79 73 74 65 6d 20 70 |n about |system p|
|00001040| 72 6f 63 65 64 75 72 65 | 73 20 28 53 51 4c 20 53 |rocedure|s (SQL S|
|00001050| 65 72 76 65 72 2d 73 75 | 70 70 6c 69 65 64 20 73 |erver-su|pplied s|
|00001060| 74 6f 72 65 64 20 70 72 | 6f 63 65 64 75 72 65 73 |tored pr|ocedures|
|00001070| 29 2e 20 4e 6f 74 65 20 | 74 68 61 74 20 73 79 73 |). Note |that sys|
|00001080| 74 65 6d 20 70 72 6f 63 | 64 75 72 65 20 6e 61 6d |tem proc|dure nam|
|00001090| 65 73 20 61 6c 77 61 79 | 73 20 62 65 67 69 6e 20 |es alway|s begin |
|000010a0| 77 69 74 68 20 73 70 5f | 2e 00 00 00 00 09 02 00 |with sp_|........|
|000010b0| 00 50 01 00 00 b2 0a 00 | 00 8b 0d 00 00 b9 00 00 |.P......|........|
|000010c0| 00 20 40 81 a1 02 00 80 | 00 00 1a 00 90 52 98 e3 |. @.....|.....R..|
|000010d0| bd 28 7e 52 80 04 00 89 | 82 e3 3a f1 fc a4 89 82 |.(~R....|..:.....|
|000010e0| e3 d4 95 e3 c9 89 82 e3 | 62 ab 3e 98 89 82 e3 61 |........|b.>....a|
|000010f0| 2c e3 cf 89 82 e3 ca a3 | 6b c5 89 82 e3 81 0a 83 |,.......|k.......|
|00001100| 8e 89 82 e3 21 9f d3 32 | 89 82 e3 c7 b0 27 b5 89 |....!..2|.....'..|
|00001110| 82 e3 42 b0 0b 4a 89 82 | e3 80 7d 39 63 89 82 e3 |..B..J..|..}9c...|
|00001120| 97 c1 5b fe 89 82 e3 fd | e2 48 de 89 82 e3 84 31 |..[.....|.H.....1|
|00001130| f0 b7 89 82 e3 70 7a 2d | 9b 89 82 e3 dc 3e 73 b3 |.....pz-|.....>s.|
|00001140| 89 82 e3 69 df ae 14 89 | 82 e3 b5 b4 72 c9 89 82 |...i....|....r...|
|00001150| e3 f5 9c ec 38 89 82 e3 | 9d 01 9d b8 89 82 e3 62 |....8...|.......b|
|00001160| fc 4a b6 89 82 ff 00 00 | 73 70 5f 61 64 64 61 6c |.J......|sp_addal|
|00001170| 69 61 73 00 00 00 73 70 | 5f 61 64 64 65 78 74 65 |ias...sp|_addexte|
|00001180| 6e 64 65 64 70 72 6f 63 | 00 00 00 73 70 5f 61 64 |ndedproc|...sp_ad|
|00001190| 64 67 72 6f 75 70 00 00 | 00 73 70 5f 61 64 64 6c |dgroup..|.sp_addl|
|000011a0| 6f 67 69 6e 00 00 00 73 | 70 5f 61 64 64 72 65 6d |ogin...s|p_addrem|
|000011b0| 6f 74 65 6c 6f 67 69 6e | 00 00 00 73 70 5f 61 64 |otelogin|...sp_ad|
|000011c0| 64 73 65 67 6d 65 6e 74 | 00 00 00 73 70 5f 61 64 |dsegment|...sp_ad|
|000011d0| 64 73 65 72 76 65 72 00 | 00 00 73 70 5f 61 64 64 |dserver.|..sp_add|
|000011e0| 74 79 70 65 00 00 00 73 | 70 5f 61 64 64 75 6d 70 |type...s|p_addump|
|000011f0| 64 65 76 69 63 65 00 00 | 00 73 70 5f 61 64 64 75 |device..|.sp_addu|
|00001200| 73 65 72 00 00 00 73 70 | 5f 62 69 6e 64 65 66 61 |ser...sp|_bindefa|
|00001210| 75 6c 74 00 00 00 73 70 | 5f 62 69 6e 64 72 75 6c |ult...sp|_bindrul|
|00001220| 65 00 00 00 73 70 5f 63 | 68 61 6e 67 65 64 62 6f |e...sp_c|hangedbo|
|00001230| 77 6e 65 72 00 00 00 73 | 70 5f 63 68 61 6e 67 65 |wner...s|p_change|
|00001240| 67 72 6f 75 70 00 00 00 | 73 70 5f 63 6f 6d 6d 6f |group...|sp_commo|
|00001250| 6e 6b 65 79 00 00 00 73 | 70 5f 63 6f 6e 66 69 67 |nkey...s|p_config|
|00001260| 75 72 65 00 00 00 73 70 | 5f 64 62 6f 70 74 69 6f |ure...sp|_dboptio|
|00001270| 6e 00 00 00 73 70 5f 64 | 65 66 61 75 6c 74 64 62 |n...sp_d|efaultdb|
|00001280| 00 00 00 73 70 5f 64 65 | 66 61 75 6c 74 6c 61 6e |...sp_de|faultlan|
|00001290| 67 75 61 67 65 00 00 00 | 73 70 5f 64 65 70 65 6e |guage...|sp_depen|
|000012a0| 64 73 00 00 00 73 70 5f | 64 69 73 6b 64 65 66 61 |ds...sp_|diskdefa|
|000012b0| 75 6c 74 00 00 00 0b 02 | 00 00 52 01 00 00 82 0b |ult.....|..R.....|
|000012c0| 00 00 96 0f 00 00 b9 00 | 00 00 20 40 81 a5 02 00 |........|.. @....|
|000012d0| 80 00 00 1a 00 90 52 98 | e3 0b d9 7e 19 80 04 00 |......R.|...~....|
|000012e0| 89 82 e3 c0 ea 9e 54 89 | 82 e3 e4 50 73 80 89 82 |......T.|...Ps...|
|000012f0| e3 22 46 e4 90 89 82 e3 | b2 d5 b5 a2 89 82 e3 07 |."F.....|........|
|00001300| a2 aa 5c 89 82 e3 b0 5b | 3f 5f 89 82 e3 7b c9 00 |..\....[|?_...{..|
|00001310| 3d 89 82 e3 88 98 4d 65 | 89 82 e3 5c 88 ce 05 89 |=.....Me|...\....|
|00001320| 82 e3 0b bb c7 0d 89 82 | e3 2c cc ff 24 89 82 e3 |........|.,..$...|
|00001330| a1 c6 59 4e 89 82 e3 01 | bf 19 86 89 82 e3 5f 38 |..YN....|......_8|
|00001340| 02 cc 89 82 e3 e5 5c 3d | b8 89 82 e3 32 c4 a3 11 |......\=|....2...|
|00001350| 89 82 e3 4a 39 c3 17 89 | 82 e3 84 ce ea c8 89 82 |...J9...|........|
|00001360| e3 0f 52 2f a5 89 82 e3 | 3e 28 9e f7 89 82 ff 00 |..R/....|>(......|
|00001370| 00 73 70 5f 64 72 6f 70 | 61 6c 69 61 73 00 00 00 |.sp_drop|alias...|
|00001380| 73 70 5f 64 72 6f 70 64 | 65 76 69 63 65 00 00 00 |sp_dropd|evice...|
|00001390| 73 70 5f 64 72 6f 70 65 | 78 74 65 6e 64 65 64 70 |sp_drope|xtendedp|
|000013a0| 72 6f 63 00 00 00 73 70 | 5f 64 72 6f 70 67 72 6f |roc...sp|_dropgro|
|000013b0| 75 70 00 00 00 73 70 5f | 64 72 6f 70 6b 65 79 00 |up...sp_|dropkey.|
|000013c0| 00 00 73 70 5f 64 72 6f | 70 6c 61 6e 67 75 61 67 |..sp_dro|planguag|
|000013d0| 65 00 00 00 73 70 5f 64 | 72 6f 70 6c 6f 67 69 6e |e...sp_d|roplogin|
|000013e0| 00 00 00 73 70 5f 64 72 | 6f 70 72 65 6d 6f 74 65 |...sp_dr|opremote|
|000013f0| 6c 6f 67 69 6e 00 00 00 | 73 70 5f 64 72 6f 70 73 |login...|sp_drops|
|00001400| 65 67 6d 65 6e 74 00 00 | 00 73 70 5f 64 72 6f 70 |egment..|.sp_drop|
|00001410| 73 65 72 76 65 72 00 00 | 00 73 70 5f 64 72 6f 70 |server..|.sp_drop|
|00001420| 74 79 70 65 00 00 00 73 | 70 5f 64 72 6f 70 75 73 |type...s|p_dropus|
|00001430| 65 72 00 00 00 73 70 5f | 65 78 74 65 6e 64 73 65 |er...sp_|extendse|
|00001440| 67 6d 65 6e 74 00 00 00 | 73 70 5f 66 6f 72 65 69 |gment...|sp_forei|
|00001450| 67 6e 6b 65 79 00 00 00 | 73 70 5f 68 65 6c 70 00 |gnkey...|sp_help.|
|00001460| 00 00 73 70 5f 68 65 6c | 70 64 62 00 00 00 73 70 |..sp_hel|pdb...sp|
|00001470| 5f 68 65 6c 70 64 65 76 | 69 63 65 00 00 00 73 70 |_helpdev|ice...sp|
|00001480| 5f 68 65 6c 70 65 78 74 | 65 6e 64 65 64 70 72 6f |_helpext|endedpro|
|00001490| 63 00 00 00 73 70 5f 68 | 65 6c 70 67 72 6f 75 70 |c...sp_h|elpgroup|
|000014a0| 00 00 00 73 70 5f 68 65 | 6c 70 69 6e 64 65 78 00 |...sp_he|lpindex.|
|000014b0| 00 00 73 70 5f 68 65 6c | 70 6a 6f 69 6e 73 00 00 |..sp_hel|pjoins..|
|000014c0| 00 0d 02 00 00 4d 01 00 | 00 8b 0d 00 00 af 41 00 |.....M..|......A.|
|000014d0| 00 c0 00 00 00 20 4e 81 | 9b 02 00 80 00 00 1a 00 |..... N.|........|
|000014e0| 90 52 98 e3 24 af ba 5f | 80 04 00 89 82 e3 2d 28 |.R..$.._|......-(|
|000014f0| 7b 1c 89 82 e3 69 bc 77 | 2c 89 82 e3 f1 b1 19 a6 |{....i.w|,.......|
|00001500| 89 82 e3 8a e8 f0 ab 89 | 82 e3 fa 71 52 22 89 82 |........|...qR"..|
|00001510| e3 91 ac 47 29 89 82 e3 | 49 cb b2 e0 89 82 e3 33 |...G)...|I......3|
|00001520| 54 7d 8c 89 82 e3 34 37 | 19 a7 89 96 0f 00 00 af |T}....47|........|
|00001530| 41 00 00 32 0a 00 00 82 | e3 52 52 d0 e4 89 82 e3 |A..2....|.RR.....|
|00001540| fd b3 8f 5a 89 82 e3 4f | b2 16 3a 89 82 e3 84 6a |...Z...O|..:....j|
|00001550| 3c fc 89 82 e3 29 ed d4 | 8b 89 82 e3 c8 10 84 d6 |<....)..|........|
|00001560| 89 82 e3 13 cc ab 50 89 | 82 e3 de 74 a4 44 89 82 |......P.|...t.D..|
|00001570| e3 3f cb fb 0d 89 82 e3 | 98 12 4a 24 89 82 e3 96 |.?......|..J$....|
|00001580| 82 34 57 89 82 e3 6e a4 | 88 9a 89 82 ff 00 00 73 |.4W...n.|.......s|
|00001590| 70 5f 68 65 6c 70 6b 65 | 79 00 00 00 73 70 5f 68 |p_helpke|y...sp_h|
|000015a0| 65 6c 70 6c 61 6e 67 75 | 61 67 65 00 00 00 73 70 |elplangu|age...sp|
|000015b0| 5f 68 65 6c 70 6c 6f 67 | 00 00 00 73 70 5f 68 65 |_helplog|...sp_he|
|000015c0| 6c 70 72 65 6d 6f 74 65 | 6c 6f 67 69 6e 00 00 00 |lpremote|login...|
|000015d0| 73 70 5f 68 65 6c 70 72 | 6f 74 65 63 74 00 00 00 |sp_helpr|otect...|
|000015e0| 73 70 5f 68 65 6c 70 73 | 65 67 6d 65 6e 74 00 00 |sp_helps|egment..|
|000015f0| 00 73 70 5f 68 65 6c 70 | 73 65 72 76 65 72 00 00 |.sp_help|server..|
|00001600| 00 73 70 5f 68 65 6c 70 | 73 6f 72 74 00 00 00 73 |.sp_help|sort...s|
|00001610| 70 5f 68 65 6c 70 73 71 | 6c 00 00 00 73 70 5f 68 |p_helpsq|l...sp_h|
|00001620| 65 6c 70 74 65 78 74 00 | 00 00 73 70 5f 68 65 6c |elptext.|..sp_hel|
|00001630| 70 75 73 65 72 00 00 00 | 73 70 5f 6c 6f 63 6b 00 |puser...|sp_lock.|
|00001640| 00 00 73 70 5f 6c 6f 67 | 64 65 76 69 63 65 00 00 |..sp_log|device..|
|00001650| 00 73 70 5f 6d 6f 6e 69 | 74 6f 72 00 00 00 73 70 |.sp_moni|tor...sp|
|00001660| 5f 70 61 73 73 77 6f 72 | 64 00 00 00 73 70 5f 70 |_passwor|d...sp_p|
|00001670| 6c 61 63 65 6f 62 6a 65 | 63 74 00 00 00 73 70 5f |laceobje|ct...sp_|
|00001680| 70 72 69 6d 61 72 79 6b | 65 79 00 00 00 73 70 5f |primaryk|ey...sp_|
|00001690| 72 65 63 6f 6d 70 69 6c | 65 00 00 00 73 70 5f 72 |recompil|e...sp_r|
|000016a0| 65 6d 6f 74 65 6f 70 74 | 69 6f 6e 00 00 00 73 70 |emoteopt|ion...sp|
|000016b0| 5f 72 65 6e 61 6d 65 00 | 00 00 73 70 5f 72 65 6e |_rename.|..sp_ren|
|000016c0| 61 6d 65 64 62 00 00 00 | 73 70 5f 73 65 72 76 65 |amedb...|sp_serve|
|000016d0| 72 6f 70 74 69 6f 6e 00 | 00 00 96 00 00 00 4e 00 |roption.|......N.|
|000016e0| 00 00 96 0f 00 00 45 42 | 00 00 48 00 00 00 20 60 |......EB|..H... `|
|000016f0| 80 9c 00 80 00 00 1a 00 | 90 52 98 e3 66 5e 95 38 |........|.R..f^.8|
|00001700| 80 04 00 89 82 e3 5d 68 | 99 40 89 82 e3 4d 28 59 |......]h|.@...M(Y|
|00001710| 2d 89 82 e3 2b e1 50 a2 | 89 82 e3 dc 2e 33 3f 89 |-...+.P.|.....3?.|
|00001720| 82 ff 00 00 73 70 5f 73 | 65 74 6c 61 6e 67 61 6c |....sp_s|etlangal|
|00001730| 69 61 73 00 00 00 73 70 | 5f 73 70 61 63 65 75 73 |ias...sp|_spaceus|
|00001740| 65 64 00 00 00 73 70 5f | 75 6e 62 69 6e 64 65 66 |ed...sp_|unbindef|
|00001750| 61 75 6c 74 00 00 00 73 | 70 5f 75 6e 62 69 6e 64 |ault...s|p_unbind|
|00001760| 72 75 6c 65 00 00 00 73 | 70 5f 77 68 6f 00 00 00 |rule...s|p_who...|
|00001770| 4b 00 00 00 1a 00 00 00 | af 41 00 00 90 42 00 00 |K.......|.A...B..|
|00001780| 31 00 00 00 02 37 01 00 | 00 ff ff ff ff ff ff ff |1....7..|........|
|00001790| ff 03 00 00 00 90 42 00 | 00 9d 43 00 00 a3 44 00 |......B.|..C...D.|
|000017a0| 00 45 78 74 65 6e 64 65 | 64 20 53 74 6f 72 65 64 |.Extende|d Stored|
|000017b0| 20 50 72 6f 63 65 64 75 | 72 65 73 44 00 00 00 1d | Procedu|resD....|
|000017c0| 00 00 00 45 42 00 00 d4 | 42 00 00 27 00 00 00 20 |...EB...|B..'... |
|000017d0| 1e 80 3a 00 80 00 00 1e | 00 b8 98 42 98 80 03 00 |..:.....|...B....|
|000017e0| 82 ff 00 45 78 74 65 6e | 64 65 64 20 53 74 6f 72 |...Exten|ded Stor|
|000017f0| 65 64 20 50 72 6f 63 65 | 64 75 72 65 73 00 00 c9 |ed Proce|dures...|
|00001800| 00 00 00 9f 00 00 00 90 | 42 00 00 9d 43 00 00 2a |........|B...C..*|
|00001810| 00 00 00 20 22 80 3f 01 | 00 80 00 00 18 00 52 98 |... ".?.|......R.|
|00001820| 80 04 00 82 80 06 00 82 | ff 00 45 78 74 65 6e 64 |........|..Extend|
|00001830| 65 64 20 73 74 6f 72 65 | 64 20 70 72 6f 63 65 64 |ed store|d proced|
|00001840| 75 72 65 73 20 70 72 6f | 76 69 64 65 20 61 20 77 |ures pro|vide a w|
|00001850| 61 79 20 74 6f 20 65 78 | 74 65 6e 64 20 74 68 65 |ay to ex|tend the|
|00001860| 20 63 61 70 61 62 69 6c | 69 74 69 65 73 20 6f 66 | capabil|ities of|
|00001870| 20 53 51 4c 20 53 65 72 | 76 65 72 2e 20 42 79 20 | SQL Ser|ver. By |
|00001880| 64 65 66 61 75 6c 74 2c | 20 6f 6e 6c 79 20 74 68 |default,| only th|
|00001890| 65 20 73 79 73 74 65 6d | 20 61 64 6d 69 6e 69 73 |e system| adminis|
|000018a0| 74 72 61 74 6f 72 20 63 | 61 6e 20 65 78 65 63 75 |trator c|an execu|
|000018b0| 74 65 20 74 68 65 73 65 | 20 70 72 6f 63 65 64 75 |te these| procedu|
|000018c0| 72 65 73 2e 00 00 00 00 | 06 01 00 00 9a 00 00 00 |res.....|........|
|000018d0| d4 42 00 00 a3 44 00 00 | 6c 00 00 00 20 a6 80 35 |.B...D..|l... ..5|
|000018e0| 01 00 80 00 00 1a 00 90 | 52 98 e3 fd 7a e0 a6 80 |........|R...z...|
|000018f0| 04 00 89 82 e3 e8 e5 0d | 2d 89 82 e3 fb c2 38 08 |........|-.....8.|
|00001900| 89 82 e3 f5 ae 65 a8 89 | 82 e3 f1 76 e0 76 89 82 |.....e..|...v.v..|
|00001910| e3 99 65 7b 3a 89 82 e3 | d5 0d 5c 1f 89 82 e3 63 |..e{:...|..\....c|
|00001920| 25 55 05 89 82 e3 a1 6e | 0f 90 89 82 e3 91 7f 47 |%U.....n|.......G|
|00001930| 24 89 82 ff 00 00 78 70 | 5f 63 6d 64 73 68 65 6c |$.....xp|_cmdshel|
|00001940| 6c 00 00 00 78 70 5f 65 | 6e 75 6d 67 72 6f 75 70 |l...xp_e|numgroup|
|00001950| 73 00 00 00 78 70 5f 67 | 72 61 6e 74 6c 6f 67 69 |s...xp_g|rantlogi|
|00001960| 6e 00 00 00 78 70 5f 6c | 6f 67 65 76 65 6e 74 00 |n...xp_l|ogevent.|
|00001970| 00 00 78 70 5f 6c 6f 67 | 69 6e 63 6f 6e 66 69 67 |..xp_log|inconfig|
|00001980| 00 00 00 78 70 5f 6c 6f | 67 69 6e 69 6e 66 6f 00 |...xp_lo|gininfo.|
|00001990| 00 00 78 70 5f 72 65 76 | 6f 6b 65 6c 6f 67 69 6e |..xp_rev|okelogin|
|000019a0| 00 00 00 78 70 5f 73 65 | 6e 64 6d 61 69 6c 00 00 |...xp_se|ndmail..|
|000019b0| 00 78 70 5f 73 74 61 72 | 74 6d 61 69 6c 00 00 00 |.xp_star|tmail...|
|000019c0| 78 70 5f 73 74 6f 70 6d | 61 69 6c 00 00 00 4a 00 |xp_stopm|ail...J.|
|000019d0| 00 00 19 00 00 00 9d 43 | 00 00 ed 44 00 00 31 00 |.......C|...D..1.|
|000019e0| 00 00 02 92 01 00 00 ff | ff ff ff ff ff ff ff 04 |........|........|
|000019f0| 00 00 00 ed 44 00 00 8d | 46 00 00 ee 47 00 00 43 |....D...|F...G..C|
|00001a00| 61 74 61 6c 6f 67 20 53 | 74 6f 72 65 64 20 50 72 |atalog S|tored Pr|
|00001a10| 6f 63 65 64 75 72 65 73 | 44 00 00 00 1c 00 00 00 |ocedures|D.......|
|00001a20| a3 44 00 00 31 45 00 00 | 28 00 00 00 20 20 80 38 |.D..1E..|(... .8|
|00001a30| 00 80 00 00 3e 00 b8 98 | 42 98 90 80 03 00 82 ff |....>...|B.......|
|00001a40| 00 43 61 74 61 6c 6f 67 | 20 53 74 6f 72 65 64 20 |.Catalog| Stored |
|00001a50| 50 72 6f 63 65 64 75 72 | 65 73 00 00 5c 01 00 00 |Procedur|es..\...|
|00001a60| 32 01 00 00 ed 44 00 00 | 8d 46 00 00 2a 00 00 00 |2....D..|.F..*...|
|00001a70| 20 22 80 65 02 00 80 00 | 00 18 00 52 98 80 04 00 | ".e....|...R....|
|00001a80| 82 80 06 00 82 ff 00 54 | 68 69 73 20 74 6f 70 69 |.......T|his topi|
|00001a90| 63 20 6c 69 73 74 73 20 | 74 68 65 20 63 61 74 61 |c lists |the cata|
|00001aa0| 6c 6f 67 20 73 74 6f 72 | 65 64 20 70 72 6f 63 65 |log stor|ed proce|
|00001ab0| 64 75 72 65 73 2e 20 54 | 68 65 73 65 20 73 74 6f |dures. T|hese sto|
|00001ac0| 72 65 64 20 70 72 6f 63 | 65 64 75 72 65 73 20 68 |red proc|edures h|
|00001ad0| 61 76 65 20 62 65 65 6e | 20 61 64 64 65 64 20 74 |ave been| added t|
|00001ae0| 6f 20 4d 69 63 72 6f 73 | 6f 66 74 20 53 51 4c 20 |o Micros|oft SQL |
|00001af0| 53 65 72 76 65 72 20 61 | 73 20 61 20 75 6e 69 66 |Server a|s a unif|
|00001b00| 6f 72 6d 20 63 61 74 61 | 6c 6f 67 20 69 6e 74 65 |orm cata|log inte|
|00001b10| 72 66 61 63 65 20 66 6f | 72 20 61 63 63 65 73 73 |rface fo|r access|
|00001b20| 69 6e 67 20 64 61 74 61 | 62 61 73 65 20 67 61 74 |ing data|base gat|
|00001b30| 65 77 61 79 73 20 61 73 | 20 77 65 6c 6c 20 61 73 |eways as| well as|
|00001b40| 20 53 51 4c 20 53 65 72 | 76 65 72 2e 20 54 68 65 | SQL Ser|ver. The|
|00001b50| 79 20 61 72 65 20 63 6f | 6d 70 61 74 69 62 6c 65 |y are co|mpatible|
|00001b60| 20 77 69 74 68 20 74 68 | 65 20 63 61 74 61 6c 6f | with th|e catalo|
|00001b70| 67 20 69 6e 74 65 72 66 | 61 63 65 20 66 6f 72 20 |g interf|ace for |
|00001b80| 74 68 65 20 4d 69 63 72 | 6f 73 6f 66 74 20 4f 70 |the Micr|osoft Op|
|00001b90| 65 6e 20 44 61 74 61 62 | 61 73 65 20 43 6f 6e 6e |en Datab|ase Conn|
|00001ba0| 65 63 74 69 76 69 74 79 | 20 28 4f 44 42 43 29 20 |ectivity| (ODBC) |
|00001bb0| 41 50 49 2e 00 00 00 00 | 61 01 00 00 e0 00 00 00 |API.....|a.......|
|00001bc0| 31 45 00 00 ee 47 00 00 | 81 00 00 00 20 d0 80 c1 |1E...G..|.... ...|
|00001bd0| 01 00 80 00 00 1a 00 90 | 52 98 e3 cd aa e4 bc 80 |........|R.......|
|00001be0| 04 00 89 82 e3 83 8b 70 | fc 89 82 e3 26 88 78 d9 |.......p|....&.x.|
|00001bf0| 89 82 e3 c2 c1 89 de 89 | 82 e3 30 ba 0c 46 89 82 |........|..0..F..|
|00001c00| e3 fa 49 4e fc 89 82 e3 | 7b cd 85 80 89 82 e3 47 |..IN....|{......G|
|00001c10| 28 cf 3a 89 82 e3 9c e8 | f0 27 89 82 e3 79 ba f4 |(.:.....|.'...y..|
|00001c20| a2 89 82 e3 0f 27 42 1b | 89 82 e3 f3 2d 7c 9c 89 |.....'B.|....-|..|
|00001c30| 82 e3 5f 3e ee 0d 89 82 | ff 00 00 73 70 5f 63 6f |.._>....|...sp_co|
|00001c40| 6c 75 6d 6e 5f 70 72 69 | 76 69 6c 65 67 65 73 00 |lumn_pri|vileges.|
|00001c50| 00 00 73 70 5f 63 6f 6c | 75 6d 6e 73 00 00 00 73 |..sp_col|umns...s|
|00001c60| 70 5f 64 61 74 61 62 61 | 73 65 73 00 00 00 73 70 |p_databa|ses...sp|
|00001c70| 5f 64 61 74 61 74 79 70 | 65 5f 69 6e 66 6f 00 00 |_datatyp|e_info..|
|00001c80| 00 73 70 5f 66 6b 65 79 | 73 00 00 00 73 70 5f 70 |.sp_fkey|s...sp_p|
|00001c90| 6b 65 79 73 00 00 00 73 | 70 5f 73 65 72 76 65 72 |keys...s|p_server|
|00001ca0| 5f 69 6e 66 6f 00 00 00 | 73 70 5f 73 70 65 63 69 |_info...|sp_speci|
|00001cb0| 61 6c 5f 63 6f 6c 75 6d | 6e 73 00 00 00 73 70 5f |al_colum|ns...sp_|
|00001cc0| 73 70 72 6f 63 5f 63 6f | 6c 75 6d 6e 73 00 00 00 |sproc_co|lumns...|
|00001cd0| 73 70 5f 73 74 61 74 69 | 73 74 69 63 73 00 00 00 |sp_stati|stics...|
|00001ce0| 73 70 5f 73 74 6f 72 65 | 64 5f 70 72 6f 63 65 64 |sp_store|d_proced|
|00001cf0| 75 72 65 73 00 00 00 73 | 70 5f 74 61 62 6c 65 5f |ures...s|p_table_|
|00001d00| 70 72 69 76 69 6c 65 67 | 65 73 00 00 00 73 70 5f |privileg|es...sp_|
|00001d10| 74 61 62 6c 65 73 00 00 | 00 3a 00 00 00 09 00 00 |tables..|.:......|
|00001d20| 00 8d 46 00 00 28 48 00 | 00 31 00 00 00 02 33 07 |..F..(H.|.1....3.|
|00001d30| 00 00 ff ff ff ff ff ff | ff ff 05 00 00 00 28 48 |........|......(H|
|00001d40| 00 00 e8 49 00 00 f6 80 | 00 00 46 75 6e 63 74 69 |...I....|..Functi|
|00001d50| 6f 6e 73 33 00 00 00 0c | 00 00 00 ee 47 00 00 5b |ons3....|....G..[|
|00001d60| 48 00 00 27 00 00 00 20 | 1e 80 18 00 80 00 00 1e |H..'... |........|
|00001d70| 00 b8 98 42 98 80 03 00 | 82 ff 00 46 75 6e 63 74 |...B....|...Funct|
|00001d80| 69 6f 6e 73 00 00 64 01 | 00 00 3e 01 00 00 28 48 |ions..d.|..>...(H|
|00001d90| 00 00 bf 49 00 00 26 00 | 00 00 20 1a 80 7d 02 00 |...I..&.|.. ..}..|
|00001da0| 80 00 00 18 00 52 98 80 | 04 00 82 ff 00 46 75 6e |.....R..|.....Fun|
|00001db0| 63 74 69 6f 6e 73 20 72 | 65 74 75 72 6e 20 73 70 |ctions r|eturn sp|
|00001dc0| 65 63 69 61 6c 20 69 6e | 66 6f 72 6d 61 74 69 6f |ecial in|formatio|
|00001dd0| 6e 20 66 72 6f 6d 20 74 | 68 65 20 64 61 74 61 62 |n from t|he datab|
|00001de0| 61 73 65 2e 20 46 75 6e | 63 74 69 6f 6e 73 20 61 |ase. Fun|ctions a|
|00001df0| 72 65 20 75 73 65 64 20 | 69 6e 20 53 45 4c 45 43 |re used |in SELEC|
|00001e00| 54 20 73 74 61 74 65 6d | 65 6e 74 73 20 61 6e 64 |T statem|ents and|
|00001e10| 20 61 72 65 20 64 69 76 | 69 64 65 64 20 69 6e 74 | are div|ided int|
|00001e20| 6f 20 61 67 67 72 65 67 | 61 74 65 20 66 75 6e 63 |o aggreg|ate func|
|00001e30| 74 69 6f 6e 73 2c 20 64 | 61 74 65 20 66 75 6e 63 |tions, d|ate func|
|00001e40| 74 69 6f 6e 73 2c 20 6d | 61 74 68 65 6d 61 74 69 |tions, m|athemati|
|00001e50| 63 61 6c 20 66 75 6e 63 | 74 69 6f 6e 73 2c 20 73 |cal func|tions, s|
|00001e60| 74 72 69 6e 67 20 66 75 | 6e 63 74 69 6f 6e 73 2c |tring fu|nctions,|
|00001e70| 20 73 79 73 74 65 6d 20 | 66 75 6e 63 74 69 6f 6e | system |function|
|00001e80| 73 2c 20 74 65 78 74 2f | 69 6d 61 67 65 20 66 75 |s, text/|image fu|
|00001e90| 6e 63 74 69 6f 6e 73 2c | 20 61 6e 64 20 74 79 70 |nctions,| and typ|
|00001ea0| 65 2d 63 6f 6e 76 65 72 | 73 69 6f 6e 20 66 75 6e |e-conver|sion fun|
|00001eb0| 63 74 69 6f 6e 73 2e 20 | 48 65 6c 70 20 69 73 20 |ctions. |Help is |
|00001ec0| 61 76 61 69 6c 61 62 6c | 65 20 66 6f 72 20 74 68 |availabl|e for th|
|00001ed0| 65 20 66 75 6e 63 74 69 | 6f 6e 20 67 72 6f 75 70 |e functi|on group|
|00001ee0| 73 20 62 65 6c 6f 77 3a | 00 00 29 00 00 00 03 00 |s below:|..).....|
|00001ef0| 00 00 5b 48 00 00 e8 49 | 00 00 26 00 00 00 20 1c |..[H...I|..&... .|
|00001f00| 80 06 00 80 00 00 1a 00 | 90 52 98 80 06 00 82 ff |........|.R......|
|00001f10| 00 00 00 45 00 00 00 19 | 00 00 00 bf 49 00 00 2d |...E....|....I..-|
|00001f20| 4a 00 00 2c 00 00 00 20 | 28 80 32 00 80 00 00 1a |J..,... |(.2.....|
|00001f30| 00 90 52 98 e3 bf 13 05 | 36 80 04 00 89 82 ff 00 |..R.....|6.......|
|00001f40| 00 41 67 67 72 65 67 61 | 74 65 20 46 75 6e 63 74 |.Aggrega|te Funct|
|00001f50| 69 6f 6e 73 3a 00 00 00 | 7d 00 00 00 2d 00 00 00 |ions:...|}...-...|
|00001f60| e8 49 00 00 aa 4a 00 00 | 50 00 00 00 20 70 80 5a |.I...J..|P... p.Z|
|00001f70| 00 80 00 00 5a 00 8c 52 | f8 52 e3 88 a4 06 57 80 |....Z..R|.R....W.|
|00001f80| 04 00 89 82 e3 d1 45 eb | 7b 89 82 e3 45 8e a9 5a |......E.|{...E..Z|
|00001f90| 89 82 e3 de 08 df 4b 89 | 82 e3 cc bb ee 8f 89 82 |......K.|........|
|00001fa0| e3 55 b0 92 cd 89 82 ff | 00 00 41 56 47 00 00 00 |.U......|..AVG...|
|00001fb0| 43 4f 55 4e 54 00 00 00 | 43 4f 55 4e 54 28 2a 29 |COUNT...|COUNT(*)|
|00001fc0| 00 00 00 4d 41 58 00 00 | 00 4d 49 4e 00 00 00 53 |...MAX..|.MIN...S|
|00001fd0| 55 4d 00 00 00 59 00 00 | 00 26 00 00 00 2d 4a 00 |UM...Y..|.&...-J.|
|00001fe0| 00 03 4b 00 00 33 00 00 | 00 20 36 80 4c 00 80 00 |..K..3..|. 6.L...|
|00001ff0| 00 1a 00 90 52 98 e3 8c | 6d ee 60 80 04 00 89 82 |....R...|m.`.....|
|00002000| e3 6c f8 20 06 89 82 ff | 00 00 43 4f 4e 56 45 52 |.l. ....|..CONVER|
|00002010| 54 20 46 75 6e 63 74 69 | 6f 6e 00 00 00 44 61 74 |T Functi|on...Dat|
|00002020| 65 20 46 75 6e 63 74 69 | 6f 6e 73 00 00 00 80 00 |e Functi|ons.....|
|00002030| 00 00 37 00 00 00 aa 4a | 00 00 83 4b 00 00 49 00 |..7....J|...K..I.|
|00002040| 00 00 20 62 80 6e 00 80 | 00 00 5a 00 8c 52 f8 52 |.. b.n..|..Z..R.R|
|00002050| e3 41 94 14 37 80 04 00 | 89 82 e3 d1 80 a2 8c 89 |.A..7...|........|
|00002060| 82 e3 53 45 06 e4 89 82 | e3 9f 53 32 a6 89 82 e3 |..SE....|..S2....|
|00002070| f6 59 4b 55 89 82 ff 00 | 00 44 41 54 45 41 44 44 |.YKU....|.DATEADD|
|00002080| 00 00 00 44 41 54 45 44 | 49 46 46 00 00 00 44 41 |...DATED|IFF...DA|
|00002090| 54 45 4e 41 4d 45 00 00 | 00 44 41 54 45 50 41 52 |TENAME..|.DATEPAR|
|000020a0| 54 00 00 00 47 45 54 44 | 41 54 45 00 00 00 47 00 |T...GETD|ATE...G.|
|000020b0| 00 00 1b 00 00 00 03 4b | 00 00 ca 4b 00 00 2c 00 |.......K|...K..,.|
|000020c0| 00 00 20 28 80 36 00 80 | 00 00 1a 00 90 52 98 e3 |.. (.6..|.....R..|
|000020d0| 36 d7 7b b6 80 04 00 89 | 82 ff 00 00 4d 61 74 68 |6.{.....|....Math|
|000020e0| 65 6d 61 74 69 63 61 6c | 20 46 75 6e 63 74 69 6f |ematical| Functio|
|000020f0| 6e 73 00 00 00 61 01 00 | 00 a0 00 00 00 83 4b 00 |ns...a..|......K.|
|00002100| 00 2b 4d 00 00 c1 00 00 | 00 20 50 81 41 01 00 80 |.+M.....|. P.A...|
|00002110| 00 00 5a 00 8c 52 f8 52 | e3 38 3a 39 aa 80 04 00 |..Z..R.R|.8:9....|
|00002120| 89 82 e3 5c 97 c7 f1 89 | 82 e3 15 42 b5 48 89 82 |...\....|...B.H..|
|00002130| e3 a6 3c 64 7b 89 82 e3 | c9 c9 98 e7 89 82 e3 c7 |..<d{...|........|
|00002140| b0 e8 c5 89 82 e3 89 23 | b3 0d 89 82 e3 3a 4e e7 |.......#|.....:N.|
|00002150| 0d 89 82 e3 85 1d 93 e8 | 89 82 e3 db dd 83 4d 89 |........|......M.|
|00002160| 82 e3 ee 27 b3 ef 89 82 | e3 ee 3e 4c 4a 89 82 e3 |...'....|..>LJ...|
|00002170| 53 27 c9 34 89 82 e3 8f | 14 8e 1d 89 82 e3 9b 52 |S'.4....|.......R|
|00002180| 8c f1 89 82 e3 c8 3e e6 | 80 89 82 e3 43 ae 79 d8 |......>.|....C.y.|
|00002190| 89 82 e3 70 f2 0a 0a 89 | 82 e3 fb c3 16 ad 89 82 |...p....|........|
|000021a0| e3 42 ce a0 64 89 82 e3 | 72 68 f5 d4 89 82 e3 d3 |.B..d...|rh......|
|000021b0| c8 4f 97 89 82 ff 00 00 | 41 42 53 00 00 00 41 43 |.O......|ABS...AC|
|000021c0| 4f 53 00 00 00 41 53 49 | 4e 00 00 00 41 54 41 4e |OS...ASI|N...ATAN|
|000021d0| 00 00 00 41 54 4e 32 00 | 00 00 43 45 49 4c 49 4e |...ATN2.|..CEILIN|
|000021e0| 47 00 00 00 43 4f 53 00 | 00 00 43 4f 54 00 00 00 |G...COS.|..COT...|
|000021f0| 44 45 47 52 45 45 53 00 | 00 00 45 58 50 00 00 00 |DEGREES.|..EXP...|
|00002200| 46 4c 4f 4f 52 00 00 00 | 4c 4f 47 00 00 00 4c 4f |FLOOR...|LOG...LO|
|00002210| 47 31 30 00 00 00 50 49 | 00 00 00 50 4f 57 45 52 |G10...PI|...POWER|
|00002220| 00 00 00 52 41 44 49 41 | 4e 53 00 00 00 52 41 4e |...RADIA|NS...RAN|
|00002230| 44 00 00 00 52 4f 55 4e | 44 00 00 00 53 49 47 4e |D...ROUN|D...SIGN|
|00002240| 00 00 00 53 49 4e 00 00 | 00 53 51 52 54 00 00 00 |...SIN..|.SQRT...|
|00002250| 54 41 4e 00 00 00 41 00 | 00 00 15 00 00 00 ca 4b |TAN...A.|.......K|
|00002260| 00 00 6c 4d 00 00 2c 00 | 00 00 20 28 80 2a 00 80 |..lM..,.|.. (.*..|
|00002270| 00 00 1a 00 90 52 98 e3 | af e3 aa da 80 04 00 89 |.....R..|........|
|00002280| 82 ff 00 00 53 74 72 69 | 6e 67 20 46 75 6e 63 74 |....Stri|ng Funct|
|00002290| 69 6f 6e 73 00 00 00 48 | 01 00 00 a3 00 00 00 2b |ions...H|.......+|
|000022a0| 4d 00 00 b4 4e 00 00 a5 | 00 00 00 20 18 81 47 01 |M...N...|... ..G.|
|000022b0| 00 80 00 00 5a 00 8c 52 | f8 52 e3 f7 a7 55 38 80 |....Z..R|.R...U8.|
|000022c0| 04 00 89 82 e3 c4 75 1e | 66 89 82 e3 d6 21 0f e2 |......u.|f....!..|
|000022d0| 89 82 e3 4f ed 56 9a 89 | 82 e3 17 19 72 75 89 82 |...O.V..|....ru..|
|000022e0| e3 b0 78 d2 ab 89 82 e3 | c1 f1 5d 96 89 82 e3 87 |..x.....|..].....|
|000022f0| a3 30 0b 89 82 e3 2c e8 | 6b 0f 89 82 e3 8e a7 dc |.0....,.|k.......|
|00002300| 83 89 82 e3 f6 ce f9 e5 | 89 82 e3 38 73 de 28 89 |........|...8s.(.|
|00002310| 82 e3 e8 bb e2 e2 89 82 | e3 0f 5a d4 c5 89 82 e3 |........|..Z.....|
|00002320| 8a b8 a2 93 89 82 e3 77 | de 87 ca 89 82 e3 44 89 |.......w|......D.|
|00002330| d9 c8 89 82 e3 fc 79 2c | b6 89 82 ff 00 00 41 53 |......y,|......AS|
|00002340| 43 49 49 00 00 00 43 48 | 41 52 00 00 00 43 48 41 |CII...CH|AR...CHA|
|00002350| 52 49 4e 44 45 58 00 00 | 00 44 49 46 46 45 52 45 |RINDEX..|.DIFFERE|
|00002360| 4e 43 45 00 00 00 4c 4f | 57 45 52 00 00 00 4c 54 |NCE...LO|WER...LT|
|00002370| 52 49 4d 00 00 00 50 41 | 54 49 4e 44 45 58 00 00 |RIM...PA|TINDEX..|
|00002380| 00 52 45 50 4c 49 43 41 | 54 45 00 00 00 52 45 56 |.REPLICA|TE...REV|
|00002390| 45 52 53 45 00 00 00 52 | 49 47 48 54 00 00 00 52 |ERSE...R|IGHT...R|
|000023a0| 54 52 49 4d 00 00 00 53 | 4f 55 4e 44 45 58 00 00 |TRIM...S|OUNDEX..|
|000023b0| 00 53 50 41 43 45 00 00 | 00 53 54 52 00 00 00 53 |.SPACE..|.STR...S|
|000023c0| 54 55 46 46 00 00 00 53 | 55 42 53 54 52 49 4e 47 |TUFF...S|UBSTRING|
|000023d0| 00 00 00 55 50 50 45 52 | 00 00 00 2b 00 00 00 41 |...UPPER|...+...A|
|000023e0| 00 00 00 15 00 00 00 6c | 4d 00 00 f5 4e 00 00 2c |.......l|M...N..,|
|000023f0| 00 00 00 20 28 80 2a 00 | 80 00 00 1a 00 90 52 98 |... (.*.|......R.|
|00002400| e3 ed e0 f1 21 80 04 00 | 89 82 ff 00 00 53 79 73 |....!...|.....Sys|
|00002410| 74 65 6d 20 46 75 6e 63 | 74 69 6f 6e 73 00 00 00 |tem Func|tions...|
|00002420| 3c 01 00 00 ac 00 00 00 | b4 4e 00 00 3d 80 00 00 |<.......|.N..=...|
|00002430| 90 00 00 00 20 ee 80 59 | 01 00 80 00 00 5a 00 8c |.... ..Y|.....Z..|
|00002440| 52 f8 52 e3 b9 f1 de 43 | 80 04 00 89 82 e3 4c 74 |R.R....C|......Lt|
|00002450| 9f 7d 89 82 e3 0e 2c 9f | 2c 89 82 e3 1b 45 52 1e |.}....,.|,....ER.|
|00002460| 89 82 e3 5b 97 cb 91 89 | 82 e3 d1 71 68 81 89 82 |...[....|...qh...|
|00002470| e3 e1 85 f4 3c 89 82 e3 | 64 04 e9 4f 89 82 e3 93 |....<...|d..O....|
|00002480| 86 0d 18 89 82 e3 dc 39 | c1 d3 89 82 e3 54 5d 31 |.......9|.....T]1|
|00002490| 00 89 82 e3 53 5c 7d 52 | 89 82 e3 d3 4a 06 5d 89 |....S\}R|....J.].|
|000024a0| 82 e3 68 f9 22 84 89 82 | e3 80 d7 31 f2 89 82 ff |..h."...|...1....|
|000024b0| 00 00 43 4f 4c 5f 4e 41 | 4d 45 00 00 00 43 4f 4c |..COL_NA|ME...COL|
|000024c0| 5f 4c 45 4e 47 54 48 00 | 00 00 44 41 54 41 4c 45 |_LENGTH.|..DATALE|
|000024d0| 4e 47 54 48 00 00 00 44 | 42 5f 49 44 00 00 00 44 |NGTH...D|B_ID...D|
|000024e0| 42 5f 4e 41 4d 45 00 00 | 00 48 4f 53 54 5f 49 44 |B_NAME..|.HOST_ID|
|000024f0| 00 00 00 48 4f 53 54 5f | 4e 41 4d 45 00 00 00 49 |...HOST_|NAME...I|
|00002500| 4e 44 45 58 5f 43 4f 4c | 00 00 00 49 53 4e 55 4c |NDEX_COL|...ISNUL|
|00002510| 4c 00 00 00 4f 42 4a 45 | 43 54 5f 49 44 00 00 00 |L...OBJE|CT_ID...|
|00002520| 4f 42 4a 45 43 54 5f 4e | 41 4d 45 f5 4e 00 00 3d |OBJECT_N|AME.N..=|
|00002530| 80 00 00 ee 47 00 00 00 | 00 00 53 55 53 45 52 5f |....G...|..SUSER_|
|00002540| 49 44 00 00 00 53 55 53 | 45 52 5f 4e 41 4d 45 00 |ID...SUS|ER_NAME.|
|00002550| 00 00 55 53 45 52 5f 49 | 44 00 00 00 55 53 45 52 |..USER_I|D...USER|
|00002560| 5f 4e 41 4d 45 00 00 00 | 45 00 00 00 19 00 00 00 |_NAME...|E.......|
|00002570| f5 4e 00 00 82 80 00 00 | 2c 00 00 00 20 28 80 32 |.N......|,... (.2|
|00002580| 00 80 00 00 1a 00 90 52 | 98 e3 44 08 28 d2 80 04 |.......R|..D.(...|
|00002590| 00 89 82 ff 00 00 54 65 | 78 74 2f 49 6d 61 67 65 |......Te|xt/Image|
|000025a0| 20 46 75 6e 63 74 69 6f | 6e 73 00 00 00 74 00 00 | Functio|ns...t..|
|000025b0| 00 32 00 00 00 3d 80 00 | 00 f6 80 00 00 42 00 00 |.2...=..|.....B..|
|000025c0| 00 20 54 80 64 00 80 00 | 00 5a 00 8c 52 f8 52 e3 |. T.d...|.Z..R.R.|
|000025d0| c1 f1 5d 96 80 04 00 89 | 82 e3 b8 67 7b 62 89 82 |..].....|...g{b..|
|000025e0| e3 93 20 cd e4 89 82 e3 | 39 c9 0f e4 89 82 ff 00 |.. .....|9.......|
|000025f0| 00 50 41 54 49 4e 44 45 | 58 00 00 00 53 45 54 20 |.PATINDE|X...SET |
|00002600| 54 45 58 54 53 49 5a 45 | 00 00 00 54 45 58 54 50 |TEXTSIZE|...TEXTP|
|00002610| 54 52 00 00 00 54 45 58 | 54 56 41 4c 49 44 00 00 |TR...TEX|TVALID..|
|00002620| 00 3c 00 00 00 0b 00 00 | 00 82 80 00 00 32 81 00 |.<......|.....2..|
|00002630| 00 31 00 00 00 02 01 01 | 00 00 ff ff ff ff ff ff |.1......|........|
|00002640| ff ff 06 00 00 00 32 81 | 00 00 ff 81 00 00 cf 82 |......2.|........|
|00002650| 00 00 45 78 70 72 65 73 | 73 69 6f 6e 73 35 00 00 |..Expres|sions5..|
|00002660| 00 0e 00 00 00 f6 80 00 | 00 67 81 00 00 27 00 00 |........|.g...'..|
|00002670| 00 20 1e 80 1c 00 80 00 | 00 1e 00 b8 98 42 98 80 |. ......|.....B..|
|00002680| 03 00 82 ff 00 45 78 70 | 72 65 73 73 69 6f 6e 73 |.....Exp|ressions|
|00002690| 00 00 98 00 00 00 6f 00 | 00 00 32 81 00 00 ff 81 |......o.|..2.....|
|000026a0| 00 00 29 00 00 00 20 22 | 80 de 00 80 00 00 18 00 |..)... "|........|
|000026b0| 52 98 80 04 00 82 80 06 | 00 82 ff 00 45 78 70 72 |R.......|....Expr|
|000026c0| 65 73 73 69 6f 6e 73 20 | 72 65 74 75 72 6e 20 76 |essions |return v|
|000026d0| 61 6c 75 65 73 2e 20 54 | 68 65 79 20 61 72 65 20 |alues. T|hey are |
|000026e0| 75 73 65 64 20 61 73 20 | 76 61 72 69 61 62 6c 65 |used as |variable|
|000026f0| 73 2c 20 63 6f 6e 73 74 | 61 6e 74 73 2c 20 61 6e |s, const|ants, an|
|00002700| 64 20 63 6f 6c 75 6d 6e | 20 6e 61 6d 65 73 20 69 |d column| names i|
|00002710| 6e 20 6d 61 6e 79 20 53 | 51 4c 20 73 74 61 74 65 |n many S|QL state|
|00002720| 6d 65 6e 74 73 2e 00 00 | 00 00 d0 00 00 00 80 00 |ments...|........|
|00002730| 00 00 67 81 00 00 cf 82 | 00 00 50 00 00 00 20 6e |..g.....|..P... n|
|00002740| 80 01 01 00 80 00 00 1a | 00 90 52 98 e3 07 02 8c |........|..R.....|
|00002750| 77 80 04 00 89 82 e3 a8 | 43 e3 26 89 82 e3 16 64 |w.......|C.&....d|
|00002760| 1b f3 89 82 e3 df b6 f5 | d1 89 82 e3 a3 96 79 1e |........|......y.|
|00002770| 89 82 e3 a0 e6 bd 56 89 | 82 ff 00 00 41 72 69 74 |......V.|....Arit|
|00002780| 68 6d 65 74 69 63 20 4f | 70 65 72 61 74 6f 72 73 |hmetic O|perators|
|00002790| 00 00 00 42 69 74 77 69 | 73 65 20 4f 70 65 72 61 |...Bitwi|se Opera|
|000027a0| 74 6f 72 73 00 00 00 42 | 6f 6f 6c 65 61 6e 20 45 |tors...B|oolean E|
|000027b0| 78 70 72 65 73 73 69 6f | 6e 00 00 00 43 6f 6d 70 |xpressio|n...Comp|
|000027c0| 61 72 69 73 6f 6e 20 4f | 70 65 72 61 74 6f 72 73 |arison O|perators|
|000027d0| 00 00 00 45 78 70 72 65 | 73 73 69 6f 6e 20 53 79 |...Expre|ssion Sy|
|000027e0| 6e 74 61 78 00 00 00 53 | 74 72 69 6e 67 20 4f 70 |ntax...S|tring Op|
|000027f0| 65 72 61 74 6f 72 73 00 | 00 00 3a 00 00 00 09 00 |erators.|..:.....|
|00002800| 00 00 ff 81 00 00 09 83 | 00 00 31 00 00 00 02 ad |........|..1.....|
|00002810| 01 00 00 ff ff ff ff ff | ff ff ff 07 00 00 00 09 |........|........|
|00002820| 83 00 00 5d 84 00 00 d9 | 85 00 00 44 61 74 61 74 |...]....|...Datat|
|00002830| 79 70 65 73 33 00 00 00 | 0c 00 00 00 cf 82 00 00 |ypes3...|........|
|00002840| 3c 83 00 00 27 00 00 00 | 20 1e 80 18 00 80 00 00 |<...'...| .......|
|00002850| 1e 00 b8 98 42 98 80 03 | 00 82 ff 00 44 61 74 61 |....B...|....Data|
|00002860| 74 79 70 65 73 00 00 21 | 01 00 00 f7 00 00 00 09 |types..!|........|
|00002870| 83 00 00 5d 84 00 00 2a | 00 00 00 20 22 80 ef 01 |...]...*|... "...|
|00002880| 00 80 00 00 18 00 52 98 | 80 04 00 82 80 06 00 82 |......R.|........|
|00002890| ff 00 44 61 74 61 74 79 | 70 65 73 20 69 6e 63 6c |..Dataty|pes incl|
|000028a0| 75 64 65 20 73 79 73 74 | 65 6d 20 64 61 74 61 74 |ude syst|em datat|
|000028b0| 79 70 65 73 20 61 6e 64 | 20 75 73 65 72 2d 64 65 |ypes and| user-de|
|000028c0| 66 69 6e 65 64 20 64 61 | 74 61 74 79 70 65 73 2e |fined da|tatypes.|
|000028d0| 20 53 51 4c 20 53 65 72 | 76 65 72 20 73 75 70 70 | SQL Ser|ver supp|
|000028e0| 6c 69 65 73 20 74 68 65 | 20 73 79 73 6e 61 6d 65 |lies the| sysname|
|000028f0| 20 75 73 65 72 20 64 61 | 74 61 74 79 70 65 2e 20 | user da|tatype. |
|00002900| 54 68 65 20 70 75 62 73 | 20 73 61 6d 70 6c 65 20 |The pubs| sample |
|00002910| 64 61 74 61 62 61 73 65 | 20 61 6c 73 6f 20 73 75 |database| also su|
|00002920| 70 70 6c 69 65 73 20 75 | 73 65 72 20 64 61 74 61 |pplies u|ser data|
|00002930| 74 79 70 65 73 2e 20 59 | 6f 75 20 63 61 6e 20 61 |types. Y|ou can a|
|00002940| 6c 73 6f 20 63 72 65 61 | 74 65 20 79 6f 75 72 20 |lso crea|te your |
|00002950| 6f 77 6e 20 75 73 65 72 | 20 64 61 74 61 74 79 70 |own user| datatyp|
|00002960| 65 73 2e 20 53 6f 6d 65 | 20 64 61 74 61 74 79 70 |es. Some| datatyp|
|00002970| 65 73 20 72 65 71 75 69 | 72 65 20 61 20 6c 65 6e |es requi|re a len|
|00002980| 67 74 68 2e 00 00 00 00 | 54 01 00 00 b1 00 00 00 |gth.....|T.......|
|00002990| 3c 83 00 00 b1 85 00 00 | a3 00 00 00 20 14 81 63 |<.......|.... ..c|
|000029a0| 01 00 80 00 00 1a 00 90 | 52 98 e3 e7 d7 a8 6e 80 |........|R.....n.|
|000029b0| 04 00 89 82 e3 6f ef 8b | 60 89 82 e3 ee 18 88 2a |.....o..|`......*|
|000029c0| 89 82 e3 6d 22 32 64 89 | 80 05 00 82 e3 16 19 6f |...m"2d.|.......o|
|000029d0| 75 80 04 00 89 82 e3 21 | 4e b9 72 89 82 e3 f5 34 |u......!|N.r....4|
|000029e0| d6 d9 89 82 e3 9e b6 da | 96 89 82 e3 f0 2c 53 4b |........|.....,SK|
|000029f0| 89 82 e3 10 cf 2c 30 89 | 82 e3 2e 05 f1 15 89 82 |.....,0.|........|
|00002a00| e3 4f a2 84 b4 89 82 e3 | 8b 23 cb a9 89 82 e3 b8 |.O......|.#......|
|00002a10| 67 8f 16 89 82 e3 45 5e | 90 f5 89 82 e3 a2 17 47 |g.....E^|.......G|
|00002a20| fd 89 82 e3 57 60 1f 2e | 89 82 ff 00 00 42 69 6e |....W`..|.....Bin|
|00002a30| 61 72 79 28 6e 29 00 00 | 00 42 69 74 00 00 00 43 |ary(n)..|.Bit...C|
|00002a40| 68 61 72 28 6e 29 00 00 | 00 44 61 74 65 74 69 6d |har(n)..|.Datetim|
|00002a50| 65 00 00 00 00 00 46 6c | 6f 61 74 00 00 00 49 6d |e.....Fl|oat...Im|
|00002a60| 61 67 65 00 00 00 49 6e | 74 00 00 00 4d 6f 6e 65 |age...In|t...Mone|
|00002a70| 79 00 00 00 52 65 61 6c | 00 00 00 53 6d 61 6c 6c |y...Real|...Small|
|00002a80| 64 61 74 65 74 69 6d 65 | 00 00 00 53 6d 61 6c 6c |datetime|...Small|
|00002a90| 69 6e 74 00 00 00 53 6d | 61 6c 6c 6d 6f 6e 65 79 |int...Sm|allmoney|
|00002aa0| 00 00 00 54 65 78 74 00 | 00 00 54 69 6d 65 73 74 |...Text.|..Timest|
|00002ab0| 61 6d 70 00 00 00 54 69 | 6e 79 69 6e 74 00 00 00 |amp...Ti|nyint...|
|00002ac0| 56 61 72 62 69 6e 61 72 | 79 28 6e 29 00 00 00 56 |Varbinar|y(n)...V|
|00002ad0| 61 72 63 68 61 72 28 6e | 29 00 00 00 28 00 00 00 |archar(n|)...(...|
|00002ae0| 03 00 00 00 5d 84 00 00 | d9 85 00 00 25 00 00 00 |....]...|....%...|
|00002af0| 20 1a 80 06 00 80 00 00 | 18 00 52 98 80 04 00 82 | .......|..R.....|
|00002b00| ff 00 00 00 3a 00 00 00 | 09 00 00 00 b1 85 00 00 |....:...|........|
|00002b10| 13 86 00 00 31 00 00 00 | 02 fb 01 00 00 ff ff ff |....1...|........|
|00002b20| ff ff ff ff ff 08 00 00 | 00 13 86 00 00 34 87 00 |........|.....4..|
|00002b30| 00 fe 88 00 00 55 74 69 | 6c 69 74 69 65 73 33 00 |.....Uti|lities3.|
|00002b40| 00 00 0c 00 00 00 d9 85 | 00 00 46 86 00 00 27 00 |........|..F...'.|
|00002b50| 00 00 20 1e 80 18 00 80 | 00 00 1e 00 b8 98 42 98 |.. .....|......B.|
|00002b60| 80 03 00 82 ff 00 55 74 | 69 6c 69 74 69 65 73 00 |......Ut|ilities.|
|00002b70| 00 ee 00 00 00 c4 00 00 | 00 13 86 00 00 34 87 00 |........|.....4..|
|00002b80| 00 2a 00 00 00 20 22 80 | 89 01 00 80 00 00 18 00 |.*... ".|........|
|00002b90| 52 98 80 04 00 82 80 06 | 00 82 ff 00 54 68 69 73 |R.......|....This|
|00002ba0| 20 74 6f 70 69 63 20 6c | 69 73 74 73 20 74 68 65 | topic l|ists the|
|00002bb0| 20 53 51 4c 20 53 65 72 | 76 65 72 20 75 74 69 6c | SQL Ser|ver util|
|00002bc0| 69 74 79 20 70 72 6f 67 | 72 61 6d 73 2e 20 54 68 |ity prog|rams. Th|
|00002bd0| 65 72 65 20 61 72 65 20 | 75 74 69 6c 69 74 79 20 |ere are |utility |
|00002be0| 70 72 6f 67 72 61 6d 73 | 20 61 76 61 69 6c 61 62 |programs| availab|
|00002bf0| 6c 65 20 66 72 6f 6d 20 | 74 68 65 20 6f 70 65 72 |le from |the oper|
|00002c00| 61 74 69 6e 67 2d 73 79 | 73 74 65 6d 20 63 6f 6d |ating-sy|stem com|
|00002c10| 6d 61 6e 64 20 6c 69 6e | 65 20 61 6e 64 20 75 74 |mand lin|e and ut|
|00002c20| 69 6c 69 74 79 20 70 72 | 6f 67 72 61 6d 73 20 61 |ility pr|ograms a|
|00002c30| 76 61 69 6c 61 62 6c 65 | 20 66 72 6f 6d 20 74 68 |vailable| from th|
|00002c40| 65 20 6f 70 65 72 61 74 | 69 6e 67 2d 73 79 73 74 |e operat|ing-syst|
|00002c50| 65 6d 20 64 65 73 6b 74 | 6f 70 2e 00 00 00 00 40 |em deskt|op.....@|
|00002c60| 00 00 00 19 00 00 00 46 | 86 00 00 74 87 00 00 27 |.......F|...t...'|
|00002c70| 00 00 00 20 1e 80 32 00 | 80 00 00 1e 00 98 8c 52 |... ..2.|.......R|
|00002c80| 98 80 07 00 82 ff 00 43 | 6f 6d 6d 61 6e 64 2d 6c |.......C|ommand-l|
|00002c90| 69 6e 65 20 55 74 69 6c | 69 74 69 65 73 00 00 9d |ine Util|ities...|
|00002ca0| 00 00 00 46 00 00 00 34 | 87 00 00 11 88 00 00 57 |...F...4|.......W|
|00002cb0| 00 00 00 20 7e 80 8c 00 | 80 00 00 1a 00 90 52 98 |... ~...|......R.|
|00002cc0| e3 56 67 33 aa 80 04 00 | 89 82 e3 da 97 52 2a 89 |.Vg3....|.....R*.|
|00002cd0| 82 e3 7a ae 9f da 89 82 | e3 90 72 ee fc 89 82 e3 |..z.....|..r.....|
|00002ce0| 77 28 e9 5b 89 82 e3 cb | 31 dd a1 89 82 e3 c1 13 |w(.[....|1.......|
|00002cf0| 2f 61 89 82 82 ff 00 00 | 62 63 70 00 00 00 62 6c |/a......|bcp...bl|
|00002d00| 64 6d 61 73 74 72 00 00 | 00 63 6f 6e 73 6f 6c 65 |dmastr..|.console|
|00002d10| 00 00 00 69 73 71 6c 00 | 00 00 6d 61 6b 65 70 69 |...isql.|..makepi|
|00002d20| 70 65 00 00 00 72 65 61 | 64 70 69 70 65 00 00 00 |pe...rea|dpipe...|
|00002d30| 73 71 6c 73 65 72 76 72 | 00 00 00 00 3b 00 00 00 |sqlservr|....;...|
|00002d40| 14 00 00 00 74 87 00 00 | 4c 88 00 00 27 00 00 00 |....t...|L...'...|
|00002d50| 20 1e 80 28 00 80 00 00 | 1e 00 98 8c 52 98 80 07 | ..(....|....R...|
|00002d60| 00 82 ff 00 44 65 73 6b | 74 6f 70 20 55 74 69 6c |....Desk|top Util|
|00002d70| 69 74 69 65 73 00 00 b2 | 00 00 00 6a 00 00 00 11 |ities...|...j....|
|00002d80| 88 00 00 fe 88 00 00 48 | 00 00 00 20 60 80 d4 00 |.......H|... `...|
|00002d90| 80 00 00 1a 00 90 52 98 | e3 a8 b1 d9 58 80 04 00 |......R.|....X...|
|00002da0| 89 82 e3 b9 59 a5 13 89 | 82 e3 75 8b 9b cb 89 82 |....Y...|..u.....|
|00002db0| e3 1f 59 dd fb 89 82 e3 | ea 58 22 c1 89 82 ff 00 |..Y.....|.X".....|
|00002dc0| 00 43 6c 69 65 6e 74 20 | 43 6f 6e 66 69 67 75 72 |.Client |Configur|
|00002dd0| 61 74 69 6f 6e 20 55 74 | 69 6c 69 74 79 00 00 00 |ation Ut|ility...|
|00002de0| 49 53 51 4c 2f 77 00 00 | 00 53 51 4c 20 53 65 72 |ISQL/w..|.SQL Ser|
|00002df0| 76 69 63 65 20 4d 61 6e | 61 67 65 72 00 00 00 53 |vice Man|ager...S|
|00002e00| 51 4c 20 54 61 70 65 20 | 55 74 69 6c 69 74 79 00 |QL Tape |Utility.|
|00002e10| 00 00 53 51 4c 20 53 65 | 63 75 72 69 74 79 20 4d |..SQL Se|curity M|
|00002e20| 61 6e 61 67 65 72 00 00 | 00 3f 00 00 00 0e 00 00 |anager..|.?......|
|00002e30| 00 4c 88 00 00 3d 89 00 | 00 31 00 00 00 02 37 01 |.L...=..|.1....7.|
|00002e40| 00 00 ff ff ff ff ff ff | ff ff 09 00 00 00 3d 89 |........|......=.|
|00002e50| 00 00 ee 89 00 00 f4 8a | 00 00 41 6c 74 65 72 20 |........|..Alter |
|00002e60| 44 61 74 61 62 61 73 65 | 38 00 00 00 11 00 00 00 |Database|8.......|
|00002e70| fe 88 00 00 75 89 00 00 | 27 00 00 00 20 1e 80 22 |....u...|'... .."|
|00002e80| 00 80 00 00 1e 00 b8 98 | 42 98 80 03 00 82 ff 00 |........|B.......|
|00002e90| 41 4c 54 45 52 20 44 41 | 54 41 42 41 53 45 00 00 |ALTER DA|TABASE..|
|00002ea0| 50 00 00 00 2b 00 00 00 | 3d 89 00 00 c5 89 00 00 |P...+...|=.......|
|00002eb0| 25 00 00 00 20 1a 80 56 | 00 80 00 00 18 00 52 98 |%... ..V|......R.|
|00002ec0| 80 04 00 82 ff 00 49 6e | 63 72 65 61 73 65 73 20 |......In|creases |
|00002ed0| 73 70 61 63 65 20 61 6c | 6c 6f 63 61 74 65 64 20 |space al|located |
|00002ee0| 74 6f 20 61 20 64 61 74 | 61 62 61 73 65 2e 00 00 |to a dat|abase...|
|00002ef0| 29 00 00 00 03 00 00 00 | 75 89 00 00 ee 89 00 00 |).......|u.......|
|00002f00| 26 00 00 00 20 1c 80 06 | 00 80 00 00 1a 00 90 52 |&... ...|.......R|
|00002f10| 98 80 06 00 82 ff 00 00 | 00 30 00 00 00 09 00 00 |........|.0......|
|00002f20| 00 c5 89 00 00 1e 8a 00 | 00 27 00 00 00 20 1e 80 |........|.'... ..|
|00002f30| 12 00 80 00 00 1e 00 98 | 8c 52 98 80 07 00 82 ff |........|.R......|
|00002f40| 00 53 79 6e 74 61 78 00 | 00 d6 00 00 00 8e 00 00 |.Syntax.|........|
|00002f50| 00 ee 89 00 00 f4 8a 00 | 00 48 00 00 00 20 5e 80 |........|.H... ^.|
|00002f60| 1d 01 00 80 00 00 1a 00 | 90 52 98 80 04 00 80 09 |........|.R......|
|00002f70| 00 80 04 00 82 80 09 00 | 80 04 00 80 09 00 80 04 |........|........|
|00002f80| 00 82 80 09 00 80 04 00 | 80 09 00 80 04 00 82 82 |........|........|
|00002f90| ff 00 41 4c 54 45 52 20 | 44 41 54 41 42 41 53 45 |..ALTER |DATABASE|
|00002fa0| 20 00 64 61 74 61 62 61 | 73 65 5f 6e 61 6d 65 00 | .databa|se_name.|
|00002fb0| 00 5b 4f 4e 20 44 45 46 | 41 55 4c 54 20 7c 20 7b |.[ON DEF|AULT | {|
|00002fc0| 00 64 61 74 61 62 61 73 | 65 5f 64 65 76 69 63 65 |.databas|e_device|
|00002fd0| 00 7d 20 5b 3d 20 00 73 | 69 7a 65 5f 69 6e 5f 6d |.} [= .s|ize_in_m|
|00002fe0| 65 67 61 62 79 74 65 73 | 00 5d 00 5b 2c 20 00 64 |egabytes|.].[, .d|
|00002ff0| 61 74 61 62 61 73 65 5f | 64 65 76 69 63 65 00 20 |atabase_|device. |
|00003000| 5b 3d 20 00 73 69 7a 65 | 5f 69 6e 5f 6d 65 67 61 |[= .size|_in_mega|
|00003010| 62 79 74 65 73 00 5d 5d | 2e 2e 2e 5d 00 00 00 3c |bytes.]]|...]...<|
|00003020| 00 00 00 0b 00 00 00 1e | 8a 00 00 30 8b 00 00 31 |........|...0...1|
|00003030| 00 00 00 02 2d 01 00 00 | ff ff ff ff ff ff ff ff |....-...|........|
|00003040| 0a 00 00 00 30 8b 00 00 | d8 8b 00 00 d4 8c 00 00 |....0...|........|
|00003050| 41 6c 74 65 72 20 54 61 | 62 6c 65 35 00 00 00 0e |Alter Ta|ble5....|
|00003060| 00 00 00 f4 8a 00 00 65 | 8b 00 00 27 00 00 00 20 |.......e|...'... |
|00003070| 1e 80 1c 00 80 00 00 1e | 00 b8 98 42 98 80 03 00 |........|...B....|
|00003080| 82 ff 00 41 4c 54 45 52 | 20 54 41 42 4c 45 00 00 |...ALTER| TABLE..|
|00003090| 4a 00 00 00 25 00 00 00 | 30 8b 00 00 af 8b 00 00 |J...%...|0.......|
|000030a0| 25 00 00 00 20 1a 80 4a | 00 80 00 00 18 00 52 98 |%... ..J|......R.|
|000030b0| 80 04 00 82 ff 00 41 64 | 64 73 20 63 6f 6c 75 6d |......Ad|ds colum|
|000030c0| 6e 73 20 74 6f 20 61 6e | 20 65 78 69 73 74 69 6e |ns to an| existin|
|000030d0| 67 20 74 61 62 6c 65 2e | 00 00 29 00 00 00 03 00 |g table.|..).....|
|000030e0| 00 00 65 8b 00 00 d8 8b | 00 00 26 00 00 00 20 1c |..e.....|..&... .|
|000030f0| 80 06 00 80 00 00 1a 00 | 90 52 98 80 06 00 82 ff |........|.R......|
|00003100| 00 00 00 30 00 00 00 09 | 00 00 00 af 8b 00 00 08 |...0....|........|
|00003110| 8c 00 00 27 00 00 00 20 | 1e 80 12 00 80 00 00 1e |...'... |........|
|00003120| 00 98 8c 52 98 80 07 00 | 82 ff 00 53 79 6e 74 61 |...R....|...Synta|
|00003130| 78 00 00 cc 00 00 00 7a | 00 00 00 d8 8b 00 00 d4 |x......z|........|
|00003140| 8c 00 00 52 00 00 00 20 | 74 80 f4 00 80 00 00 1a |...R... |t.......|
|00003150| 00 90 52 98 80 04 00 80 | 09 00 80 04 00 80 09 00 |..R.....|........|
|00003160| 80 04 00 80 09 00 80 04 | 00 82 80 09 00 80 04 00 |........|........|
|00003170| 80 09 00 80 04 00 80 09 | 00 80 04 00 80 09 00 80 |........|........|
|00003180| 04 00 82 82 ff 00 41 4c | 54 45 52 20 54 41 42 4c |......AL|TER TABL|
|00003190| 45 20 5b 5b 00 64 61 74 | 61 62 61 73 65 2e 00 5d |E [[.dat|abase..]|
|000031a0| 00 6f 77 6e 65 72 2e 00 | 5d 00 74 61 62 6c 65 5f |.owner..|].table_|
|000031b0| 6e 61 6d 65 00 00 41 44 | 44 20 00 63 6f 6c 75 6d |name..AD|D .colum|
|000031c0| 6e 5f 6e 61 6d 65 00 20 | 00 64 61 74 61 74 79 70 |n_name. |.datatyp|
|000031d0| 65 00 20 4e 55 4c 4c 20 | 5b 2c 20 00 63 6f 6c 75 |e. NULL |[, .colu|
|000031e0| 6d 6e 5f 6e 61 6d 65 00 | 20 00 64 61 74 61 74 79 |mn_name.| .dataty|
|000031f0| 70 65 00 20 4e 55 4c 4c | 2e 2e 2e 5d 00 00 00 3c |pe. NULL|...]...<|
|00003200| 00 00 00 0b 00 00 00 08 | 8c 00 00 10 8d 00 00 31 |........|.......1|
|00003210| 00 00 00 02 af 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|00003220| 0b 00 00 00 10 8d 00 00 | 19 8e 00 00 97 8e 00 00 |........|........|
|00003230| 42 65 67 69 6e 2e 2e 2e | 45 6e 64 35 00 00 00 0e |Begin...|End5....|
|00003240| 00 00 00 d4 8c 00 00 45 | 8d 00 00 27 00 00 00 20 |.......E|...'... |
|00003250| 1e 80 1c 00 80 00 00 1e | 00 b8 98 42 98 80 03 00 |........|...B....|
|00003260| 82 ff 00 42 45 47 49 4e | 2e 2e 2e 45 4e 44 00 00 |...BEGIN|...END..|
|00003270| ab 00 00 00 85 00 00 00 | 10 8d 00 00 f0 8d 00 00 |........|........|
|00003280| 26 00 00 00 20 1a 80 0b | 01 00 80 00 00 18 00 52 |&... ...|.......R|
|00003290| 98 80 04 00 82 ff 00 45 | 6e 63 6c 6f 73 65 20 61 |.......E|nclose a|
|000032a0| 20 67 72 6f 75 70 20 6f | 66 20 53 51 4c 20 73 74 | group o|f SQL st|
|000032b0| 61 74 65 6d 65 6e 74 73 | 20 73 6f 20 74 68 61 74 |atements| so that|
|000032c0| 20 63 6f 6e 74 72 6f 6c | 2d 6f 66 2d 66 6c 6f 77 | control|-of-flow|
|000032d0| 20 6c 61 6e 67 75 61 67 | 65 2c 20 73 75 63 68 20 | languag|e, such |
|000032e0| 61 73 20 49 46 2e 2e 2e | 45 4c 53 45 2c 20 61 66 |as IF...|ELSE, af|
|000032f0| 66 65 63 74 73 20 74 68 | 65 20 70 65 72 66 6f 72 |fects th|e perfor|
|00003300| 6d 61 6e 63 65 20 6f 66 | 20 74 68 65 20 77 68 6f |mance of| the who|
|00003310| 6c 65 20 67 72 6f 75 70 | 2e 00 00 29 00 00 00 03 |le group|...)....|
|00003320| 00 00 00 45 8d 00 00 19 | 8e 00 00 26 00 00 00 20 |...E....|...&... |
|00003330| 1c 80 06 00 80 00 00 1a | 00 90 52 98 80 06 00 82 |........|..R.....|
|00003340| ff 00 00 00 30 00 00 00 | 09 00 00 00 f0 8d 00 00 |....0...|........|
|00003350| 49 8e 00 00 27 00 00 00 | 20 1e 80 12 00 80 00 00 |I...'...| .......|
|00003360| 1e 00 98 8c 52 98 80 07 | 00 82 ff 00 53 79 6e 74 |....R...|....Synt|
|00003370| 61 78 00 00 4e 00 00 00 | 1f 00 00 00 19 8e 00 00 |ax..N...|........|
|00003380| 97 8e 00 00 2f 00 00 00 | 20 2e 80 3e 00 80 00 00 |..../...| ..>....|
|00003390| 1a 00 90 52 98 80 04 00 | 82 80 09 00 80 04 00 82 |...R....|........|
|000033a0| 82 82 ff 00 42 45 47 49 | 4e 00 00 73 74 61 74 65 |....BEGI|N..state|
|000033b0| 6d 65 6e 74 5f 62 6c 6f | 63 6b 00 00 45 4e 44 00 |ment_blo|ck..END.|
|000033c0| 00 00 42 00 00 00 11 00 | 00 00 49 8e 00 00 d9 8e |..B.....|..I.....|
|000033d0| 00 00 31 00 00 00 02 b8 | 00 00 00 ff ff ff ff ff |..1.....|........|
|000033e0| ff ff ff 0c 00 00 00 d9 | 8e 00 00 9e 8f 00 00 31 |........|.......1|
|000033f0| c0 00 00 42 65 67 69 6e | 20 54 72 61 6e 73 61 63 |...Begin| Transac|
|00003400| 74 69 6f 6e 3b 00 00 00 | 14 00 00 00 97 8e 00 00 |tion;...|........|
|00003410| 14 8f 00 00 27 00 00 00 | 20 1e 80 28 00 80 00 00 |....'...| ..(....|
|00003420| 1e 00 b8 98 42 98 80 03 | 00 82 ff 00 42 45 47 49 |....B...|....BEGI|
|00003430| 4e 20 54 52 41 4e 53 41 | 43 54 49 4f 4e 00 00 61 |N TRANSA|CTION..a|
|00003440| 00 00 00 3c 00 00 00 d9 | 8e 00 00 75 8f 00 00 25 |...<....|...u...%|
|00003450| 00 00 00 20 1a 80 78 00 | 80 00 00 18 00 52 98 80 |... ..x.|.....R..|
|00003460| 04 00 82 ff 00 4d 61 72 | 6b 73 20 74 68 65 20 73 |.....Mar|ks the s|
|00003470| 74 61 72 74 69 6e 67 20 | 70 6f 69 6e 74 20 6f 66 |tarting |point of|
|00003480| 20 61 20 75 73 65 72 2d | 73 70 65 63 69 66 69 65 | a user-|specifie|
|00003490| 64 20 74 72 61 6e 73 61 | 63 74 69 6f 6e 2e 00 00 |d transa|ction...|
|000034a0| 29 00 00 00 03 00 00 00 | 14 8f 00 00 9e 8f 00 00 |).......|........|
|000034b0| 26 00 00 00 20 1c 80 06 | 00 80 00 00 1a 00 90 52 |&... ...|.......R|
|000034c0| 98 80 06 00 82 ff 00 00 | 00 30 00 00 00 09 00 00 |........|.0......|
|000034d0| 00 75 8f 00 00 ce 8f 00 | 00 27 00 00 00 20 1e 80 |.u......|.'... ..|
|000034e0| 12 00 80 00 00 1e 00 98 | 8c 52 98 80 07 00 82 ff |........|.R......|
|000034f0| 00 53 79 6e 74 61 78 00 | 00 57 00 00 00 2a 00 00 |.Syntax.|.W...*..|
|00003500| 00 9e 8f 00 00 31 c0 00 | 00 2d 00 00 00 20 2a 80 |.....1..|.-... *.|
|00003510| 54 00 80 00 00 1a 00 90 | 52 98 80 04 00 80 09 00 |T.......|R.......|
|00003520| 80 04 00 82 82 ff 00 42 | 45 47 49 ce 8f 00 00 31 |.......B|EGI....1|
|00003530| c0 00 00 97 8e 00 00 4e | 20 54 52 41 4e 73 61 63 |.......N| TRANsac|
|00003540| 74 69 6f 6e 20 5b 00 74 | 72 61 6e 73 61 63 74 69 |tion [.t|ransacti|
|00003550| 6f 6e 5f 6e 61 6d 65 00 | 5d 00 00 00 36 00 00 00 |on_name.|]...6...|
|00003560| 05 00 00 00 ce 8f 00 00 | 67 c0 00 00 31 00 00 00 |........|g...1...|
|00003570| 02 ec 00 00 00 ff ff ff | ff ff ff ff ff 0d 00 00 |........|........|
|00003580| 00 67 c0 00 00 18 c1 00 | 00 d3 c1 00 00 42 72 65 |.g......|.....Bre|
|00003590| 61 6b 2f 00 00 00 08 00 | 00 00 31 c0 00 00 96 c0 |ak/.....|..1.....|
|000035a0| 00 00 27 00 00 00 20 1e | 80 10 00 80 00 00 1e 00 |..'... .|........|
|000035b0| b8 98 42 98 80 03 00 82 | ff 00 42 52 45 41 4b 00 |..B.....|..BREAK.|
|000035c0| 00 59 00 00 00 34 00 00 | 00 67 c0 00 00 ef c0 00 |.Y...4..|.g......|
|000035d0| 00 25 00 00 00 20 1a 80 | 68 00 80 00 00 18 00 52 |.%... ..|h......R|
|000035e0| 98 80 04 00 82 ff 00 43 | 6f 6e 74 72 6f 6c 73 20 |.......C|ontrols |
|000035f0| 6f 70 65 72 61 74 69 6f | 6e 20 6f 66 20 73 74 61 |operatio|n of sta|
|00003600| 74 65 6d 65 6e 74 73 20 | 69 6e 20 61 20 57 48 49 |tements |in a WHI|
|00003610| 4c 45 20 6c 6f 6f 70 2e | 00 00 29 00 00 00 03 00 |LE loop.|..).....|
|00003620| 00 00 96 c0 00 00 18 c1 | 00 00 26 00 00 00 20 1c |........|..&... .|
|00003630| 80 06 00 80 00 00 1a 00 | 90 52 98 80 06 00 82 ff |........|.R......|
|00003640| 00 00 00 30 00 00 00 09 | 00 00 00 ef c0 00 00 48 |...0....|.......H|
|00003650| c1 00 00 27 00 00 00 20 | 1e 80 12 00 80 00 00 1e |...'... |........|
|00003660| 00 98 8c 52 98 80 07 00 | 82 ff 00 53 79 6e 74 61 |...R....|...Synta|
|00003670| 78 00 00 8b 00 00 00 4d | 00 00 00 18 c1 00 00 d3 |x......M|........|
|00003680| c1 00 00 3e 00 00 00 20 | 4c 80 9a 00 80 00 00 1a |...>... |L.......|
|00003690| 00 90 52 98 80 04 00 82 | 80 09 00 80 04 00 82 80 |..R.....|........|
|000036a0| 09 00 80 04 00 82 82 80 | 09 00 80 04 00 82 82 82 |........|........|
|000036b0| ff 00 57 48 49 4c 45 00 | 00 42 6f 6f 6c 65 61 6e |..WHILE.|.Boolean|
|000036c0| 5f 65 78 70 72 65 73 73 | 69 6f 6e 00 00 00 73 71 |_express|ion...sq|
|000036d0| 6c 5f 73 74 61 74 65 6d | 65 6e 74 00 00 42 52 45 |l_statem|ent..BRE|
|000036e0| 41 4b 00 00 73 71 6c 5f | 73 74 61 74 65 6d 65 6e |AK..sql_|statemen|
|000036f0| 74 00 00 43 4f 4e 54 49 | 4e 55 45 00 00 00 3c 00 |t..CONTI|NUE...<.|
|00003700| 00 00 0b 00 00 00 48 c1 | 00 00 0f c2 00 00 31 00 |......H.|......1.|
|00003710| 00 00 02 96 00 00 00 ff | ff ff ff ff ff ff ff 0e |........|........|
|00003720| 00 00 00 0f c2 00 00 45 | c3 00 00 aa c3 00 00 42 |.......E|.......B|
|00003730| 72 6f 77 73 65 20 4d 6f | 64 65 35 00 00 00 0e 00 |rowse Mo|de5.....|
|00003740| 00 00 d3 c1 00 00 44 c2 | 00 00 27 00 00 00 20 1e |......D.|..'... .|
|00003750| 80 1c 00 80 00 00 1e 00 | b8 98 42 98 80 03 00 82 |........|..B.....|
|00003760| ff 00 42 72 6f 77 73 65 | 20 4d 6f 64 65 00 00 d8 |..Browse| Mode...|
|00003770| 00 00 00 b2 00 00 00 0f | c2 00 00 1c c3 00 00 26 |........|.......&|
|00003780| 00 00 00 20 1a 80 65 01 | 00 80 00 00 18 00 52 98 |... ..e.|......R.|
|00003790| 80 04 00 82 ff 00 53 75 | 70 70 6f 72 74 73 20 74 |......Su|pports t|
|000037a0| 68 65 20 61 62 69 6c 69 | 74 79 20 74 6f 20 70 65 |he abili|ty to pe|
|000037b0| 72 66 6f 72 6d 20 75 70 | 64 61 74 65 73 20 77 68 |rform up|dates wh|
|000037c0| 69 6c 65 20 76 69 65 77 | 69 6e 67 20 64 61 74 61 |ile view|ing data|
|000037d0| 2e 20 42 72 6f 77 73 65 | 20 6d 6f 64 65 20 69 73 |. Browse| mode is|
|000037e0| 20 75 73 65 64 20 69 6e | 20 61 6e 20 61 70 70 6c | used in| an appl|
|000037f0| 69 63 61 74 69 6f 6e 20 | 70 72 6f 67 72 61 6d 20 |ication |program |
|00003800| 77 69 74 68 20 44 42 2d | 4c 69 62 72 61 72 79 2e |with DB-|Library.|
|00003810| 20 54 68 65 20 46 4f 52 | 20 42 52 4f 57 53 45 20 | The FOR| BROWSE |
|00003820| 63 6c 61 75 73 65 20 69 | 73 20 75 73 65 64 20 69 |clause i|s used i|
|00003830| 6e 20 61 20 53 45 4c 45 | 43 54 20 73 74 61 74 65 |n a SELE|CT state|
|00003840| 6d 65 6e 74 2e 00 00 29 | 00 00 00 03 00 00 00 44 |ment...)|.......D|
|00003850| c2 00 00 45 c3 00 00 26 | 00 00 00 20 1c 80 06 00 |...E...&|... ....|
|00003860| 80 00 00 1a 00 90 52 98 | 80 06 00 82 ff 00 00 00 |......R.|........|
|00003870| 30 00 00 00 09 00 00 00 | 1c c3 00 00 75 c3 00 00 |0.......|....u...|
|00003880| 27 00 00 00 20 1e 80 12 | 00 80 00 00 1e 00 98 8c |'... ...|........|
|00003890| 52 98 80 07 00 82 ff 00 | 53 79 6e 74 61 78 00 00 |R.......|Syntax..|
|000038a0| 35 00 00 00 0e 00 00 00 | 45 c3 00 00 aa c3 00 00 |5.......|E.......|
|000038b0| 27 00 00 00 20 1e 80 1c | 00 80 00 00 1a 00 90 52 |'... ...|.......R|
|000038c0| 98 80 04 00 82 82 ff 00 | 46 4f 52 20 42 52 4f 57 |........|FOR BROW|
|000038d0| 53 45 00 00 00 3b 00 00 | 00 0a 00 00 00 75 c3 00 |SE...;..|.....u..|
|000038e0| 00 e5 c3 00 00 31 00 00 | 00 02 96 00 00 00 ff ff |.....1..|........|
|000038f0| ff ff ff ff ff ff 0f 00 | 00 00 e5 c3 00 00 af c4 |........|........|
|00003900| 00 00 14 c5 00 00 43 68 | 65 63 6b 70 6f 69 6e 74 |......Ch|eckpoint|
|00003910| 34 00 00 00 0d 00 00 00 | aa c3 00 00 19 c4 00 00 |4.......|........|
|00003920| 27 00 00 00 20 1e 80 1a | 00 80 00 00 1e 00 b8 98 |'... ...|........|
|00003930| 42 98 80 03 00 82 ff 00 | 43 48 45 43 4b 50 4f 49 |B.......|CHECKPOI|
|00003940| 4e 54 00 00 6d 00 00 00 | 48 00 00 00 e5 c3 00 00 |NT..m...|H.......|
|00003950| 86 c4 00 00 25 00 00 00 | 20 1a 80 90 00 80 00 00 |....%...| .......|
|00003960| 18 00 52 98 80 04 00 82 | ff 00 46 6f 72 63 65 73 |..R.....|..Forces|
|00003970| 20 61 6c 6c 20 64 69 72 | 74 79 20 70 61 67 65 73 | all dir|ty pages|
|00003980| 20 69 6e 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 | in the |current |
|00003990| 64 61 74 61 62 61 73 65 | 20 74 6f 20 62 65 20 77 |database| to be w|
|000039a0| 72 69 74 74 65 6e 20 74 | 6f 20 64 69 73 6b 2e 00 |ritten t|o disk..|
|000039b0| 00 29 00 00 00 03 00 00 | 00 19 c4 00 00 af c4 00 |.)......|........|
|000039c0| 00 26 00 00 00 20 1c 80 | 06 00 80 00 00 1a 00 90 |.&... ..|........|
|000039d0| 52 98 80 06 00 82 ff 00 | 00 00 30 00 00 00 09 00 |R.......|..0.....|
|000039e0| 00 00 86 c4 00 00 df c4 | 00 00 27 00 00 00 20 1e |........|..'... .|
|000039f0| 80 12 00 80 00 00 1e 00 | 98 8c 52 98 80 07 00 82 |........|..R.....|
|00003a00| ff 00 53 79 6e 74 61 78 | 00 00 35 00 00 00 0e 00 |..Syntax|..5.....|
|00003a10| 00 00 af c4 00 00 14 c5 | 00 00 27 00 00 00 20 1e |........|..'... .|
|00003a20| 80 1c 00 80 00 00 1a 00 | 90 52 98 80 04 00 82 82 |........|.R......|
|00003a30| ff 00 43 48 45 43 4b 50 | 4f 49 4e 54 00 00 00 43 |..CHECKP|OINT...C|
|00003a40| 00 00 00 12 00 00 00 df | c4 00 00 57 c5 00 00 31 |........|...W...1|
|00003a50| 00 00 00 02 b9 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|00003a60| 10 00 00 00 57 c5 00 00 | 10 c6 00 00 98 c6 00 00 |....W...|........|
|00003a70| 43 6f 6d 6d 69 74 20 54 | 72 61 6e 73 61 63 74 69 |Commit T|ransacti|
|00003a80| 6f 6e 3c 00 00 00 15 00 | 00 00 14 c5 00 00 93 c5 |on<.....|........|
|00003a90| 00 00 27 00 00 00 20 1e | 80 2a 00 80 00 00 1e 00 |..'... .|.*......|
|00003aa0| b8 98 42 98 80 03 00 82 | ff 00 43 4f 4d 4d 49 54 |..B.....|..COMMIT|
|00003ab0| 20 54 52 41 4e 53 41 43 | 54 49 4f 4e 00 00 54 00 | TRANSAC|TION..T.|
|00003ac0| 00 00 2f 00 00 00 57 c5 | 00 00 e7 c5 00 00 25 00 |../...W.|......%.|
|00003ad0| 00 00 20 1a 80 5e 00 80 | 00 00 18 00 52 98 80 04 |.. ..^..|....R...|
|00003ae0| 00 82 ff 00 4d 61 72 6b | 73 20 74 68 65 20 65 6e |....Mark|s the en|
|00003af0| 64 20 6f 66 20 61 20 75 | 73 65 72 2d 64 65 66 69 |d of a u|ser-defi|
|00003b00| 6e 65 64 20 74 72 61 6e | 73 61 63 74 69 6f 6e 2e |ned tran|saction.|
|00003b10| 00 00 29 00 00 00 03 00 | 00 00 93 c5 00 00 10 c6 |..).....|........|
|00003b20| 00 00 26 00 00 00 20 1c | 80 06 00 80 00 00 1a 00 |..&... .|........|
|00003b30| 90 52 98 80 06 00 82 ff | 00 00 00 30 00 00 00 09 |.R......|...0....|
|00003b40| 00 00 00 e7 c5 00 00 40 | c6 00 00 27 00 00 00 20 |.......@|...'... |
|00003b50| 1e 80 12 00 80 00 00 1e | 00 98 8c 52 98 80 07 00 |........|...R....|
|00003b60| 82 ff 00 53 79 6e 74 61 | 78 00 00 58 00 00 00 2b |...Synta|x..X...+|
|00003b70| 00 00 00 10 c6 00 00 98 | c6 00 00 2d 00 00 00 20 |........|...-... |
|00003b80| 2a 80 56 00 80 00 00 1a | 00 90 52 98 80 04 00 80 |*.V.....|..R.....|
|00003b90| 09 00 80 04 00 82 82 ff | 00 43 4f 4d 4d 49 54 20 |........|.COMMIT |
|00003ba0| 54 52 41 4e 73 61 63 74 | 69 6f 6e 20 5b 00 74 72 |TRANsact|ion [.tr|
|00003bb0| 61 6e 73 61 63 74 69 6f | 6e 5f 6e 61 6d 65 00 5d |ansactio|n_name.]|
|00003bc0| 00 00 00 3f 00 00 00 0e | 00 00 00 40 c6 00 00 d7 |...?....|...@....|
|00003bd0| c6 00 00 31 00 00 00 02 | 02 01 00 00 ff ff ff ff |...1....|........|
|00003be0| ff ff ff ff 11 00 00 00 | d7 c6 00 00 bd c7 00 00 |........|........|
|00003bf0| 8e c8 00 00 43 4f 4d 50 | 55 54 45 20 43 6c 61 75 |....COMP|UTE Clau|
|00003c00| 73 65 38 00 00 00 11 00 | 00 00 98 c6 00 00 0f c7 |se8.....|........|
|00003c10| 00 00 27 00 00 00 20 1e | 80 22 00 80 00 00 1e 00 |..'... .|."......|
|00003c20| b8 98 42 98 80 03 00 82 | ff 00 43 4f 4d 50 55 54 |..B.....|..COMPUT|
|00003c30| 45 20 43 6c 61 75 73 65 | 00 00 ae 00 00 00 83 00 |E Clause|........|
|00003c40| 00 00 d7 c6 00 00 bd c7 | 00 00 2b 00 00 00 20 24 |........|..+... $|
|00003c50| 80 07 01 00 80 00 00 1a | 00 90 52 98 80 04 00 82 |........|..R.....|
|00003c60| 80 06 00 82 ff 00 47 65 | 6e 65 72 61 74 65 73 20 |......Ge|nerates |
|00003c70| 73 75 6d 6d 61 72 79 20 | 76 61 6c 75 65 73 20 69 |summary |values i|
|00003c80| 6e 20 61 20 53 45 4c 45 | 43 54 20 73 74 61 74 65 |n a SELE|CT state|
|00003c90| 6d 65 6e 74 20 77 69 74 | 68 20 72 6f 77 20 61 67 |ment wit|h row ag|
|00003ca0| 67 72 65 67 61 74 65 20 | 66 75 6e 63 74 69 6f 6e |gregate |function|
|00003cb0| 73 2e 20 54 68 65 20 43 | 4f 4d 50 55 54 45 20 43 |s. The C|OMPUTE C|
|00003cc0| 6c 61 75 73 65 20 69 73 | 20 75 73 65 64 20 69 6e |lause is| used in|
|00003cd0| 20 61 20 53 45 4c 45 43 | 54 20 73 74 61 74 65 6d | a SELEC|T statem|
|00003ce0| 65 6e 74 2e 00 00 00 00 | 30 00 00 00 09 00 00 00 |ent.....|0.......|
|00003cf0| 0f c7 00 00 ed c7 00 00 | 27 00 00 00 20 1e 80 12 |........|'... ...|
|00003d00| 00 80 00 00 1e 00 98 8c | 52 98 80 07 00 82 ff 00 |........|R.......|
|00003d10| 53 79 6e 74 61 78 00 00 | a1 00 00 00 6c 00 00 00 |Syntax..|....l...|
|00003d20| bd c7 00 00 8e c8 00 00 | 35 00 00 00 20 3a 80 d8 |........|5... :..|
|00003d30| 00 80 00 00 1a 00 90 52 | 98 80 04 00 80 09 00 80 |.......R|........|
|00003d40| 04 00 82 80 09 00 80 04 | 00 82 82 82 ff 00 43 4f |........|......CO|
|00003d50| 4d 50 55 54 45 00 72 6f | 77 5f 61 67 67 72 65 67 |MPUTE.ro|w_aggreg|
|00003d60| 61 74 65 00 28 63 6f 6c | 75 6d 6e 5f 6e 61 6d 65 |ate.(col|umn_name|
|00003d70| 29 00 5b 2c 00 72 6f 77 | 5f 61 67 67 72 65 67 61 |).[,.row|_aggrega|
|00003d80| 74 65 00 28 63 6f 6c 75 | 6d 6e 5f 6e 61 6d 65 29 |te.(colu|mn_name)|
|00003d90| 2e 2e 2e 5d 00 5b 42 59 | 20 63 6f 6c 75 6d 6e 5f |...].[BY| column_|
|00003da0| 6e 61 6d 65 5b 2c 63 6f | 6c 75 6d 6e 5f 6e 61 6d |name[,co|lumn_nam|
|00003db0| 65 5d 2e 2e 2e 5d 00 00 | 00 39 00 00 00 08 00 00 |e]...]..|.9......|
|00003dc0| 00 ed c7 00 00 c7 c8 00 | 00 31 00 00 00 02 ec 00 |........|.1......|
|00003dd0| 00 00 ff ff ff ff ff ff | ff ff 12 00 00 00 c7 c8 |........|........|
|00003de0| 00 00 6b c9 00 00 26 ca | 00 00 43 6f 6e 74 69 6e |..k...&.|..Contin|
|00003df0| 75 65 32 00 00 00 0b 00 | 00 00 8e c8 00 00 f9 c8 |ue2.....|........|
|00003e00| 00 00 27 00 00 00 20 1e | 80 16 00 80 00 00 1e 00 |..'... .|........|
|00003e10| b8 98 42 98 80 03 00 82 | ff 00 43 4f 4e 54 49 4e |..B.....|..CONTIN|
|00003e20| 55 45 00 00 49 00 00 00 | 24 00 00 00 c7 c8 00 00 |UE..I...|$.......|
|00003e30| 42 c9 00 00 25 00 00 00 | 20 1a 80 48 00 80 00 00 |B...%...| ..H....|
|00003e40| 18 00 52 98 80 04 00 82 | ff 00 43 61 75 73 65 73 |..R.....|..Causes|
|00003e50| 20 74 68 65 20 57 48 49 | 4c 45 20 6c 6f 6f 70 20 | the WHI|LE loop |
|00003e60| 74 6f 20 72 65 73 74 61 | 72 74 2e 00 00 29 00 00 |to resta|rt...)..|
|00003e70| 00 03 00 00 00 f9 c8 00 | 00 6b c9 00 00 26 00 00 |........|.k...&..|
|00003e80| 00 20 1c 80 06 00 80 00 | 00 1a 00 90 52 98 80 06 |. ......|....R...|
|00003e90| 00 82 ff 00 00 00 30 00 | 00 00 09 00 00 00 42 c9 |......0.|......B.|
|00003ea0| 00 00 9b c9 00 00 27 00 | 00 00 20 1e 80 12 00 80 |......'.|.. .....|
|00003eb0| 00 00 1e 00 98 8c 52 98 | 80 07 00 82 ff 00 53 79 |......R.|......Sy|
|00003ec0| 6e 74 61 78 00 00 8b 00 | 00 00 4d 00 00 00 6b c9 |ntax....|..M...k.|
|00003ed0| 00 00 26 ca 00 00 3e 00 | 00 00 20 4c 80 9a 00 80 |..&...>.|.. L....|
|00003ee0| 00 00 1a 00 90 52 98 80 | 04 00 82 80 09 00 80 04 |.....R..|........|
|00003ef0| 00 82 80 09 00 80 04 00 | 82 82 80 09 00 80 04 00 |........|........|
|00003f00| 82 82 82 ff 00 57 48 49 | 4c 45 00 00 42 6f 6f 6c |.....WHI|LE..Bool|
|00003f10| 65 61 6e 5f 65 78 70 72 | 65 73 73 69 6f 6e 00 00 |ean_expr|ession..|
|00003f20| 00 73 71 6c 5f 73 74 61 | 74 65 6d 65 6e 74 00 00 |.sql_sta|tement..|
|00003f30| 42 52 45 41 4b 00 00 73 | 71 6c 5f 73 74 61 74 65 |BREAK..s|ql_state|
|00003f40| 6d 65 6e 74 00 00 43 4f | 4e 54 49 4e 55 45 00 00 |ment..CO|NTINUE..|
|00003f50| 00 38 00 00 00 07 00 00 | 00 9b c9 00 00 5e ca 00 |.8......|.....^..|
|00003f60| 00 31 00 00 00 02 dd 00 | 00 00 ff ff ff ff ff ff |.1......|........|
|00003f70| ff ff 13 00 00 00 5e ca | 00 00 49 cb 00 00 f5 cb |......^.|..I.....|
|00003f80| 00 00 43 4f 4e 56 45 52 | 54 31 00 00 00 0a 00 00 |..CONVER|T1......|
|00003f90| 00 26 ca 00 00 8f ca 00 | 00 27 00 00 00 20 1e 80 |.&......|.'... ..|
|00003fa0| 14 00 80 00 00 1e 00 b8 | 98 42 98 80 03 00 82 ff |........|.B......|
|00003fb0| 00 43 4f 4e 56 45 52 54 | 00 00 91 00 00 00 6c 00 |.CONVERT|......l.|
|00003fc0| 00 00 5e ca 00 00 20 cb | 00 00 25 00 00 00 20 1a |..^... .|..%... .|
|00003fd0| 80 d8 00 80 00 00 18 00 | 52 98 80 04 00 82 ff 00 |........|R.......|
|00003fe0| 43 6f 6e 76 65 72 74 73 | 20 65 78 70 72 65 73 73 |Converts| express|
|00003ff0| 69 6f 6e 73 20 6f 66 20 | 6f 6e 65 20 64 61 74 61 |ions of |one data|
|00004000| 74 79 70 65 20 74 6f 20 | 61 6e 6f 74 68 65 72 20 |type to |another |
|00004010| 64 61 74 61 74 79 70 65 | 2e 20 41 6c 73 6f 20 6f |datatype|. Also o|
|00004020| 62 74 61 69 6e 73 20 61 | 20 76 61 72 69 65 74 79 |btains a| variety|
|00004030| 20 6f 66 20 73 70 65 63 | 69 61 6c 20 64 61 74 65 | of spec|ial date|
|00004040| 20 66 6f 72 6d 61 74 73 | 2e 00 00 29 00 00 00 03 | formats|...)....|
|00004050| 00 00 00 8f ca 00 00 49 | cb 00 00 26 00 00 00 20 |.......I|...&... |
|00004060| 1c 80 06 00 80 00 00 1a | 00 90 52 98 80 06 00 82 |........|..R.....|
|00004070| ff 00 00 00 30 00 00 00 | 09 00 00 00 20 cb 00 00 |....0...|.... ...|
|00004080| 79 cb 00 00 27 00 00 00 | 20 1e 80 12 00 80 00 00 |y...'...| .......|
|00004090| 1e 00 98 8c 52 98 80 07 | 00 82 ff 00 53 79 6e 74 |....R...|....Synt|
|000040a0| 61 78 00 00 7c 00 00 00 | 3d 00 00 00 49 cb 00 00 |ax..|...|=...I...|
|000040b0| f5 cb 00 00 3f 00 00 00 | 20 4e 80 7a 00 80 00 00 |....?...| N.z....|
|000040c0| 1a 00 90 52 98 80 04 00 | 80 09 00 80 04 00 80 09 |...R....|........|
|000040d0| 00 80 04 00 80 09 00 80 | 04 00 80 09 00 80 04 00 |........|........|
|000040e0| 82 82 ff 00 43 4f 4e 56 | 45 52 54 28 00 64 61 74 |....CONV|ERT(.dat|
|000040f0| 61 74 79 70 65 00 5b 28 | 00 6c 65 6e 67 74 68 00 |atype.[(|.length.|
|00004100| 29 5d 2c 20 00 65 78 70 | 72 65 73 73 69 6f 6e 00 |)], .exp|ression.|
|00004110| 20 5b 2c 20 00 73 74 79 | 6c 65 00 5d 29 00 00 00 | [, .sty|le.])...|
|00004120| 40 00 00 00 0f 00 00 00 | 79 cb 00 00 35 cc 00 00 |@.......|y...5...|
|00004130| 31 00 00 00 02 a7 01 00 | 00 ff ff ff ff ff ff ff |1.......|........|
|00004140| ff 14 00 00 00 35 cc 00 | 00 d2 cc 00 00 48 ce 00 |.....5..|.....H..|
|00004150| 00 43 72 65 61 74 65 20 | 44 61 74 61 62 61 73 65 |.Create |Database|
|00004160| 39 00 00 00 12 00 00 00 | f5 cb 00 00 6e cc 00 00 |9.......|....n...|
|00004170| 27 00 00 00 20 1e 80 24 | 00 80 00 00 1e 00 b8 98 |'... ..$|........|
|00004180| 42 98 80 03 00 82 ff 00 | 43 52 45 41 54 45 20 44 |B.......|CREATE D|
|00004190| 41 54 41 42 41 53 45 00 | 00 3b 00 00 00 16 00 00 |ATABASE.|.;......|
|000041a0| 00 35 cc 00 00 a9 cc 00 | 00 25 00 00 00 20 1a 80 |.5......|.%... ..|
|000041b0| 2c 00 80 00 00 18 00 52 | 98 80 04 00 82 ff 00 43 |,......R|.......C|
|000041c0| 72 65 61 74 65 73 20 61 | 20 64 61 74 61 62 61 73 |reates a| databas|
|000041d0| 65 2e 00 00 29 00 00 00 | 03 00 00 00 6e cc 00 00 |e...)...|....n...|
|000041e0| d2 cc 00 00 26 00 00 00 | 20 1c 80 06 00 80 00 00 |....&...| .......|
|000041f0| 1a 00 90 52 98 80 06 00 | 82 ff 00 00 00 30 00 00 |...R....|.....0..|
|00004200| 00 09 00 00 00 a9 cc 00 | 00 02 cd 00 00 27 00 00 |........|.....'..|
|00004210| 00 20 1e 80 12 00 80 00 | 00 1e 00 98 8c 52 98 80 |. ......|.....R..|
|00004220| 07 00 82 ff 00 53 79 6e | 74 61 78 00 00 46 01 00 |.....Syn|tax..F..|
|00004230| 00 f0 00 00 00 d2 cc 00 | 00 48 ce 00 00 56 00 00 |........|.H...V..|
|00004240| 00 20 7a 80 e1 01 00 80 | 00 00 1a 00 90 52 98 80 |. z.....|.....R..|
|00004250| 04 00 80 09 00 80 04 00 | 82 80 09 00 80 04 00 80 |........|........|
|00004260| 09 00 80 04 00 82 80 09 | 00 80 04 00 80 09 00 80 |........|........|
|00004270| 04 00 82 80 09 00 80 04 | 00 82 80 09 00 80 04 00 |........|........|
|00004280| 82 82 ff 00 43 52 45 41 | 54 45 20 44 41 54 41 42 |....CREA|TE DATAB|
|00004290| 41 53 45 20 00 64 61 74 | 61 62 61 73 65 5f 6e 61 |ASE .dat|abase_na|
|000042a0| 6d 65 00 00 5b 4f 4e 20 | 7b 44 45 46 41 55 4c 54 |me..[ON |{DEFAULT|
|000042b0| 20 7c 20 00 64 61 74 61 | 62 61 73 65 5f 64 65 76 | | .data|base_dev|
|000042c0| 69 63 65 00 7d 20 5b 3d | 20 00 73 69 7a 65 5f 69 |ice.} [=| .size_i|
|000042d0| 6e 5f 6d 65 67 61 62 79 | 74 65 73 00 5d 00 5b 2c |n_megaby|tes.].[,|
|000042e0| 20 00 64 61 74 61 62 61 | 73 65 5f 64 65 76 69 63 | .databa|se_devic|
|000042f0| 65 00 20 5b 3d 20 00 73 | 69 7a 65 5f 69 6e 5f 6d |e. [= .s|ize_in_m|
|00004300| 65 67 61 62 79 74 65 73 | 00 5d 5d 2e 2e 2e 5d 00 |egabytes|.]]...].|
|00004310| 5b 4c 4f 47 20 4f 4e 20 | 00 64 61 74 61 62 61 73 |[LOG ON |.databas|
|00004320| 65 20 64 65 76 69 63 65 | 00 20 5b 3d 20 73 69 7a |e device|. [= siz|
|00004330| 65 5f 69 6e 5f 6d 65 67 | 61 62 79 74 65 73 3e 5d |e_in_meg|abytes>]|
|00004340| 00 5b 2c 20 00 64 61 74 | 61 62 61 73 65 20 64 65 |.[, .dat|abase de|
|00004350| 76 69 63 65 00 20 5b 3d | 20 73 69 7a 65 5f 69 6e |vice. [=| size_in|
|00004360| 5f 6d 65 67 61 62 79 74 | 65 73 5d 5d 2e 2e 2e 5d |_megabyt|es]]...]|
|00004370| 00 00 00 3f 00 00 00 0e | 00 00 00 02 cd 00 00 87 |...?....|........|
|00004380| ce 00 00 31 00 00 00 02 | df 00 00 00 ff ff ff ff |...1....|........|
|00004390| ff ff ff ff 15 00 00 00 | 87 ce 00 00 64 cf 00 00 |........|....d...|
|000043a0| 1e 00 01 00 43 72 65 61 | 74 65 20 44 65 66 61 75 |....Crea|te Defau|
|000043b0| 6c 74 38 00 00 00 11 00 | 00 00 48 ce 00 00 bf ce |lt8.....|..H.....|
|000043c0| 00 00 27 00 00 00 20 1e | 80 22 00 80 00 00 1e 00 |..'... .|."......|
|000043d0| b8 98 42 98 80 03 00 82 | ff 00 43 52 45 41 54 45 |..B.....|..CREATE|
|000043e0| 20 44 45 46 41 55 4c 54 | 00 00 7c 00 00 00 57 00 | DEFAULT|..|...W.|
|000043f0| 00 00 87 ce 00 00 3b cf | 00 00 25 00 00 00 20 1a |......;.|..%... .|
|00004400| 80 ae 00 80 00 00 18 00 | 52 98 80 04 00 82 ff 00 |........|R.......|
|00004410| 53 70 65 63 69 66 69 65 | 73 20 61 20 76 61 6c 75 |Specifie|s a valu|
|00004420| 65 20 74 6f 20 62 65 20 | 69 6e 73 65 72 74 65 64 |e to be |inserted|
|00004430| 20 69 6e 20 61 20 63 6f | 6c 75 6d 6e 20 69 66 20 | in a co|lumn if |
|00004440| 6e 6f 20 76 61 6c 75 65 | 20 69 73 20 73 75 70 70 |no value| is supp|
|00004450| 6c 69 65 64 20 61 74 20 | 69 6e 73 65 72 74 20 74 |lied at |insert t|
|00004460| 69 6d 65 2e 00 00 29 00 | 00 00 03 00 00 00 bf ce |ime...).|........|
|00004470| 00 00 64 cf 00 00 26 00 | 00 00 20 1c 80 06 00 80 |..d...&.|.. .....|
|00004480| 00 00 1a 00 90 52 98 80 | 06 00 82 ff 00 00 00 30 |.....R..|.......0|
|00004490| 00 00 00 09 00 00 00 3b | cf 00 00 94 cf 00 00 27 |.......;|.......'|
|000044a0| 00 00 00 20 1e 80 12 00 | 80 00 00 1e 00 98 8c 52 |... ....|.......R|
|000044b0| 98 80 07 00 82 ff 00 53 | 79 6e 74 61 78 00 00 7e |.......S|yntax..~|
|000044c0| 00 00 00 44 00 00 00 64 | cf 00 00 1e 00 01 00 3a |...D...d|.......:|
|000044d0| 00 00 00 20 44 80 88 00 | 80 00 00 1a 00 90 52 98 |... D...|......R.|
|000044e0| 80 04 00 80 09 00 80 04 | 00 80 09 00 80 04 00 82 |........|........|
|000044f0| 80 09 00 80 04 00 82 82 | ff 00 43 52 45 41 54 45 |........|..CREATE|
|00004500| 20 44 45 46 41 55 4c 54 | 20 5b 00 6f 77 6e 65 72 | DEFAULT| [.owner|
|00004510| 2e 00 5d 00 64 65 66 61 | 75 6c 74 5f 6e 61 6d 65 |..].defa|ult_name|
|00004520| 00 00 41 53 20 00 63 6f | 6e 73 74 94 cf 00 00 1e |..AS .co|nst.....|
|00004530| 00 01 00 48 ce 00 00 61 | 6e 74 5f 65 78 70 72 65 |...H...a|nt_expre|
|00004540| 73 73 69 6f 6e 00 00 00 | 00 3d 00 00 00 0c 00 00 |ssion...|.=......|
|00004550| 00 94 cf 00 00 5b 00 01 | 00 31 00 00 00 02 b8 01 |.....[..|.1......|
|00004560| 00 00 ff ff ff ff ff ff | ff ff 16 00 00 00 5b 00 |........|......[.|
|00004570| 01 00 f3 00 01 00 7a 02 | 01 00 43 72 65 61 74 65 |......z.|..Create|
|00004580| 20 49 6e 64 65 78 36 00 | 00 00 0f 00 00 00 1e 00 | Index6.|........|
|00004590| 01 00 91 00 01 00 27 00 | 00 00 20 1e 80 1e 00 80 |......'.|.. .....|
|000045a0| 00 00 1e 00 b8 98 42 98 | 80 03 00 82 ff 00 43 52 |......B.|......CR|
|000045b0| 45 41 54 45 20 49 4e 44 | 45 58 00 00 39 00 00 00 |EATE IND|EX..9...|
|000045c0| 14 00 00 00 5b 00 01 00 | ca 00 01 00 25 00 00 00 |....[...|....%...|
|000045d0| 20 1a 80 28 00 80 00 00 | 18 00 52 98 80 04 00 82 | ..(....|..R.....|
|000045e0| ff 00 43 72 65 61 74 65 | 73 20 61 6e 20 69 6e 64 |..Create|s an ind|
|000045f0| 65 78 2e 00 00 29 00 00 | 00 03 00 00 00 91 00 01 |ex...)..|........|
|00004600| 00 f3 00 01 00 26 00 00 | 00 20 1c 80 06 00 80 00 |.....&..|. ......|
|00004610| 00 1a 00 90 52 98 80 06 | 00 82 ff 00 00 00 30 00 |....R...|......0.|
|00004620| 00 00 09 00 00 00 ca 00 | 01 00 23 01 01 00 27 00 |........|..#...'.|
|00004630| 00 00 20 1e 80 12 00 80 | 00 00 1e 00 98 8c 52 98 |.. .....|......R.|
|00004640| 80 07 00 82 ff 00 53 79 | 6e 74 61 78 00 00 57 01 |......Sy|ntax..W.|
|00004650| 00 00 fa 00 00 00 f3 00 | 01 00 7a 02 01 00 5d 00 |........|..z...].|
|00004660| 00 00 20 88 80 f5 01 00 | 80 00 00 1a 00 90 52 98 |.. .....|......R.|
|00004670| 80 04 00 80 09 00 80 04 | 00 82 80 09 00 80 04 00 |........|........|
|00004680| 80 09 00 80 04 00 80 09 | 00 80 04 00 80 09 00 80 |........|........|
|00004690| 04 00 82 80 09 00 80 04 | 00 82 80 09 00 80 04 00 |........|........|
|000046a0| 82 82 80 09 00 80 04 00 | 82 82 ff 00 43 52 45 41 |........|....CREA|
|000046b0| 54 45 20 5b 55 4e 49 51 | 55 45 5d 20 5b 43 4c 55 |TE [UNIQ|UE] [CLU|
|000046c0| 53 54 45 52 45 44 20 7c | 20 4e 4f 4e 43 4c 55 53 |STERED || NONCLUS|
|000046d0| 54 45 52 45 44 5d 20 49 | 4e 44 45 58 20 00 69 6e |TERED] I|NDEX .in|
|000046e0| 64 65 78 5f 6e 61 6d 65 | 00 00 4f 4e 20 5b 5b 00 |dex_name|..ON [[.|
|000046f0| 64 61 74 61 62 61 73 65 | 2e 00 5d 00 6f 77 6e 65 |database|..].owne|
|00004700| 72 2e 00 5d 00 74 61 62 | 6c 65 5f 6e 61 6d 65 00 |r..].tab|le_name.|
|00004710| 20 28 00 63 6f 6c 75 6d | 6e 5f 6e 61 6d 65 00 00 | (.colum|n_name..|
|00004720| 5b 2c 20 00 63 6f 6c 75 | 6d 6e 5f 6e 61 6d 65 00 |[, .colu|mn_name.|
|00004730| 5d 2e 2e 2e 29 00 5b 57 | 49 54 48 20 7b 46 49 4c |]...).[W|ITH {FIL|
|00004740| 4c 46 41 43 54 4f 52 20 | 3d 20 00 78 00 2c 20 49 |LFACTOR |= .x., I|
|00004750| 47 4e 4f 52 45 5f 44 55 | 50 5f 4b 45 59 2c 20 53 |GNORE_DU|P_KEY, S|
|00004760| 4f 52 54 45 44 5f 44 41 | 54 41 2c 00 5b 49 47 4e |ORTED_DA|TA,.[IGN|
|00004770| 4f 52 45 5f 44 55 50 5f | 52 4f 57 20 7c 20 41 4c |ORE_DUP_|ROW | AL|
|00004780| 4c 4f 57 5f 44 55 50 5f | 52 4f 57 5d 7d 5d 00 5b |LOW_DUP_|ROW]}].[|
|00004790| 4f 4e 20 00 73 65 67 6d | 65 6e 74 5f 6e 61 6d 65 |ON .segm|ent_name|
|000047a0| 00 5d 00 00 00 41 00 00 | 00 10 00 00 00 23 01 01 |.]...A..|.....#..|
|000047b0| 00 bb 02 01 00 31 00 00 | 00 02 9f 01 00 00 ff ff |.....1..|........|
|000047c0| ff ff ff ff ff ff 17 00 | 00 00 bb 02 01 00 61 03 |........|......a.|
|000047d0| 01 00 cf 04 01 00 43 72 | 65 61 74 65 20 50 72 6f |......Cr|eate Pro|
|000047e0| 63 65 64 75 72 65 3a 00 | 00 00 13 00 00 00 7a 02 |cedure:.|......z.|
|000047f0| 01 00 f5 02 01 00 27 00 | 00 00 20 1e 80 26 00 80 |......'.|.. ..&..|
|00004800| 00 00 1e 00 b8 98 42 98 | 80 03 00 82 ff 00 43 52 |......B.|......CR|
|00004810| 45 41 54 45 20 50 52 4f | 43 45 44 55 52 45 00 00 |EATE PRO|CEDURE..|
|00004820| 43 00 00 00 1e 00 00 00 | bb 02 01 00 38 03 01 00 |C.......|....8...|
|00004830| 25 00 00 00 20 1a 80 3c | 00 80 00 00 18 00 52 98 |%... ..<|......R.|
|00004840| 80 04 00 82 ff 00 43 72 | 65 61 74 65 73 20 61 20 |......Cr|eates a |
|00004850| 73 74 6f 72 65 64 20 70 | 72 6f 63 65 64 75 72 65 |stored p|rocedure|
|00004860| 2e 00 00 29 00 00 00 03 | 00 00 00 f5 02 01 00 61 |...)....|.......a|
|00004870| 03 01 00 26 00 00 00 20 | 1c 80 06 00 80 00 00 1a |...&... |........|
|00004880| 00 90 52 98 80 06 00 82 | ff 00 00 00 30 00 00 00 |..R.....|....0...|
|00004890| 09 00 00 00 38 03 01 00 | 91 03 01 00 27 00 00 00 |....8...|....'...|
|000048a0| 20 1e 80 12 00 80 00 00 | 1e 00 98 8c 52 98 80 07 | .......|....R...|
|000048b0| 00 82 ff 00 53 79 6e 74 | 61 78 00 00 3e 01 00 00 |....Synt|ax..>...|
|000048c0| d6 00 00 00 61 03 01 00 | cf 04 01 00 68 00 00 00 |....a...|....h...|
|000048d0| 20 9e 80 ad 01 00 80 00 | 00 1a 00 90 52 98 80 04 | .......|....R...|
|000048e0| 00 80 09 00 80 04 00 80 | 09 00 80 04 00 80 09 00 |........|........|
|000048f0| 80 04 00 82 80 09 00 80 | 04 00 80 09 00 80 04 00 |........|........|
|00004900| 80 09 00 80 04 00 82 80 | 09 00 80 04 00 80 09 00 |........|........|
|00004910| 80 04 00 80 09 00 80 04 | 00 82 82 80 09 00 80 04 |........|........|
|00004920| 00 82 82 ff 00 43 52 45 | 41 54 45 20 50 52 4f 43 |.....CRE|ATE PROC|
|00004930| 65 64 75 72 65 20 5b 00 | 6f 77 6e 65 72 2e 00 5d |edure [.|owner..]|
|00004940| 00 70 72 6f 63 65 64 75 | 72 65 5f 6e 61 6d 65 00 |.procedu|re_name.|
|00004950| 20 5b 00 3b 6e 75 6d 62 | 65 72 00 5d 00 5b 5b 28 | [.;numb|er.].[[(|
|00004960| 5d 00 40 70 61 72 61 6d | 65 74 65 72 5f 6e 61 6d |].@param|eter_nam|
|00004970| 65 00 20 00 64 61 74 61 | 74 79 70 65 00 20 5b 3d |e. .data|type. [=|
|00004980| 20 00 64 65 66 61 75 6c | 74 00 5d 20 5b 4f 55 54 | .defaul|t.] [OUT|
|00004990| 70 75 74 5d 00 5b 2c 20 | 00 40 70 61 72 61 6d 65 |put].[, |.@parame|
|000049a0| 74 65 72 5f 6e 61 6d 65 | 00 20 00 64 61 74 61 74 |ter_name|. .datat|
|000049b0| 79 70 65 00 20 5b 3d 20 | 00 64 65 66 61 75 6c 74 |ype. [= |.default|
|000049c0| 00 5d 20 5b 4f 55 54 70 | 75 74 5d 2e 2e 2e 5b 29 |.] [OUTp|ut]...[)|
|000049d0| 5d 5d 00 5b 57 49 54 48 | 20 52 45 43 4f 4d 50 49 |]].[WITH| RECOMPI|
|000049e0| 4c 45 5d 00 41 53 20 00 | 73 71 6c 5f 73 74 61 74 |LE].AS .|sql_stat|
|000049f0| 65 6d 65 6e 74 73 00 00 | 00 00 3c 00 00 00 0b 00 |ements..|..<.....|
|00004a00| 00 00 91 03 01 00 0b 05 | 01 00 31 00 00 00 02 da |........|..1.....|
|00004a10| 00 00 00 ff ff ff ff ff | ff ff ff 18 00 00 00 0b |........|........|
|00004a20| 05 01 00 f8 05 01 00 a1 | 06 01 00 43 72 65 61 74 |........|...Creat|
|00004a30| 65 20 52 75 6c 65 35 00 | 00 00 0e 00 00 00 cf 04 |e Rule5.|........|
|00004a40| 01 00 40 05 01 00 27 00 | 00 00 20 1e 80 1c 00 80 |..@...'.|.. .....|
|00004a50| 00 00 1e 00 b8 98 42 98 | 80 03 00 82 ff 00 43 52 |......B.|......CR|
|00004a60| 45 41 54 45 20 52 55 4c | 45 00 00 8f 00 00 00 6a |EATE RUL|E......j|
|00004a70| 00 00 00 0b 05 01 00 cf | 05 01 00 25 00 00 00 20 |........|...%... |
|00004a80| 1a 80 d4 00 80 00 00 18 | 00 52 98 80 04 00 82 ff |........|.R......|
|00004a90| 00 53 70 65 63 69 66 69 | 65 73 20 74 68 65 20 61 |.Specifi|es the a|
|00004aa0| 63 63 65 70 74 61 62 6c | 65 20 76 61 6c 75 65 73 |cceptabl|e values|
|00004ab0| 20 66 6f 72 20 61 20 70 | 61 72 74 69 63 75 6c 61 | for a p|articula|
|00004ac0| 72 20 63 6f 6c 75 6d 6e | 20 6f 72 20 66 6f 72 20 |r column| or for |
|00004ad0| 61 6e 79 20 63 6f 6c 75 | 6d 6e 20 6f 66 20 61 20 |any colu|mn of a |
|00004ae0| 75 73 65 72 2d 73 70 65 | 63 69 66 69 65 64 20 64 |user-spe|cified d|
|00004af0| 61 74 61 74 79 70 65 2e | 00 00 29 00 00 00 03 00 |atatype.|..).....|
|00004b00| 00 00 40 05 01 00 f8 05 | 01 00 26 00 00 00 20 1c |..@.....|..&... .|
|00004b10| 80 06 00 80 00 00 1a 00 | 90 52 98 80 06 00 82 ff |........|.R......|
|00004b20| 00 00 00 30 00 00 00 09 | 00 00 00 cf 05 01 00 28 |...0....|.......(|
|00004b30| 06 01 00 27 00 00 00 20 | 1e 80 12 00 80 00 00 1e |...'... |........|
|00004b40| 00 98 8c 52 98 80 07 00 | 82 ff 00 53 79 6e 74 61 |...R....|...Synta|
|00004b50| 78 00 00 79 00 00 00 3f | 00 00 00 f8 05 01 00 a1 |x..y...?|........|
|00004b60| 06 01 00 3a 00 00 00 20 | 44 80 7e 00 80 00 00 1a |...:... |D.~.....|
|00004b70| 00 90 52 98 80 04 00 80 | 09 00 80 04 00 80 09 00 |..R.....|........|
|00004b80| 80 04 00 82 80 09 00 80 | 04 00 82 82 ff 00 43 52 |........|......CR|
|00004b90| 45 41 54 45 20 52 55 4c | 45 20 5b 00 6f 77 6e 65 |EATE RUL|E [.owne|
|00004ba0| 72 2e 00 5d 00 72 75 6c | 65 5f 6e 61 6d 65 00 00 |r..].rul|e_name..|
|00004bb0| 41 53 20 00 63 6f 6e 64 | 69 74 69 6f 6e 5f 65 78 |AS .cond|ition_ex|
|00004bc0| 70 72 65 73 73 69 6f 6e | 00 00 00 00 3d 00 00 00 |pression|....=...|
|00004bd0| 0c 00 00 00 28 06 01 00 | de 06 01 00 31 00 00 00 |....(...|....1...|
|00004be0| 02 63 01 00 00 ff ff ff | ff ff ff ff ff 19 00 00 |.c......|........|
|00004bf0| 00 de 06 01 00 75 07 01 | 00 a7 08 01 00 43 72 65 |.....u..|.....Cre|
|00004c00| 61 74 65 20 54 61 62 6c | 65 36 00 00 00 0f 00 00 |ate Tabl|e6......|
|00004c10| 00 a1 06 01 00 14 07 01 | 00 27 00 00 00 20 1e 80 |........|.'... ..|
|00004c20| 1e 00 80 00 00 1e 00 b8 | 98 42 98 80 03 00 82 ff |........|.B......|
|00004c30| 00 43 52 45 41 54 45 20 | 54 41 42 4c 45 00 00 38 |.CREATE |TABLE..8|
|00004c40| 00 00 00 13 00 00 00 de | 06 01 00 4c 07 01 00 25 |........|...L...%|
|00004c50| 00 00 00 20 1a 80 26 00 | 80 00 00 18 00 52 98 80 |... ..&.|.....R..|
|00004c60| 04 00 82 ff 00 43 72 65 | 61 74 65 73 20 61 20 74 |.....Cre|ates a t|
|00004c70| 61 62 6c 65 2e 00 00 29 | 00 00 00 03 00 00 00 14 |able...)|........|
|00004c80| 07 01 00 75 07 01 00 26 | 00 00 00 20 1c 80 06 00 |...u...&|... ....|
|00004c90| 80 00 00 1a 00 90 52 98 | 80 06 00 82 ff 00 00 00 |......R.|........|
|00004ca0| 30 00 00 00 09 00 00 00 | 4c 07 01 00 a5 07 01 00 |0.......|L.......|
|00004cb0| 27 00 00 00 20 1e 80 12 | 00 80 00 00 1e 00 98 8c |'... ...|........|
|00004cc0| 52 98 80 07 00 82 ff 00 | 53 79 6e 74 61 78 00 00 |R.......|Syntax..|
|00004cd0| 02 01 00 00 a7 00 00 00 | 75 07 01 00 a7 08 01 00 |........|u.......|
|00004ce0| 5b 00 00 00 20 84 80 4f | 01 00 80 00 00 1a 00 90 |[... ..O|........|
|00004cf0| 52 98 80 04 00 80 09 00 | 80 04 00 80 09 00 80 04 |R.......|........|
|00004d00| 00 80 09 00 80 04 00 82 | 80 09 00 80 04 00 80 09 |........|........|
|00004d10| 00 80 04 00 82 80 09 00 | 80 04 00 80 09 00 80 04 |........|........|
|00004d20| 00 82 80 09 00 80 04 00 | 82 82 ff 00 43 52 45 41 |........|....CREA|
|00004d30| 54 45 20 54 41 42 4c 45 | 20 5b 5b 00 64 61 74 61 |TE TABLE| [[.data|
|00004d40| 62 61 73 65 2e 00 5d 00 | 6f 77 6e 65 72 2e 00 5d |base..].|owner..]|
|00004d50| 00 74 61 62 6c 65 5f 6e | 61 6d 65 00 00 28 00 63 |.table_n|ame..(.c|
|00004d60| 6f 6c 75 6d 6e 5f 6e 61 | 6d 65 00 20 00 64 61 74 |olumn_na|me. .dat|
|00004d70| 61 74 79 70 65 00 20 5b | 4e 4f 54 20 4e 55 4c 4c |atype. [|NOT NULL|
|00004d80| 20 7c 20 4e 55 4c 4c 5d | 00 5b 2c 20 00 63 6f 6c | | NULL]|.[, .col|
|00004d90| 75 6d 6e 5f 6e 61 6d 65 | 00 20 00 64 61 74 61 74 |umn_name|. .datat|
|00004da0| 79 70 65 00 20 5b 4e 4f | 54 20 4e 55 4c 4c 20 7c |ype. [NO|T NULL ||
|00004db0| 20 4e 55 4c 4c 5d 5d 2e | 2e 2e 29 00 5b 4f 4e 20 | NULL]].|..).[ON |
|00004dc0| 00 73 65 67 6d 65 6e 74 | 20 6e 61 6d 65 00 5d 00 |.segment| name.].|
|00004dd0| 00 00 3f 00 00 00 0e 00 | 00 00 a5 07 01 00 e6 08 |..?.....|........|
|00004de0| 01 00 31 00 00 00 02 28 | 02 00 00 ff ff ff ff ff |..1....(|........|
|00004df0| ff ff ff 1a 00 00 00 e6 | 08 01 00 50 0a 01 00 47 |........|...P...G|
|00004e00| 0c 01 00 43 72 65 61 74 | 65 20 54 72 69 67 67 65 |...Creat|e Trigge|
|00004e10| 72 38 00 00 00 11 00 00 | 00 a7 08 01 00 1e 09 01 |r8......|........|
|00004e20| 00 27 00 00 00 20 1e 80 | 22 00 80 00 00 1e 00 b8 |.'... ..|".......|
|00004e30| 98 42 98 80 03 00 82 ff | 00 43 52 45 41 54 45 20 |.B......|.CREATE |
|00004e40| 54 52 49 47 47 45 52 00 | 00 09 01 00 00 e3 00 00 |TRIGGER.|........|
|00004e50| 00 e6 08 01 00 27 0a 01 | 00 26 00 00 00 20 1a 80 |.....'..|.&... ..|
|00004e60| c7 01 00 80 00 00 18 00 | 52 98 80 04 00 82 ff 00 |........|R.......|
|00004e70| 43 72 65 61 74 65 73 20 | 61 20 74 72 69 67 67 65 |Creates |a trigge|
|00004e80| 72 2c 20 61 20 73 70 65 | 63 69 61 6c 20 6b 69 6e |r, a spe|cial kin|
|00004e90| 64 20 6f 66 20 73 74 6f | 72 65 64 20 70 72 6f 63 |d of sto|red proc|
|00004ea0| 65 64 75 72 65 20 6f 66 | 74 65 6e 20 75 73 65 64 |edure of|ten used|
|00004eb0| 20 66 6f 72 20 65 6e 66 | 6f 72 63 69 6e 67 20 69 | for enf|orcing i|
|00004ec0| 6e 74 65 67 72 69 74 79 | 20 63 6f 6e 73 74 72 61 |ntegrity| constra|
|00004ed0| 69 6e 74 73 2e 20 41 20 | 74 72 69 67 67 65 72 20 |ints. A |trigger |
|00004ee0| 69 73 20 65 78 65 63 75 | 74 65 64 20 61 75 74 6f |is execu|ted auto|
|00004ef0| 6d 61 74 69 63 61 6c 6c | 79 20 77 68 65 6e 20 61 |maticall|y when a|
|00004f00| 20 75 73 65 72 20 61 74 | 74 65 6d 70 74 73 20 74 | user at|tempts t|
|00004f10| 68 65 20 73 70 65 63 69 | 66 69 65 64 20 64 61 74 |he speci|fied dat|
|00004f20| 61 2d 6d 6f 64 69 66 69 | 63 61 74 69 6f 6e 20 73 |a-modifi|cation s|
|00004f30| 74 61 74 65 6d 65 6e 74 | 20 6f 6e 20 74 68 65 20 |tatement| on the |
|00004f40| 73 70 65 63 69 66 69 65 | 64 20 74 61 62 6c 65 2e |specifie|d table.|
|00004f50| 00 00 29 00 00 00 03 00 | 00 00 1e 09 01 00 50 0a |..).....|......P.|
|00004f60| 01 00 26 00 00 00 20 1c | 80 06 00 80 00 00 1a 00 |..&... .|........|
|00004f70| 90 52 98 80 06 00 82 ff | 00 00 00 30 00 00 00 09 |.R......|...0....|
|00004f80| 00 00 00 27 0a 01 00 80 | 0a 01 00 27 00 00 00 20 |...'....|...'... |
|00004f90| 1e 80 12 00 80 00 00 1e | 00 98 8c 52 98 80 07 00 |........|...R....|
|00004fa0| 82 ff 00 53 79 6e 74 61 | 78 00 00 c7 01 00 00 4b |...Synta|x......K|
|00004fb0| 01 00 00 50 0a 01 00 47 | 0c 01 00 7c 00 00 00 20 |...P...G|...|... |
|00004fc0| c6 80 97 02 00 80 00 00 | 1a 00 90 52 98 80 04 00 |........|...R....|
|00004fd0| 80 09 00 80 04 00 80 09 | 00 80 04 00 82 80 09 00 |........|........|
|00004fe0| 80 04 00 80 09 00 80 04 | 00 82 82 80 09 00 80 04 |........|........|
|00004ff0| 00 82 82 82 82 80 09 00 | 80 04 00 80 09 00 80 04 |........|........|
|00005000| 00 82 80 09 00 80 04 00 | 80 09 00 80 04 00 82 82 |........|........|
|00005010| 82 80 09 00 80 04 00 82 | 80 09 00 80 04 00 80 09 |........|........|
|00005020| 00 80 04 00 82 82 ff 00 | 43 52 45 41 54 45 20 54 |........|CREATE T|
|00005030| 52 49 47 47 45 52 20 5b | 00 6f 77 6e 65 72 2e 00 |RIGGER [|.owner..|
|00005040| 5d 00 74 72 69 67 67 65 | 72 5f 6e 61 6d 65 00 00 |].trigge|r_name..|
|00005050| 4f 4e 20 5b 00 6f 77 6e | 65 72 2e 00 5d 00 74 61 |ON [.own|er..].ta|
|00005060| 62 6c 65 5f 6e 61 6d 65 | 00 00 7b 46 4f 52 20 7b |ble_name|..{FOR {|
|00005070| 49 4e 53 45 52 54 2c 20 | 55 50 44 41 54 45 2c 20 |INSERT, |UPDATE, |
|00005080| 44 45 4c 45 54 45 7d 00 | 41 53 20 00 73 71 6c 5f |DELETE}.|AS .sql_|
|00005090| 73 74 61 74 65 6d 65 6e | 74 73 00 20 7c 00 00 4f |statemen|ts. |..O|
|000050a0| 72 2c 20 69 66 20 75 73 | 69 6e 67 20 74 68 65 20 |r, if us|ing the |
|000050b0| 49 46 20 55 50 44 41 54 | 45 20 63 6c 61 75 73 65 |IF UPDAT|E clause|
|000050c0| 3a 00 00 43 52 45 41 54 | 45 20 54 52 49 47 47 45 |:..CREAT|E TRIGGE|
|000050d0| 52 20 5b 00 6f 77 6e 65 | 72 2e 00 5d 00 74 72 69 |R [.owne|r..].tri|
|000050e0| 67 67 65 72 5f 6e 61 6d | 65 00 00 4f 4e 20 5b 00 |gger_nam|e..ON [.|
|000050f0| 6f 77 6e 65 72 2e 00 5d | 00 74 61 62 6c 65 5f 6e |owner..]|.table_n|
|00005100| 61 6d 65 00 00 46 4f 52 | 20 7b 49 4e 53 45 52 54 |ame..FOR| {INSERT|
|00005110| 2c 20 55 50 44 41 54 45 | 7d 00 41 53 00 49 46 20 |, UPDATE|}.AS.IF |
|00005120| 55 50 44 41 54 45 20 28 | 00 63 6f 6c 75 6d 6e 5f |UPDATE (|.column_|
|00005130| 6e 61 6d 65 00 29 00 5b | 7b 41 4e 44 20 7c 20 4f |name.).[|{AND | O|
|00005140| 52 7d 20 55 50 44 41 54 | 45 20 28 00 63 6f 6c 75 |R} UPDAT|E (.colu|
|00005150| 6d 6e 5f 6e 61 6d 65 00 | 29 2e 2e 2e 5d 20 00 73 |mn_name.|)...] .s|
|00005160| 71 6c 5f 73 74 61 74 65 | 6d 65 6e 74 73 00 7d 00 |ql_state|ments.}.|
|00005170| 00 00 3c 00 00 00 0b 00 | 00 00 80 0a 01 00 83 0c |..<.....|........|
|00005180| 01 00 31 00 00 00 02 0a | 01 00 00 ff ff ff ff ff |..1.....|........|
|00005190| ff ff ff 1b 00 00 00 83 | 0c 01 00 18 0d 01 00 f1 |........|........|
|000051a0| 0d 01 00 43 72 65 61 74 | 65 20 56 69 65 77 35 00 |...Creat|e View5.|
|000051b0| 00 00 0e 00 00 00 47 0c | 01 00 b8 0c 01 00 27 00 |......G.|......'.|
|000051c0| 00 00 20 1e 80 1c 00 80 | 00 00 1e 00 b8 98 42 98 |.. .....|......B.|
|000051d0| 80 03 00 82 ff 00 43 52 | 45 41 54 45 20 56 49 45 |......CR|EATE VIE|
|000051e0| 57 00 00 37 00 00 00 12 | 00 00 00 83 0c 01 00 ef |W..7....|........|
|000051f0| 0c 01 00 25 00 00 00 20 | 1a 80 24 00 80 00 00 18 |...%... |..$.....|
|00005200| 00 52 98 80 04 00 82 ff | 00 43 72 65 61 74 65 73 |.R......|.Creates|
|00005210| 20 61 20 76 69 65 77 2e | 00 00 29 00 00 00 03 00 | a view.|..).....|
|00005220| 00 00 b8 0c 01 00 18 0d | 01 00 26 00 00 00 20 1c |........|..&... .|
|00005230| 80 06 00 80 00 00 1a 00 | 90 52 98 80 06 00 82 ff |........|.R......|
|00005240| 00 00 00 30 00 00 00 09 | 00 00 00 ef 0c 01 00 48 |...0....|.......H|
|00005250| 0d 01 00 27 00 00 00 20 | 1e 80 12 00 80 00 00 1e |...'... |........|
|00005260| 00 98 8c 52 98 80 07 00 | 82 ff 00 53 79 6e 74 61 |...R....|...Synta|
|00005270| 78 00 00 a9 00 00 00 62 | 00 00 00 18 0d 01 00 f1 |x......b|........|
|00005280| 0d 01 00 47 00 00 00 20 | 5e 80 c4 00 80 00 00 1a |...G... |^.......|
|00005290| 00 90 52 98 80 04 00 80 | 09 00 80 04 00 80 09 00 |..R.....|........|
|000052a0| 80 04 00 82 80 09 00 80 | 04 00 80 09 00 80 04 00 |........|........|
|000052b0| 82 80 09 00 80 04 00 82 | 82 ff 00 43 52 45 41 54 |........|...CREAT|
|000052c0| 45 20 56 49 45 57 20 5b | 00 6f 77 6e 65 72 2e 00 |E VIEW [|.owner..|
|000052d0| 5d 00 76 69 65 77 5f 6e | 61 6d 65 00 00 5b 28 00 |].view_n|ame..[(.|
|000052e0| 63 6f 6c 75 6d 6e 5f 6e | 61 6d 65 00 20 5b 2c 20 |column_n|ame. [, |
|000052f0| 00 63 6f 6c 75 6d 6e 5f | 6e 61 6d 65 00 5d 2e 2e |.column_|name.]..|
|00005300| 2e 29 5d 00 41 53 20 00 | 73 65 6c 65 63 74 5f 73 |.)].AS .|select_s|
|00005310| 74 61 74 65 6d 65 6e 74 | 00 00 00 00 35 00 00 00 |tatement|....5...|
|00005320| 04 00 00 00 48 0d 01 00 | 26 0e 01 00 31 00 00 00 |....H...|&...1...|
|00005330| 02 af 03 00 00 ff ff ff | ff ff ff ff ff 1c 00 00 |........|........|
|00005340| 00 26 0e 01 00 df 0e 01 | 00 67 41 01 00 44 42 43 |.&......|.gA..DBC|
|00005350| 43 2e 00 00 00 07 00 00 | 00 f1 0d 01 00 54 0e 01 |C.......|.....T..|
|00005360| 00 27 00 00 00 20 1e 80 | 0e 00 80 00 00 1e 00 b8 |.'... ..|........|
|00005370| 98 42 98 80 03 00 82 ff | 00 44 42 43 43 00 00 62 |.B......|.DBCC..b|
|00005380| 00 00 00 3d 00 00 00 26 | 0e 01 00 b6 0e 01 00 25 |...=...&|.......%|
|00005390| 00 00 00 20 1a 80 7a 00 | 80 00 00 18 00 52 98 80 |... ..z.|.....R..|
|000053a0| 04 00 82 ff 00 43 68 65 | 63 6b 73 20 74 68 65 20 |.....Che|cks the |
|000053b0| 6c 6f 67 69 63 61 6c 20 | 61 6e 64 20 70 68 79 73 |logical |and phys|
|000053c0| 69 63 61 6c 20 63 6f 6e | 73 69 73 74 65 6e 63 79 |ical con|sistency|
|000053d0| 20 6f 66 20 61 20 64 61 | 74 61 62 61 73 65 2e 00 | of a da|tabase..|
|000053e0| 00 29 00 00 00 03 00 00 | 00 54 0e 01 00 df 0e 01 |.)......|.T......|
|000053f0| 00 26 00 00 00 20 1c 80 | 06 00 80 00 00 1a 00 90 |.&... ..|........|
|00005400| 52 98 80 06 00 82 ff 00 | 00 00 30 00 00 00 09 00 |R.......|..0.....|
|00005410| 00 00 b6 0e 01 00 0f 0f | 01 00 27 00 00 00 20 1e |........|..'... .|
|00005420| 80 12 00 80 00 00 1e 00 | 98 8c 52 98 80 07 00 82 |........|..R.....|
|00005430| ff 00 53 79 6e 74 61 78 | 00 00 23 02 00 00 b2 01 |..Syntax|..#.....|
|00005440| 00 00 df 0e 01 00 3e 41 | 01 00 71 00 00 00 20 b0 |......>A|..q... .|
|00005450| 80 65 03 00 80 00 00 1a | 00 90 52 98 80 04 00 82 |.e......|..R.....|
|00005460| 80 09 00 80 04 00 80 09 | 00 80 04 00 82 80 09 00 |........|........|
|00005470| 80 04 00 80 09 00 80 04 | 00 82 80 09 00 80 04 00 |........|........|
|00005480| 80 09 00 80 04 00 82 80 | 09 00 80 04 00 80 09 00 |........|........|
|00005490| 80 04 00 82 80 09 00 80 | 04 00 82 80 09 00 80 04 |........|........|
|000054a0| 00 82 82 80 09 00 80 04 | 00 82 ff 00 44 42 43 43 |........|....DBCC|
|000054b0| 00 7b 43 48 45 43 4b 54 | 41 42 4c 45 20 28 00 74 |.{CHECKT|ABLE (.t|
|000054c0| 61 62 6c 65 5f 6e 61 6d | 65 00 29 20 7c 20 43 48 |able_nam|e.) | CH|
|000054d0| 45 43 4b 44 42 20 5b 28 | 00 64 61 74 61 62 61 73 |ECKDB [(|.databas|
|000054e0| 65 5f 6e 61 6d 65 00 29 | 5d 20 7c 00 43 48 45 43 |e_name.)|] |.CHEC|
|000054f0| 4b 41 4c 4c 4f 43 20 5b | 28 00 64 61 74 61 62 61 |KALLOC [|(.databa|
|00005500| 73 65 5f 6e 61 6d 65 00 | 29 5d 20 7c 20 4e 45 57 |se_name.|)] | NEW|
|00005510| 41 4c 4c 4f 43 20 5b 28 | 00 64 61 74 61 62 61 73 |ALLOC [(|.databas|
|00005520| 65 5f 6e 61 6d 65 00 29 | 5d 20 7c 0f 0f 01 00 3e |e_name.)|] |....>|
|00005530| 41 01 00 f1 0d 01 00 00 | 54 45 58 54 41 4c 4c 4f |A.......|TEXTALLO|
|00005540| 43 20 5b 28 7b 00 6f 62 | 6a 65 63 74 5f 6e 61 6d |C [({.ob|ject_nam|
|00005550| 65 00 20 7c 20 00 6f 62 | 6a 65 63 74 5f 69 64 00 |e. | .ob|ject_id.|
|00005560| 7d 20 5b 2c 20 46 55 4c | 4c 20 7c 20 46 41 53 54 |} [, FUL|L | FAST|
|00005570| 5d 29 5d 20 7c 00 54 45 | 58 54 41 4c 4c 20 5b 28 |])] |.TE|XTALL [(|
|00005580| 7b 00 64 61 74 61 62 61 | 73 65 5f 6e 61 6d 65 00 |{.databa|se_name.|
|00005590| 20 7c 20 00 64 62 69 64 | 00 7d 20 5b 2c 20 46 55 | | .dbid|.} [, FU|
|000055a0| 4c 4c 20 7c 20 46 41 53 | 54 5d 29 5d 20 7c 00 43 |LL | FAS|T])] |.C|
|000055b0| 48 45 43 4b 43 41 54 41 | 4c 4f 47 20 5b 28 00 64 |HECKCATA|LOG [(.d|
|000055c0| 61 74 61 62 61 73 65 5f | 6e 61 6d 65 00 29 5d 20 |atabase_|name.)] |
|000055d0| 7c 00 44 42 52 45 50 41 | 49 52 20 28 00 64 61 74 ||.DBREPA|IR (.dat|
|000055e0| 61 62 61 73 65 5f 6e 61 | 6d 65 00 2c 20 44 52 4f |abase_na|me., DRO|
|000055f0| 50 44 42 29 20 7c 20 4d | 45 4d 55 53 41 47 45 20 |PDB) | M|EMUSAGE |
|00005600| 7c 20 41 4c 4c 4f 57 31 | 31 4c 4f 41 44 20 7c 00 || ALLOW1|1LOAD |.|
|00005610| 53 51 4c 50 45 52 46 28 | 49 4f 53 54 41 54 53 20 |SQLPERF(|IOSTATS |
|00005620| 7c 20 4c 52 55 53 54 41 | 54 53 20 7c 20 4e 45 54 || LRUSTA|TS | NET|
|00005630| 53 54 41 54 53 20 5b 2c | 20 43 4c 45 41 52 5d 29 |STATS [,| CLEAR])|
|00005640| 20 7c 00 53 51 4c 50 45 | 52 46 28 4c 4f 47 53 50 | |.SQLPE|RF(LOGSP|
|00005650| 41 43 45 29 20 7c 20 00 | 64 6c 6c 6e 61 6d 65 00 |ACE) | .|dllname.|
|00005660| 28 46 52 45 45 29 7d 00 | 00 29 00 00 00 03 00 00 |(FREE)}.|.)......|
|00005670| 00 0f 0f 01 00 67 41 01 | 00 26 00 00 00 20 1c 80 |.....gA.|.&... ..|
|00005680| 06 00 80 00 00 1a 00 90 | 52 98 80 04 00 82 ff 00 |........|R.......|
|00005690| 00 00 38 00 00 00 07 00 | 00 00 3e 41 01 00 9f 41 |..8.....|..>A...A|
|000056a0| 01 00 31 00 00 00 02 ea | 00 00 00 ff ff ff ff ff |..1.....|........|
|000056b0| ff ff ff 1d 00 00 00 9f | 41 01 00 6f 42 01 00 28 |........|A..oB..(|
|000056c0| 43 01 00 44 65 63 6c 61 | 72 65 31 00 00 00 0a 00 |C..Decla|re1.....|
|000056d0| 00 00 67 41 01 00 d0 41 | 01 00 27 00 00 00 20 1e |..gA...A|..'... .|
|000056e0| 80 14 00 80 00 00 1e 00 | b8 98 42 98 80 03 00 82 |........|..B.....|
|000056f0| ff 00 44 45 43 4c 41 52 | 45 00 00 76 00 00 00 51 |..DECLAR|E..v...Q|
|00005700| 00 00 00 9f 41 01 00 46 | 42 01 00 25 00 00 00 20 |....A..F|B..%... |
|00005710| 1a 80 a2 00 80 00 00 18 | 00 52 98 80 04 00 82 ff |........|.R......|
|00005720| 00 44 65 63 6c 61 72 65 | 73 20 74 68 65 20 6e 61 |.Declare|s the na|
|00005730| 6d 65 20 61 6e 64 20 74 | 79 70 65 20 6f 66 20 6c |me and t|ype of l|
|00005740| 6f 63 61 6c 20 76 61 72 | 69 61 62 6c 65 73 20 66 |ocal var|iables f|
|00005750| 6f 72 20 61 20 62 61 74 | 63 68 20 6f 72 20 73 74 |or a bat|ch or st|
|00005760| 6f 72 65 64 20 70 72 6f | 63 65 64 75 72 65 2e 00 |ored pro|cedure..|
|00005770| 00 29 00 00 00 03 00 00 | 00 d0 41 01 00 6f 42 01 |.)......|..A..oB.|
|00005780| 00 26 00 00 00 20 1c 80 | 06 00 80 00 00 1a 00 90 |.&... ..|........|
|00005790| 52 98 80 06 00 82 ff 00 | 00 00 30 00 00 00 09 00 |R.......|..0.....|
|000057a0| 00 00 46 42 01 00 9f 42 | 01 00 27 00 00 00 20 1e |..FB...B|..'... .|
|000057b0| 80 12 00 80 00 00 1e 00 | 98 8c 52 98 80 07 00 82 |........|..R.....|
|000057c0| ff 00 53 79 6e 74 61 78 | 00 00 89 00 00 00 4a 00 |..Syntax|......J.|
|000057d0| 00 00 6f 42 01 00 28 43 | 01 00 3f 00 00 00 20 4e |..oB..(C|..?... N|
|000057e0| 80 94 00 80 00 00 1a 00 | 90 52 98 80 04 00 80 09 |........|.R......|
|000057f0| 00 80 04 00 80 09 00 80 | 04 00 80 09 00 80 04 00 |........|........|
|00005800| 80 09 00 80 04 00 82 82 | ff 00 44 45 43 4c 41 52 |........|..DECLAR|
|00005810| 45 20 00 40 76 61 72 69 | 61 62 6c 65 5f 6e 61 6d |E .@vari|able_nam|
|00005820| 65 00 20 00 64 61 74 61 | 74 79 70 65 00 20 5b 2c |e. .data|type. [,|
|00005830| 20 00 40 76 61 72 69 61 | 62 6c 65 5f 6e 61 6d 65 | .@varia|ble_name|
|00005840| 00 20 00 64 61 74 61 74 | 79 70 65 00 2e 2e 2e 5d |. .datat|ype....]|
|00005850| 00 00 00 37 00 00 00 06 | 00 00 00 9f 42 01 00 5f |...7....|....B.._|
|00005860| 43 01 00 31 00 00 00 02 | 29 02 00 00 ff ff ff ff |C..1....|).......|
|00005870| ff ff ff ff 1e 00 00 00 | 5f 43 01 00 fa 43 01 00 |........|_C...C..|
|00005880| f2 45 01 00 44 65 6c 65 | 74 65 30 00 00 00 09 00 |.E..Dele|te0.....|
|00005890| 00 00 28 43 01 00 8f 43 | 01 00 27 00 00 00 20 1e |..(C...C|..'... .|
|000058a0| 80 12 00 80 00 00 1e 00 | b8 98 42 98 80 03 00 82 |........|..B.....|
|000058b0| ff 00 44 45 4c 45 54 45 | 00 00 42 00 00 00 1d 00 |..DELETE|..B.....|
|000058c0| 00 00 5f 43 01 00 d1 43 | 01 00 25 00 00 00 20 1a |.._C...C|..%... .|
|000058d0| 80 3a 00 80 00 00 18 00 | 52 98 80 04 00 82 ff 00 |.:......|R.......|
|000058e0| 52 65 6d 6f 76 65 73 20 | 72 6f 77 73 20 66 72 6f |Removes |rows fro|
|000058f0| 6d 20 61 20 74 61 62 6c | 65 2e 00 00 29 00 00 00 |m a tabl|e...)...|
|00005900| 03 00 00 00 8f 43 01 00 | fa 43 01 00 26 00 00 00 |.....C..|.C..&...|
|00005910| 20 1c 80 06 00 80 00 00 | 1a 00 90 52 98 80 06 00 | .......|...R....|
|00005920| 82 ff 00 00 00 30 00 00 | 00 09 00 00 00 d1 43 01 |.....0..|......C.|
|00005930| 00 2a 44 01 00 27 00 00 | 00 20 1e 80 12 00 80 00 |.*D..'..|. ......|
|00005940| 00 1e 00 98 8c 52 98 80 | 07 00 82 ff 00 53 79 6e |.....R..|.....Syn|
|00005950| 74 61 78 00 00 c8 01 00 | 00 2e 01 00 00 fa 43 01 |tax.....|......C.|
|00005960| 00 f2 45 01 00 9a 00 00 | 00 20 02 81 5d 02 00 80 |..E.....|. ..]...|
|00005970| 00 00 1a 00 90 52 98 80 | 04 00 80 09 00 80 04 00 |.....R..|........|
|00005980| 80 09 00 80 04 00 80 09 | 00 80 04 00 80 09 00 80 |........|........|
|00005990| 04 00 82 80 09 00 80 04 | 00 80 09 00 80 04 00 80 |........|........|
|000059a0| 09 00 80 04 00 80 09 00 | 80 04 00 82 80 09 00 80 |........|........|
|000059b0| 04 00 80 09 00 80 04 00 | 80 09 00 80 04 00 80 09 |........|........|
|000059c0| 00 80 04 00 82 80 09 00 | 80 04 00 82 82 80 09 00 |........|........|
|000059d0| 80 04 00 80 09 00 80 04 | 00 80 09 00 80 04 00 80 |........|........|
|000059e0| 09 00 80 04 00 82 80 09 | 00 80 04 00 82 82 ff 00 |........|........|
|000059f0| 44 45 4c 45 54 45 20 5b | 5b 00 64 61 74 61 62 61 |DELETE [|[.databa|
|00005a00| 73 65 2e 00 5d 00 6f 77 | 6e 65 72 2e 00 5d 7b 00 |se..].ow|ner..]{.|
|00005a10| 74 61 62 6c 65 5f 6e 61 | 6d 65 00 20 7c 20 00 76 |table_na|me. | .v|
|00005a20| 69 65 77 5f 6e 61 6d 65 | 00 7d 00 5b 46 52 4f 4d |iew_name|.}.[FROM|
|00005a30| 20 5b 00 64 61 74 61 62 | 61 73 65 2e 00 5d 00 6f | [.datab|ase..].o|
|00005a40| 77 6e 65 72 2e 00 5d 7b | 00 74 61 62 6c 65 5f 6e |wner..]{|.table_n|
|00005a50| 61 6d 65 00 20 7c 20 00 | 76 69 65 77 5f 6e 61 6d |ame. | .|view_nam|
|00005a60| 65 00 7d 00 5b 2c 20 5b | 5b 00 64 61 74 61 62 61 |e.}.[, [|[.databa|
|00005a70| 73 65 2e 00 5d 00 6f 77 | 6e 65 72 2e 00 5d 7b 00 |se..].ow|ner..]{.|
|00005a80| 74 61 62 6c 65 5f 6e 61 | 6d 65 00 20 7c 20 00 76 |table_na|me. | .v|
|00005a90| 69 65 77 5f 6e 61 6d 65 | 00 7d 5d 2e 2e 2e 5d 00 |iew_name|.}]...].|
|00005aa0| 5b 57 48 45 52 45 20 00 | 73 65 61 72 63 68 5f 63 |[WHERE .|search_c|
|00005ab0| 6f 6e 64 69 74 69 6f 6e | 73 00 5d 00 00 44 45 4c |ondition|s.]..DEL|
|00005ac0| 45 54 45 20 5b 46 52 4f | 4d 5d 20 5b 5b 00 64 61 |ETE [FRO|M] [[.da|
|00005ad0| 74 61 62 61 73 65 2e 00 | 5d 00 6f 77 6e 65 72 2e |tabase..|].owner.|
|00005ae0| 00 5d 7b 00 74 61 62 6c | 65 5f 6e 61 6d 65 00 20 |.]{.tabl|e_name. |
|00005af0| 7c 20 00 76 69 65 77 5f | 6e 61 6d 65 00 7d 00 5b || .view_|name.}.[|
|00005b00| 57 48 45 52 45 20 00 73 | 65 61 72 63 68 5f 63 6f |WHERE .s|earch_co|
|00005b10| 6e 64 69 74 69 6f 6e 73 | 00 5d 00 00 00 3a 00 00 |nditions|.]...:..|
|00005b20| 00 09 00 00 00 2a 44 01 | 00 2c 46 01 00 31 00 00 |.....*D.|.,F..1..|
|00005b30| 00 02 75 01 00 00 ff ff | ff ff ff ff ff ff 1f 00 |..u.....|........|
|00005b40| 00 00 2c 46 01 00 ec 46 | 01 00 30 48 01 00 44 69 |..,F...F|..0H..Di|
|00005b50| 73 6b 20 49 6e 69 74 33 | 00 00 00 0c 00 00 00 f2 |sk Init3|........|
|00005b60| 45 01 00 5f 46 01 00 27 | 00 00 00 20 1e 80 18 00 |E.._F..'|... ....|
|00005b70| 80 00 00 1e 00 b8 98 42 | 98 80 03 00 82 ff 00 44 |.......B|.......D|
|00005b80| 49 53 4b 20 49 4e 49 54 | 00 00 64 00 00 00 3f 00 |ISK INIT|..d...?.|
|00005b90| 00 00 2c 46 01 00 c3 46 | 01 00 25 00 00 00 20 1a |..,F...F|..%... .|
|00005ba0| 80 7e 00 80 00 00 18 00 | 52 98 80 04 00 82 ff 00 |.~......|R.......|
|00005bb0| 52 65 73 65 72 76 65 73 | 20 61 6e 64 20 66 6f 72 |Reserves| and for|
|00005bc0| 6d 61 74 73 20 70 68 79 | 73 69 63 61 6c 20 73 74 |mats phy|sical st|
|00005bd0| 6f 72 61 67 65 20 66 6f | 72 20 61 20 64 61 74 61 |orage fo|r a data|
|00005be0| 62 61 73 65 20 64 65 76 | 69 63 65 2e 00 00 29 00 |base dev|ice...).|
|00005bf0| 00 00 03 00 00 00 5f 46 | 01 00 ec 46 01 00 26 00 |......_F|...F..&.|
|00005c00| 00 00 20 1c 80 06 00 80 | 00 00 1a 00 90 52 98 80 |.. .....|.....R..|
|00005c10| 06 00 82 ff 00 00 00 30 | 00 00 00 09 00 00 00 c3 |.......0|........|
|00005c20| 46 01 00 1c 47 01 00 27 | 00 00 00 20 1e 80 12 00 |F...G..'|... ....|
|00005c30| 80 00 00 1e 00 98 8c 52 | 98 80 07 00 82 ff 00 53 |.......R|.......S|
|00005c40| 79 6e 74 61 78 00 00 14 | 01 00 00 c3 00 00 00 ec |yntax...|........|
|00005c50| 46 01 00 30 48 01 00 51 | 00 00 00 20 70 80 87 01 |F..0H..Q|... p...|
|00005c60| 00 80 00 00 1a 00 90 52 | 98 80 04 00 80 09 00 80 |.......R|........|
|00005c70| 04 00 82 80 09 00 80 04 | 00 82 80 09 00 80 04 00 |........|........|
|00005c80| 82 80 09 00 80 04 00 82 | 80 09 00 80 04 00 82 80 |........|........|
|00005c90| 09 00 80 04 00 82 82 ff | 00 44 49 53 4b 20 49 4e |........|.DISK IN|
|00005ca0| 49 54 20 4e 41 4d 45 20 | 3d 20 00 27 6c 6f 67 69 |IT NAME |= .'logi|
|00005cb0| 63 61 6c 5f 6e 61 6d 65 | 27 00 2c 00 50 48 59 53 |cal_name|'.,.PHYS|
|00005cc0| 4e 41 4d 45 20 3d 20 00 | 27 70 68 79 73 69 63 61 |NAME = .|'physica|
|00005cd0| 6c 5f 6e 61 6d 65 27 00 | 2c 00 56 44 45 56 4e 4f |l_name'.|,.VDEVNO|
|00005ce0| 20 3d 20 00 76 69 72 74 | 75 61 6c 5f 64 65 76 69 | = .virt|ual_devi|
|00005cf0| 63 65 5f 6e 75 6d 62 65 | 72 00 2c 00 53 49 5a 45 |ce_numbe|r.,.SIZE|
|00005d00| 20 3d 20 00 6e 75 6d 62 | 65 72 5f 6f 66 5f 32 4b | = .numb|er_of_2K|
|00005d10| 5f 62 6c 6f 63 6b 73 00 | 00 5b 2c 20 56 53 54 41 |_blocks.|.[, VSTA|
|00005d20| 52 54 20 3d 20 00 76 69 | 72 74 75 61 6c 5f 61 64 |RT = .vi|rtual_ad|
|00005d30| 64 72 65 73 73 00 2c 00 | 43 4e 54 52 4c 54 59 50 |dress.,.|CNTRLTYP|
|00005d40| 45 20 3d 20 00 63 6f 6e | 74 72 6f 6c 6c 65 72 5f |E = .con|troller_|
|00005d50| 6e 75 6d 62 65 72 00 5d | 00 00 00 3c 00 00 00 0b |number.]|...<....|
|00005d60| 00 00 00 1c 47 01 00 6c | 48 01 00 31 00 00 00 02 |....G..l|H..1....|
|00005d70| fb 00 00 00 ff ff ff ff | ff ff ff ff 20 00 00 00 |........|.... ...|
|00005d80| 6c 48 01 00 bb 49 01 00 | 85 4a 01 00 44 69 73 6b |lH...I..|.J..Disk|
|00005d90| 20 4d 69 72 72 6f 72 35 | 00 00 00 0e 00 00 00 30 | Mirror5|.......0|
|00005da0| 48 01 00 a1 48 01 00 27 | 00 00 00 20 1e 80 1c 00 |H...H..'|... ....|
|00005db0| 80 00 00 1e 00 b8 98 42 | 98 80 03 00 82 ff 00 44 |.......B|.......D|
|00005dc0| 49 53 4b 20 4d 49 52 52 | 4f 52 00 00 f1 00 00 00 |ISK MIRR|OR......|
|00005dd0| cb 00 00 00 6c 48 01 00 | 92 49 01 00 26 00 00 00 |....lH..|.I..&...|
|00005de0| 20 1a 80 97 01 00 80 00 | 00 18 00 52 98 80 04 00 | .......|...R....|
|00005df0| 82 ff 00 43 72 65 61 74 | 65 73 20 61 20 73 6f 66 |...Creat|es a sof|
|00005e00| 74 77 61 72 65 20 6d 69 | 72 72 6f 72 20 6f 66 20 |tware mi|rror of |
|00005e10| 61 20 75 73 65 72 20 64 | 61 74 61 62 61 73 65 20 |a user d|atabase |
|00005e20| 64 65 76 69 63 65 2c 20 | 74 68 65 20 4d 41 53 54 |device, |the MAST|
|00005e30| 45 52 20 64 61 74 61 62 | 61 73 65 20 64 65 76 69 |ER datab|ase devi|
|00005e40| 63 65 2c 20 6f 72 20 61 | 20 64 61 74 61 62 61 73 |ce, or a| databas|
|00005e50| 65 20 64 65 76 69 63 65 | 20 66 6f 72 20 75 73 65 |e device| for use|
|00005e60| 72 20 64 61 74 61 62 61 | 73 65 20 74 72 61 6e 73 |r databa|se trans|
|00005e70| 61 63 74 69 6f 6e 20 6c | 6f 67 73 2e 20 49 66 20 |action l|ogs. If |
|00005e80| 61 20 64 61 74 61 62 61 | 73 65 20 64 65 76 69 63 |a databa|se devic|
|00005e90| 65 20 66 61 69 6c 73 2c | 20 69 74 73 20 6d 69 72 |e fails,| its mir|
|00005ea0| 72 6f 72 20 69 6d 6d 65 | 64 69 61 74 65 6c 79 20 |ror imme|diately |
|00005eb0| 74 61 6b 65 73 20 6f 76 | 65 72 2e 00 00 29 00 00 |takes ov|er...)..|
|00005ec0| 00 03 00 00 00 a1 48 01 | 00 bb 49 01 00 26 00 00 |......H.|..I..&..|
|00005ed0| 00 20 1c 80 06 00 80 00 | 00 1a 00 90 52 98 80 06 |. ......|....R...|
|00005ee0| 00 82 ff 00 00 00 30 00 | 00 00 09 00 00 00 92 49 |......0.|.......I|
|00005ef0| 01 00 eb 49 01 00 27 00 | 00 00 20 1e 80 12 00 80 |...I..'.|.. .....|
|00005f00| 00 00 1e 00 98 8c 52 98 | 80 07 00 82 ff 00 53 79 |......R.|......Sy|
|00005f10| 6e 74 61 78 00 00 9a 00 | 00 00 64 00 00 00 bb 49 |ntax....|..d....I|
|00005f20| 01 00 85 4a 01 00 36 00 | 00 00 20 3c 80 c8 00 80 |...J..6.|.. <....|
|00005f30| 00 00 1a 00 90 52 98 80 | 04 00 82 80 09 00 80 04 |.....R..|........|
|00005f40| 00 82 80 09 00 80 04 00 | 82 82 82 ff 00 44 49 53 |........|.....DIS|
|00005f50| 4b 20 4d 49 52 52 4f 52 | 00 4e 41 4d 45 20 3d 20 |K MIRROR|.NAME = |
|00005f60| 00 27 6c 6f 67 69 63 61 | 6c 5f 6e 61 6d 65 27 00 |.'logica|l_name'.|
|00005f70| 2c 00 4d 49 52 52 4f 52 | 20 3d 20 00 70 68 79 73 |,.MIRROR| = .phys|
|00005f80| 69 63 61 6c 5f 6e 61 6d | 65 27 00 20 00 5b 2c 20 |ical_nam|e'. .[, |
|00005f90| 57 52 49 54 45 53 20 3d | 20 7b 53 45 52 49 41 4c |WRITES =| {SERIAL|
|00005fa0| 20 7c 20 4e 4f 53 45 52 | 49 41 4c 7d 5d 00 00 00 | | NOSER|IAL}]...|
|00005fb0| 3b 00 00 00 0a 00 00 00 | eb 49 01 00 c0 4a 01 00 |;.......|.I...J..|
|00005fc0| 31 00 00 00 02 96 00 00 | 00 ff ff ff ff ff ff ff |1.......|........|
|00005fd0| ff 21 00 00 00 c0 4a 01 | 00 80 4b 01 00 e5 4b 01 |.!....J.|..K...K.|
|00005fe0| 00 44 69 73 6b 20 52 65 | 66 69 74 34 00 00 00 0d |.Disk Re|fit4....|
|00005ff0| 00 00 00 85 4a 01 00 f4 | 4a 01 00 27 00 00 00 20 |....J...|J..'... |
|00006000| 1e 80 1a 00 80 00 00 1e | 00 b8 98 42 98 80 03 00 |........|...B....|
|00006010| 82 ff 00 44 49 53 4b 20 | 52 45 46 49 54 00 00 63 |...DISK |REFIT..c|
|00006020| 00 00 00 3e 00 00 00 c0 | 4a 01 00 57 4b 01 00 25 |...>....|J..WK..%|
|00006030| 00 00 00 20 1a 80 7c 00 | 80 00 00 18 00 52 98 80 |... ..|.|.....R..|
|00006040| 04 00 82 ff 00 52 65 73 | 74 6f 72 65 73 20 61 20 |.....Res|tores a |
|00006050| 64 61 6d 61 67 65 64 20 | 4d 61 73 74 65 72 20 64 |damaged |Master d|
|00006060| 61 74 61 62 61 73 65 2e | 20 55 73 65 64 20 61 66 |atabase.| Used af|
|00006070| 74 65 72 20 44 49 53 4b | 20 52 45 49 4e 49 54 2e |ter DISK| REINIT.|
|00006080| 00 00 29 00 00 00 03 00 | 00 00 f4 4a 01 00 80 4b |..).....|...J...K|
|00006090| 01 00 26 00 00 00 20 1c | 80 06 00 80 00 00 1a 00 |..&... .|........|
|000060a0| 90 52 98 80 06 00 82 ff | 00 00 00 30 00 00 00 09 |.R......|...0....|
|000060b0| 00 00 00 57 4b 01 00 b0 | 4b 01 00 27 00 00 00 20 |...WK...|K..'... |
|000060c0| 1e 80 12 00 80 00 00 1e | 00 98 8c 52 98 80 07 00 |........|...R....|
|000060d0| 82 ff 00 53 79 6e 74 61 | 78 00 00 35 00 00 00 0e |...Synta|x..5....|
|000060e0| 00 00 00 80 4b 01 00 e5 | 4b 01 00 27 00 00 00 20 |....K...|K..'... |
|000060f0| 1e 80 1c 00 80 00 00 1a | 00 90 52 98 80 04 00 82 |........|..R.....|
|00006100| 82 ff 00 44 49 53 4b 20 | 52 45 46 49 54 00 00 00 |...DISK |REFIT...|
|00006110| 3c 00 00 00 0b 00 00 00 | b0 4b 01 00 21 4c 01 00 |<.......|.K..!L..|
|00006120| 31 00 00 00 02 78 01 00 | 00 ff ff ff ff ff ff ff |1....x..|........|
|00006130| ff 22 00 00 00 21 4c 01 | 00 e5 4c 01 00 2c 4e 01 |."...!L.|..L..,N.|
|00006140| 00 44 69 73 6b 20 52 65 | 69 6e 69 74 35 00 00 00 |.Disk Re|init5...|
|00006150| 0e 00 00 00 e5 4b 01 00 | 56 4c 01 00 27 00 00 00 |.....K..|VL..'...|
|00006160| 20 1e 80 1c 00 80 00 00 | 1e 00 b8 98 42 98 80 03 | .......|....B...|
|00006170| 00 82 ff 00 44 49 53 4b | 20 52 45 49 4e 49 54 00 |....DISK| REINIT.|
|00006180| 00 66 00 00 00 41 00 00 | 00 21 4c 01 00 bc 4c 01 |.f...A..|.!L...L.|
|00006190| 00 25 00 00 00 20 1a 80 | 82 00 80 00 00 18 00 52 |.%... ..|.......R|
|000061a0| 98 80 04 00 82 ff 00 50 | 61 72 74 20 6f 66 20 74 |.......P|art of t|
|000061b0| 68 65 20 70 72 6f 63 65 | 64 75 72 65 20 74 68 61 |he proce|dure tha|
|000061c0| 74 20 72 65 73 74 6f 72 | 65 73 20 61 20 64 61 6d |t restor|es a dam|
|000061d0| 61 67 65 64 20 4d 61 73 | 74 65 72 20 64 61 74 61 |aged Mas|ter data|
|000061e0| 62 61 73 65 2e 00 00 29 | 00 00 00 03 00 00 00 56 |base...)|.......V|
|000061f0| 4c 01 00 e5 4c 01 00 26 | 00 00 00 20 1c 80 06 00 |L...L..&|... ....|
|00006200| 80 00 00 1a 00 90 52 98 | 80 06 00 82 ff 00 00 00 |......R.|........|
|00006210| 30 00 00 00 09 00 00 00 | bc 4c 01 00 15 4d 01 00 |0.......|.L...M..|
|00006220| 27 00 00 00 20 1e 80 12 | 00 80 00 00 1e 00 98 8c |'... ...|........|
|00006230| 52 98 80 07 00 82 ff 00 | 53 79 6e 74 61 78 00 00 |R.......|Syntax..|
|00006240| 17 01 00 00 c5 00 00 00 | e5 4c 01 00 2c 4e 01 00 |........|.L..,N..|
|00006250| 52 00 00 00 20 72 80 8b | 01 00 80 00 00 1a 00 90 |R... r..|........|
|00006260| 52 98 80 04 00 82 80 09 | 00 80 04 00 82 80 09 00 |R.......|........|
|00006270| 80 04 00 82 80 09 00 80 | 04 00 82 80 09 00 80 04 |........|........|
|00006280| 00 82 80 09 00 80 04 00 | 82 80 09 00 80 04 00 82 |........|........|
|00006290| 82 ff 00 44 49 53 4b 20 | 52 45 49 4e 49 54 00 4e |...DISK |REINIT.N|
|000062a0| 41 4d 45 20 3d 20 00 27 | 6c 6f 67 69 63 61 6c 5f |AME = .'|logical_|
|000062b0| 6e 61 6d 65 27 00 2c 00 | 50 48 59 53 4e 41 4d 45 |name'.,.|PHYSNAME|
|000062c0| 20 3d 20 00 27 70 68 79 | 73 69 63 61 6c 5f 6e 61 | = .'phy|sical_na|
|000062d0| 6d 65 27 00 2c 00 56 44 | 45 56 4e 4f 20 3d 20 00 |me'.,.VD|EVNO = .|
|000062e0| 76 69 72 74 75 61 6c 5f | 64 65 76 69 63 65 5f 6e |virtual_|device_n|
|000062f0| 75 6d 62 65 72 00 2c 00 | 53 49 5a 45 20 3d 20 00 |umber.,.|SIZE = .|
|00006300| 6e 75 6d 62 65 72 5f 6f | 66 5f 32 4b 5f 62 6c 6f |number_o|f_2K_blo|
|00006310| 63 6b 73 00 00 5b 2c 20 | 56 53 54 41 52 54 20 3d |cks..[, |VSTART =|
|00006320| 20 00 76 69 72 74 75 61 | 6c 5f 61 64 64 72 65 73 | .virtua|l_addres|
|00006330| 73 00 2c 00 43 4e 54 52 | 4c 54 59 50 45 20 3d 20 |s.,.CNTR|LTYPE = |
|00006340| 00 63 6f 6e 74 72 6f 6c | 6c 65 72 5f 6e 75 6d 62 |.control|ler_numb|
|00006350| 65 72 00 5d 00 00 00 3e | 00 00 00 0d 00 00 00 15 |er.]...>|........|
|00006360| 4d 01 00 6a 4e 01 00 31 | 00 00 00 02 b8 00 00 00 |M..jN..1|........|
|00006370| ff ff ff ff ff ff ff ff | 23 00 00 00 6a 4e 01 00 |........|#...jN..|
|00006380| 23 4f 01 00 aa 4f 01 00 | 44 69 73 6b 20 52 65 6d |#O...O..|Disk Rem|
|00006390| 69 72 72 6f 72 37 00 00 | 00 10 00 00 00 2c 4e 01 |irror7..|.....,N.|
|000063a0| 00 a1 4e 01 00 27 00 00 | 00 20 1e 80 20 00 80 00 |..N..'..|. .. ...|
|000063b0| 00 1e 00 b8 98 42 98 80 | 03 00 82 ff 00 44 49 53 |.....B..|.....DIS|
|000063c0| 4b 20 52 45 4d 49 52 52 | 4f 52 00 00 59 00 00 00 |K REMIRR|OR..Y...|
|000063d0| 34 00 00 00 6a 4e 01 00 | fa 4e 01 00 25 00 00 00 |4...jN..|.N..%...|
|000063e0| 20 1a 80 68 00 80 00 00 | 18 00 52 98 80 04 00 82 | ..h....|..R.....|
|000063f0| ff 00 52 65 73 75 6d 65 | 73 20 73 6f 66 74 77 61 |..Resume|s softwa|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.