1<!DOCTYPE html> 2<html lang="ru-RU"> 3<head> 4<!-- Global site tag (gtag.js) - Google Analytics -->
5<script data-rocketlazyloadscript='https://www.googletagmanager.com/gtag/js?id=UA-139248612-1' async ></script>
vendor: 1 bytes, line 5
5
6<script data-rocketlazyloadscript='data:text/javascript;base64,CiAgd2luZG93LmRhdGFMYXllciA9IHdpbmRvdy5kYXRhTGF5ZXIgfHwgW107CiAgZnVuY3Rpb24gZ3RhZygpe2RhdGFMYXllci5wdXNoKGFyZ3VtZW50cyk7fQogIGd0YWcoJ2pzJywgbmV3IERhdGUoKSk7CiAgZ3RhZygnY29uZmlnJywgJ1VBLTEzOTI0ODYxMi0xJyk7Cg==' ></script>
6 7<meta charset="UTF-8" /> 8<meta name="viewport" content="width=device-width, initial-scale=1"> 9<meta name="viewport" content="width=device-width" /> 10<link rel="profile" href="http://gmpg.org/xfn/11" /> 11<link rel="pingback" href="https://oracleplsql.ru/xmlrpc.php" /> 12<!--[if lt IE 9]>
13<script src="https://oracleplsql.ru/wp-content/themes/f2/js/html5.js" type="text/javascript"></script>
13 14<![endif]--> 15
16<script data-rocketlazyloadscript='//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
vendor: 1 bytes, line 16
16
17<script> 18 (adsbygoogle = window.adsbygoogle || []).push({ 19 google_ad_client: "ca-pub-8777261894857145", 20 enable_page_level_ads: true 21 }); 22</script>
22 23 24<title>SQL Server ÑÑебник — Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite</title><link rel="stylesheet" href="https://fonts.googleapis.com/css?family=PT%20Serif%7CPrata%7CBitter%3A700%7CGudea%3A400%2C700%2C400italic&display=swap" /><link rel="stylesheet" href="https://oracleplsql.ru/wp-content/cache/min/1/e6cd45c7c83be6010c82e9b45c293d40.css" media="all" data-minify="1" /> 25<meta name='robots' content='max-image-preview:large' /> 26<link rel='dns-prefetch' href='//fonts.googleapis.com' /> 27<link href='https://fonts.gstatic.com' crossorigin rel='preconnect' /> 28<link rel="alternate" type="application/rss+xml" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite » ÐенÑа" href="https://oracleplsql.ru/feed" /> 29<link rel="alternate" type="application/rss+xml" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite » ÐенÑа комменÑаÑиев" href="https://oracleplsql.ru/comments/feed" /> 30<style id="wp-img-auto-sizes-contain-inline-css"> 31img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px} 32/*# sourceURL=wp-img-auto-sizes-contain-inline-css */ 33</style> 34 35<style id="wp-emoji-styles-inline-css"> 36 37 img.wp-smiley, img.emoji { 38 display: inline !important; 39 border: none !important; 40 box-shadow: none !important; 41 height: 1em !important; 42 width: 1em !important; 43 margin: 0 0.07em !important; 44 vertical-align: -0.1em !important; 45 background: none !important; 46 padding: 0 !important; 47 } 48/*# sourceURL=wp-emoji-styles-inline-css */ 49</style> 50<style id="wp-block-library-inline-css"> 51:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;
51--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap!important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal!important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px;word-break:normal!important}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 23px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style^=border-color],[style*=";border-color"],[style*="; border-color"]){border-style:solid}html :where([style^=border-top-color],[style*=";border-top-color"],[style*="; border-top-color"]){border-top-style:solid}html :where([style^=border-right-color],[style*=";border-right-color"],[style*="; border-right-color"]){border-right-style:solid}html :where([style^=border-bottom-color],[style*=";border-bottom-color"],[style*="; border-bottom-color"]){border-bottom-style:solid}html :where([style^=border-left-color],[style*=";border-left-color"],[style*="; border-left-color"]){border-left-style:solid}html :where([style^=border-width],[style*=";border-width"],[style*="; border-width"]){border-style:solid}html :where([style^=border-top-width],[style*=";border-top-width"],[style*="; border-top-width"]){border-top-style:solid}html :where([style^=border-right-width],[style*=";border-right-width"],[style*="; border-right-width"]){border-right-style:solid}html :where([style^=border-bottom-width],[style*=";border-bottom-width"],[style*="; border-bottom-width"]){border-bottom-style:solid}html :where([style^=border-left-width],[style*=";border-left-width"],[style*="; border-left-width"]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 0 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}} 52 53/*# sourceURL=/wp-includes/css/dist/block-library/common.min.css */ 54</style> 55<style id="classic-theme-styles-inline-css"> 56/*! This file is auto-generated */ 57.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} 58/*# sourceURL=/wp-includes/css/classic-themes.min.css */ 59</style> 60 61<style id="global-styles-inline-css"> 62:root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #ffffff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgb(6,147,227) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgb(252,185,
620) 0%,rgb(255,105,0) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgb(255,105,0) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgb(255, 255, 255), 6px 6px rgb(0, 0, 0);--wp--preset--shadow--crisp: 6px 6px 0px rgb(0, 0, 0);}.wp-block-button{--wp--preset--dimension--25: 25%;--wp--preset--dimension--50: 50%;--wp--preset--dimension--75: 75%;--wp--preset--dimension--100: 100%;}:where(body) { margin: 0; }:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}body{padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}:root :where(.wp-element-button, .wp-block-button__link){background-color: #32373c;border-width: 0;color: #fff;font-family: inherit;font-size: inherit;font-style: inherit;font-weight: inherit;letter-spacing: inherit;line-height: inherit;padding-top: calc(0.667em + 2px);padding-right: calc(1.333em + 2px);padding-bottom: calc(0.667em + 2px);padding-left: calc(1.333em + 2px);text-decoration: none;text-transform: inherit;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}
62.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;} 63/*# sourceURL=global-styles-inline-css */ 64</style> 65 66 67 68<link rel='stylesheet' id='print-css' href='https://oracleplsql.ru/wp-content/themes/f2/print.css?ver=2.2.3' media='print' />
69<script id="jquery-core-js" src="https://oracleplsql.ru/wp-includes/js/jquery/jquery.min.js?ver=3.7.1" defer></script>
69 70
71<script id="crayon_js-js-extra"> 72var CrayonSyntaxSettings = {"version":"_2.7.2_beta","is_admin":"0","ajaxurl":"https://oracleplsql.ru/wp-admin/admin-ajax.php","prefix":"crayon-","setting":"crayon-setting","selected":"crayon-setting-selected","changed":"crayon-setting-changed","special":"crayon-setting-special","orig_value":"data-orig-value","debug":""}; 73var CrayonSyntaxStrings = {"copy":"Press %s to Copy, %s to Paste","minimize":"Click To Expand Code"}; 74//# sourceURL=crayon_js-js-extra 75</script>
75 76 77<link rel="https://api.w.org/" href="https://oracleplsql.ru/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://oracleplsql.ru/wp-json/wp/v2/posts/7347" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://oracleplsql.ru/xmlrpc.php?rsd" /> 78<meta name="generator" content="WordPress 7.1.2" /> 79<link rel='shortlink' href='https://oracleplsql.ru/?p=7347' /> 80<!-- Customized F2 styles --> 81<style type="text/css"> 82/*div frontpage*/ 83 84/*div{display:box}*/ 85.row{margin-right:-10px;margin-left:-10px;} 86 87.col-md-4, .col-xs-6, .col-sm-4{ 88 float: left; 89 min-height:1px; 90 position:relative;} 91 92.list-grp { 93 border:0; 94 border-radius:0; 95 box-shadow:0 0 0; 96 margin:0;} 97.list-grp { 98 margin-bottom:20px; 99 padding-left:0; 100} 101 102.list-grp a { 103 border-radius:0; 104} 105 106.list-grp-itm { 107 background-color:#FFFFFF; 108 border:1px solid #DDDDDD; 109 display:block; 110 margin-bottom:-1px; 111 padding:5px 20px; 112 position:relative; 113} 114.list-grp-itm:first-child { 115 border-top-left-radius:4px; 116 border-top-right-radius:4px; 117} 118/*END div frontpage*/ 119.sintax{ 120 background:#EEEEEE; 121 border:1px solid #E6E6E6; 122 border-radius:5px; 123 box-shadow:#6D97B7 1px 1px 1px; 124 border-collapse:collapse; 125 border-spacing:0; 126 font-family:Consolas, 'Courier New', Courier, monospace; 127 font-size:1em; 128 margin:0 0 20px; 129 padding:5px; 130 white-space:pre-wrap; 131 word-wrap:break-word; 132} 133.arg{ 134 background:#EEEEEE; 135 border:1px solid #E6E6E6; 136 border-radius:4px; 137 box-shadow:#6D97B7 1px 1px 1px; 138 padding-right:1px; 139 padding-left:1px; 140} 141 142.crayon-syntax{border-radius:4px;box-shadow:#6D97B7 1px 1px 1px;} 143 144/*.tbfunc td{width:33%;}*/ 145 146 147li.list{background:none;} 148 149.rel_1, .rel_2 {float:left;position:relative;width:45.3%;background-color:#fff;} 150/*.rel_2 {float:left;position:relative;width:45.3%;background-color:#fff;}*/ 151 152.gt_ct{margin-top:10px;display:block;} 153 154#text-2{margin-left:6.6rem;display:block;} 155 156/*.entry-content p {font-family: 'PT Serif Caption', serif;}*/ 157.list-grp-itm, .menu-item, .entry-content p {font-family: 'PT Serif', serif;} 158 159/*google search*/ 160 161input.gsc-input, .gsc-input-box, .gsc-input-box-hover, .gsc-input-box-focus { 162 height:3.2rem; 163} 164 165table.gsc-search-box, 166.gsc-search-box td, 167.gsc-search-box tr, 168.gsc-input-box tr, 169.gsc-input-box td{ 170border-style: none; 171box-shadow: none; 172-moz-box-shadow: none; 173-webkit-box-shadow: none; 174} 175 176/* ââ GOOGLE CSE ÐÐÐСРââ */ 177 178/* ÐбÑÑÑка виджеÑа */ 179.widget .gsc-search-box, 180.widget .gsc-input-box, 181.gcse-search, 182.gcse-searchbox { 183 border: none !important; 184 box-shadow: none !important; 185 padding: 0 !important; 186 background: transparent !important; 187} 188 189/* Само поле ввода */ 190.widget input.gsc-input, 191input.gsc-input, 192.gsc-input-box input[type="text"] { 193 background: #fff !important; 194 /* border: 1.5px solid #dde3ec !important;*/ 195 border-radius: 8px !important; 196/* box-shadow: 0 1px 4px rgba(0,0,0,.06) !important;*/ 197 padding: 8px 12px 8px 38px !important; 198 font-family: 'Inter', sans-serif !important; 199 font-size: 1.35rem !important; 200 color: #1a2535 !important; 201 width: 97% !important; 202 height: auto !important; 203 transition: border-color .15s, box-shadow .15s !important; 204 outline: none !important; 205} 206 207.widget input.gsc-input:focus, 208input.gsc-input:focus { 209 border-color: #1a5296 !important; 210 box-shadow: 0 0 0 3px rgba(26,82,150,.12) !important; 211} 212 213/* УбиÑаем Ñон-ÑаблиÑÑ ÐºÐ¾ÑоÑÑÑ ÑиÑÑÐµÑ Google */ 214.gsc-input-box { 215 background: transparent !important; 216 border: none !important; 217 padding: 0 !important; 218} 219 220table.gsc-search-box, 221table.gsc-search-box td { 222 border: none !important; 223 padding: 0 !important; 224 margin: 0 !important; 225 background: transparent !important; 226} 227 228/* Ðнопка поиÑка â ÑкÑÑваем ÑÑандаÑÑнÑÑ Google */ 229.widget .gsc-search-button, 230.gsc-search-button { 231 display: none !important; 232} 233 234/* Ðконка лÑÐ¿Ñ ÑеÑез CSS (пÑевдоÑÐ»ÐµÐ¼ÐµÐ½Ñ Ð½Ð° обÑÑÑке) */ 235.widget .gsc-input-box-hover, 236.widget .gsc-input-box { 237 position: relative !important; 238} 239 240.widget .gsc-input-box::before { 241 content: ''; 242 display: block; 243 position: absolute; 244 left: 12px; 245 top: 50%; 246 transform: translateY(-50%); 247 width: 16px; 248 height: 16px; 249 background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='16' height='16' viewB
249ox='0 0 24 24' fill='none' stroke='%236b7a90' stroke-width='2' stroke-linecap='round' stroke-linejoin='round'%3E%3Ccircle cx='11' cy='11' r='8'/%3E%3Cline x1='21' y1='21' x2='16.65' y2='16.65'/%3E%3C/svg%3E"); 250 background-repeat: no-repeat; 251 background-size: contain; 252 pointer-events: none; 253 z-index: 1; 254} 255 256/* РезÑлÑÑаÑÑ Ð¿Ð¾Ð¸Ñка */ 257.gsc-results-wrapper-overlay { 258 border-radius: 8px !important; 259 box-shadow: 0 8px 24px rgba(0,0,0,.15) !important; 260} 261 262.gsc-result { 263 border-bottom: 1px solid #dde3ec !important; 264 padding: 12px 0 !important; 265} 266 267.gs-title, .gs-title * { 268 color: #1a5296 !important; 269 font-family: 'Inter', sans-serif !important; 270 font-size: 1.4rem !important; 271} 272 273.gs-snippet { 274 color: #445566 !important; 275 font-family: 'Inter', sans-serif !important; 276 font-size: 1.3rem !important; 277}</style> 278<link rel="icon" href="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" sizes="32x32" /> 279<link rel="icon" href="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" sizes="192x192" /> 280<link rel="apple-touch-icon" href="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" /> 281<meta name="msapplication-TileImage" content="https://oracleplsql.ru/wp-content/uploads/2020/07/favicon.ico" /> 282<noscript><style id="rocket-lazyload-nojs-css">.rll-youtube-player, [data-lazy-src]{display:none !important;}</style></noscript></head> 283 284<body class="wp-singular post-template-default single single-post postid-7347 single-format-standard wp-theme-f2 one-sidebar-left medium-sidebar large-font-sidebar large-font-content"> 285 <amp-auto-ads type="adsense" 286 data-ad-client="ca-pub-8777261894857145"> 287</amp-auto-ads> 288<div style="display:table;margin: 0 auto;"> 289<!-- orclplsql_adapt_mobile_top --> 290<style type="text/css"> 291.mob_top { width: 320px; height: 100px; } 292@media (min-width:500px) { .mob_top { width: 468px; height: 60px; } } 293@media (min-width:800px) { .mob_top { width: 728px; height: 90px; } } 294</style> 295<ins class="adsbygoogle mob_top" 296 style="display:inline-block;" 297 data-full-width-responsive="true" 298 data-ad-client="ca-pub-8777261894857145" 299 data-ad-slot="8026856126" 300 data-full-width-responsive="true"></ins>
301<script data-rocketlazyloadscript='https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
301
302<script> 303 (adsbygoogle = window.adsbygoogle || []).push({}); 304</script>
304 305</div> 306<div id="page" class="hfeed site"> 307 <header id="masthead" class="site-header" role="banner"> 308 <div class="site-branding"> 309 <h1 class="site-title"><a href="https://oracleplsql.ru/" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite" rel="home">Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite</a></h1> 310 <h2 class="site-description">ÐÐ°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ </h2> 311 </div><!-- .site-branding --> 312 313 <nav role="navigation" class="site-navigation main-navigation"> 314 <h1 class="assistive-text">Menu</h1> 315 <div class="assistive-text skip-link"><a href="#content" title="Skip to content">Skip to content</a></div> 316 317 <div class="menu-sql-container"><ul id="menu-sql" class="menu"><li id="menu-item-2533" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2533"><a href="https://oracleplsql.ru/sql-language.html">SQL</a></li> 318<li id="menu-item-7341" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7341"><a href="https://oracleplsql.ru/contents-oracle-plsql.html">Oracle PL/SQL</a></li> 319<li id="menu-item-3192" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3192"><a href="https://oracleplsql.ru/mysql-manual.html">MySQL</a></li> 320<li id="menu-item-7342" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-item menu-item-7342"><a href="https://oracleplsql.ru/contents-sql-server.html" aria-current="page">SQL Server</a></li> 321<li id="menu-item-7343" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7343"><a href="https://oracleplsql.ru/sqlite-manual.html">SQLite</a></li> 322<li id="menu-item-6422" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-6422"><a href="https://oracleplsql.ru/postgresql-manual.html">PostgreSQL</a></li> 323<li id="menu-item-7201" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7201"><a href="https://oracleplsql.ru/mariadb-manual.html">MariaDB</a></li> 324</ul></div> </nav><!-- .site-navigation .main-navigation --> 325 326 327 </header><!-- #masthead .site-header --> 328 329 <div id="main" class="site-main"> 330 <div id="primary" class="content-area"> 331 <div id="content" class="site-content" role="main"> 332 333 334 335<article id="post-7347" class="post-7347 post type-post status-publish format-standard hentry category-programming-sql-server"> 336 <header class="entry-header"> 337 <h1 class="entry-title">SQL Server ÑÑебник</h1> 338 <div class="entry-meta"> 339 <!-- --> 340 </div><!-- .entry-meta --> 341 </header><!-- .entry-header --> 342 343 <div class="entry-content"> 344 <h2>SQL Server ÑÑнкÑии</h2> 345<p><img decoding="async" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20300%2082'%3E%3C/svg%3E" alt="SQL Server" width="300" height="82" class="alignright size-medium wp-image-7723" data-lazy-src="https://oracleplsql.ru/wp-content/uploads/2019/06/sqlserver-300x82.png" /><noscript><img decoding="async" src="https://oracleplsql.ru/wp-content/uploads/2019/06/sqlserver-300x82.png" alt="SQL Server" width="300" height="82" class="alignright size-medium wp-image-7723" /></noscript></p> 346<ul> 347<li><a href="https://oracleplsql.ru/date-time-function-sql-server.html">ÐаÑа / вÑемÑ</a></li> 348<li><a href="https://oracleplsql.ru/advanced-function-sql-server.html">ÐополниÑелÑнÑе</a></li> 349<li><a href="https://oracleplsql.ru/string-char-functions-sql-server.html">СимволÑнÑе / ÑÑÑоÑнÑе</a></li> 350<li><a href="https://oracleplsql.ru/conversion-functions-sql-server.html">ÐÑеобÑазованиÑ</a></li> 351<li><a href="https://oracleplsql.ru/numeric-mathematical-functions-sql-server.html">ЧиÑловÑе / маÑемаÑиÑеÑкие</a></li> 352</ul> 353<h3>SQL Server ÑÐ¸Ð¿Ñ Ð´Ð°Ð½Ð½ÑÑ </h3> 354<p><a href="https://oracleplsql.ru/data-types-sql-server.html">Ð¢Ð¸Ð¿Ñ Ð´Ð°Ð½Ð½ÑÑ </a></p> 355<h2>SQL Server ÑÐ¸Ð¿Ñ Ð·Ð°Ð¿ÑоÑов</h2> 356<table> 357<tbody> 358<tr> 359<td><a href="https://oracleplsql.ru/select-sql-server.html">SELECT</a></td> 360<td>ÐпеÑаÑÐ¾Ñ SELECT</td> 361</tr> 362<tr> 363<td><a href="https://oracleplsql.ru/select-top-sql-server.html">SELECT TOP</a></td> 364<td>ÐпеÑаÑÐ¾Ñ SELECT TOP</td> 365</tr> 366<tr> 367<td><a href="https://oracleplsql.ru/select-into-sql-server.html">
367SELECT INTO</a></td> 368<td>ÐпеÑаÑÐ¾Ñ SELECT INTO</td> 369</tr> 370<tr> 371<td><a href="https://oracleplsql.ru/distinct-sql-server.html">DISTINCT</a></td> 372<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ ÑÐ´Ð°Ð»ÐµÐ½Ð¸Ñ Ð´ÑбликаÑов из набоÑа ÑезÑлÑÑаÑов</td> 373</tr> 374<tr> 375<td><a href="https://oracleplsql.ru/from-sql-server.html">FROM</a></td> 376<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ Ð¾ÑобÑÐ°Ð¶ÐµÐ½Ð¸Ñ ÑÐ°Ð±Ð»Ð¸Ñ Ð¸ лÑбÑÑ Ð¾Ð±Ñединений</td> 377</tr> 378<tr> 379<td><a href="https://oracleplsql.ru/where-sql-server.html">WHERE</a></td> 380<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ ÑилÑÑÑаÑии ÑезÑлÑÑаÑов</td> 381</tr> 382<tr> 383<td><a href="https://oracleplsql.ru/order-by-sql-server.html">ORDER BY</a></td> 384<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ ÑоÑÑиÑовки ÑезÑлÑÑаÑов</td> 385</tr> 386<tr> 387<td><a href="https://oracleplsql.ru/group-by-sql-server.html">GROUP BY</a></td> 388<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ Ð³ÑÑппиÑовки ÑезÑлÑÑаÑов</td> 389</tr> 390<tr> 391<td><a href="https://oracleplsql.ru/having-sql-server.html">HAVING</a></td> 392<td>ÐÑполÑзÑеÑÑÑ Ð² ÑоÑеÑании Ñ Ð¾Ð¿ÐµÑаÑоÑом GROUP BY, ÑÑÐ¾Ð±Ñ Ð¾Ð³ÑаниÑиÑÑ Ð³ÑÑÐ¿Ð¿Ñ Ð²Ð¾Ð·Ð²ÑаÑаемÑÑ ÑÑÑок ÑолÑко Ñеми, ÑÑе ÑÑловие TRUE.</td> 393</tr> 394<tr> 395<td><a href="https://oracleplsql.ru/insert-sql-server.html">INSERT</a></td> 396<td>ÐпеÑаÑÐ¾Ñ Ð²ÑÑавки ÑÑÑоки в ÑаблиÑÑ</td> 397</tr> 398<tr> 399<td><a href="https://oracleplsql.ru/update-sql-server.html">UPDATE</a></td> 400<td>ÐпеÑаÑÐ¾Ñ Ð¾Ð±Ð½Ð¾Ð²Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² ÑаблиÑе</td> 401</tr> 402<tr> 403<td><a href="https://oracleplsql.ru/delete-sql-server.html">DELETE</a></td> 404<td>ÐпеÑаÑÐ¾Ñ ÑÐ´Ð°Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸Ð· ÑаблиÑÑ</td> 405</tr> 406<tr> 407<td><a href="https://oracleplsql.ru/delete-top-sql-server.html">DELETE TOP</a></td> 408<td>ÐпеÑаÑÐ¾Ñ ÑÐ´Ð°Ð»ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸Ð· ÑаблиÑÑ Ñ Ð¾Ð³ÑаниÑением колиÑеÑÑва запиÑей</td> 409</tr> 410<tr> 411<td><a href="https://oracleplsql.ru/truncate-table-sql-server.html">TRUNCATE TABLE</a></td> 412<td>ÐпеÑаÑÐ¾Ñ Ð¾ÑиÑÑки даннÑÑ Ð¸Ð· ÑаблиÑÑ</td> 413</tr> 414<tr> 415<td><a href="https://oracleplsql.ru/union-sql-server.html">UNION</a></td> 416<td>ÐпеÑаÑÐ¾Ñ Ð¾Ð±ÑÐµÐ´Ð¸Ð½ÐµÐ½Ð¸Ñ Ð½Ð°Ð±Ð¾Ñов ÑезÑлÑÑаÑов Ñ Ñдалением повÑоÑÑÑÑÐ¸Ñ ÑÑ ÑÑÑок</td> 417</tr> 418<tr> 419<td><a href="https://oracleplsql.ru/union-all-sql-server.html">UNION ALL</a></td> 420<td>ÐпеÑаÑÐ¾Ñ Ð¾Ð±ÑÐµÐ´Ð¸Ð½ÐµÐ½Ð¸Ñ Ð½Ð°Ð±Ð¾Ñов ÑезÑлÑÑаÑов без ÑÐ´Ð°Ð»ÐµÐ½Ð¸Ñ Ð¿Ð¾Ð²ÑоÑÑÑÑÐ¸Ñ ÑÑ ÑÑÑок</td> 421</tr> 422<tr> 423<td><a href="https://oracleplsql.ru/intersect-sql-server.html">INTERSECT</a></td> 424<td>ÐпеÑаÑÐ¾Ñ Ð²Ð¾Ð·Ð²ÑаÑÐ°ÐµÑ Ð¾Ð±Ñие запиÑи набоÑов ÑезÑлÑÑаÑов</td> 425</tr> 426<tr> 427<td><a href="https://oracleplsql.ru/except-sql-server.html">EXCEPT</a></td> 428<td>ÐпеÑаÑÐ¾Ñ Ð¸Ð·Ð²Ð»ÐµÐºÐ°ÐµÑ Ð²Ñе запиÑи из пеÑвого набоÑа даннÑÑ , а заÑем ÑдалÑÐµÑ Ð¸Ð· ÑезÑлÑÑаÑов вÑе запиÑи из вÑоÑого набоÑа даннÑÑ </td> 429</tr> 430<tr> 431<td><a href="https://oracleplsql.ru/subqueries-sql-server.html">Subqueries</a></td> 432<td>ÐложеннÑй запÑÐ¾Ñ (подзапÑоÑ)</td> 433</tr> 434<tr> 435<td><a href="https://oracleplsql.ru/pivot-sql-server.html">PIVOT</a></td> 436<td>ÐпеÑаÑÐ¾Ñ Ð¿Ð¾Ð²Ð¾ÑаÑÐ¸Ð²Ð°ÐµÑ ÑÑÑоки в ÑÑолбÑÑ</td> 437</tr> 438<tr> 439<td><a href="https://oracleplsql.ru/join-tables-sql-server.html">JOIN Tables</a></td> 440<td>ÐÑполÑзÑÑÑÑÑ Ð´Ð»Ñ Ð¸Ð·Ð²Ð»ÐµÑÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸Ð· неÑколÑÐºÐ¸Ñ ÑаблиÑ</td> 441</tr> 442</tbody> 443</table> 444<h2> SQL Server ÑаблиÑÑ Ð¸ пÑедÑÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ </h2> 445<table> 446<tbody> 447<tr> 448<td><a href="https://oracleplsql.ru/create-table-sql-server.html">CREATE TABLE</a></td> 449<td>ÐпеÑаÑÐ¾Ñ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ ÑаблиÑÑ</td> 450</tr> 451<tr> 452<td><a href="https://oracleplsql.ru/alter-table-sql-server.html">ALTER TABLE</a></td> 453<td>ÐпеÑаÑÐ¾Ñ Ð¸Ð·Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ ÑаблиÑÑ</td> 454</tr> 455<tr> 456<td><a href="https://oracleplsql.ru/drop-table-sql-server.html">DROP TABLE</a></td> 457<td>ÐпеÑаÑÐ¾Ñ ÑÐ´Ð°Ð»ÐµÐ½Ð¸Ñ ÑаблиÑÑ</td> 458</tr> 459<tr> 460<td><a href="https://oracleplsql.ru/local-temp-tables-sql-server.html">LOCAL TEMP TABLES</a></td> 461<td>ÐокалÑÐ½Ð°Ñ Ð²ÑÐµÐ¼ÐµÐ½Ð½Ð°Ñ ÑаблиÑа</td> 462</tr> 463<tr> 464<td><a href="https://oracleplsql.ru/global-temp-tables-sql-server.html">GLOBAL TEMP TABLES</a></td> 465<td>
465ÐлобалÑÐ½Ð°Ñ Ð²ÑÐµÐ¼ÐµÐ½Ð½Ð°Ñ ÑаблиÑа</td> 466</tr> 467<tr> 468<td><a href="https://oracleplsql.ru/view-sql-server.html">VIEW</a></td> 469<td>ÐÑедÑÑавление</td> 470</tr> 471</tbody> 472</table> 473<h2> SQL Server клÑÑи, индекÑÑ Ð¸ огÑаниÑÐ°Ð½Ð¸Ñ </h2> 474<table> 475<tbody> 476<tr> 477<td><a href="https://oracleplsql.ru/primary-keys-sql-server.html">Primary Keys</a></td> 478<td>Создание, Ñдаление, вклÑÑение и оÑклÑÑение пеÑвиÑного клÑÑа</td> 479</tr> 480<tr> 481<td><a href="https://oracleplsql.ru/create-foreign-keys-sql-server.html">Create Foreign Keys</a></td> 482<td>Создание внеÑнего клÑÑа</td> 483</tr> 484<tr> 485<td><a href="https://oracleplsql.ru/create-foreign-keys-with-cascade-delete-sql-server.html">Create Foreign Keys with cascade delete</a></td> 486<td>Создание внеÑÐ½Ð¸Ñ ÐºÐ»ÑÑей Ñ ÐºÐ°ÑкаднÑм Ñдалением</td> 487</tr> 488<tr> 489<td><a href="https://oracleplsql.ru/create-foreign-keys-with-set-null-on-delete-sql-server.html">Create Foreign Keys with set null on delete</a></td> 490<td>Создание внеÑÐ½Ð¸Ñ ÐºÐ»ÑÑей Ñ ÑÑÑановленнÑм знаÑением null Ð´Ð»Ñ ÑдалениÑ</td> 491</tr> 492<tr> 493<td><a href="https://oracleplsql.ru/drop-a-foreign-key-sql-server.html">Drop a Foreign Key</a></td> 494<td>Удаление внеÑнего клÑÑа</td> 495</tr> 496<tr> 497<td><a href="https://oracleplsql.ru/disable-a-foreign-key-sql-server.html">Disable a Foreign Key</a></td> 498<td>ÐÑклÑÑение внеÑнего клÑÑа</td> 499</tr> 500<tr> 501<td><a href="https://oracleplsql.ru/enable-a-foreign-key-sql-server.html">Enable a Foreign Key</a></td> 502<td>ÐклÑÑение внеÑнего клÑÑа</td> 503</tr> 504<tr> 505<td><a href="https://oracleplsql.ru/unique-constraints-sql-server.html">Unique Constraints</a></td> 506<td>УникалÑнÑе огÑаниÑениÑ</td> 507</tr> 508<tr> 509<td><a href="https://oracleplsql.ru/check-constraints-sql-server.html">Check Constraints</a></td> 510<td>ÐÑовеÑка огÑаниÑений</td> 511</tr> 512<tr> 513<td><a href="https://oracleplsql.ru/indexes-sql-server.html">Indexes</a></td> 514<td>ÐндекÑÑ</td> 515</tr> 516</tbody> 517</table> 518<h2> SQL Server админиÑÑÑиÑование </h2> 519<table> 520<tbody> 521<tr> 522<td><a href="https://oracleplsql.ru/grant-revoke-privileges-sql-server.html">Grant Revoke Privileges</a></td> 523<td>ÐÑедоÑÑавление и оÑмена пÑивилегий</td> 524</tr> 525<tr> 526<td><a href="https://oracleplsql.ru/create-login-sql-server.html">CREATE LOGIN</a></td> 527<td>СоздаÑÑ Ð»Ð¾Ð³Ð¸Ð½</td> 528</tr> 529<tr> 530<td><a href="https://oracleplsql.ru/alter-login-sql-server.html">ALTER LOGIN</a></td> 531<td>ÐзмениÑÑ Ð»Ð¾Ð³Ð¸Ð½</td> 532</tr> 533<tr> 534<td><a href="https://oracleplsql.ru/drop-login-sql-server.html">DROP LOGIN</a></td> 535<td>УдалиÑÑ Ð»Ð¾Ð³Ð¸Ð½</td> 536</tr> 537<tr> 538<td><a href="https://oracleplsql.ru/find-logins-in-sql-server.html">Find Logins in SQL Server</a></td> 539<td>ÐайÑи логин в SQL Server</td> 540</tr> 541<tr> 542<td><a href="https://oracleplsql.ru/change-a-password-in-sql-server.html">Change Password in SQL Server</a></td> 543<td>ÐзмениÑÑ Ð¿Ð°ÑÐ¾Ð»Ñ Ð² SQL Server</td> 544</tr> 545<tr> 546<td><a href="https://oracleplsql.ru/create-user-sql-server.html">CREATE USER</a></td> 547<td>СоздаÑÑ Ð¿Ð¾Ð»ÑзоваÑелÑ</td> 548</tr> 549<tr> 550<td><a href="https://oracleplsql.ru/drop-user-sql-server.html">DROP USER</a></td> 551<td>УдалиÑÑ Ð¿Ð¾Ð»ÑзоваÑелÑ</td> 552</tr> 553<tr> 554<td><a href="https://oracleplsql.ru/find-users-in-sql-server-sql-server.html">Find Users in SQL Server</a></td> 555<td>ÐайÑи полÑзоваÑÐµÐ»Ñ Ð² SQL Server</td> 556</tr> 557</tbody> 558</table> 559<h2> SQL Server ÐÑогÑаммиÑование </h2> 560<table> 561<tbody> 562<tr> 563<td><a href="https://oracleplsql.ru/functions-sql-server.html">Functions</a></td> 564<td>Создание и Ñдаление ÑÑнкÑии</td> 565</tr> 566<tr> 567<td><a href="https://oracleplsql.ru/procedures-sql-server.html">Procedures</a></td> 568<td>Создание и Ñдаление пÑоÑедÑÑÑ</td> 569</tr> 570<tr> 571<td><a href="https://oracleplsql.ru/literals-constants-sql-server.html">Literals (Constants)</a></td> 572<td>ÐиÑеÑÐ°Ð»Ñ (конÑÑанÑÑ)</td> 573</tr> 574<tr> 575<td><a href="https://oracleplsql.ru/declare-variables-sql-server.html">Declare Variables</a></td> 576<td>ÐбÑÑвление пеÑеменнÑÑ </td> 577</tr> 578<tr> 579<td><a href="https://oracleplsql.ru/sequences-sql-server.html">Sequences</a></td> 580<td>ÐоÑледоваÑелÑноÑÑÑ (авÑонÑмеÑаÑиÑ)</td> 581</tr> 582<tr> 583<td><a href="https://oracleplsql.ru/comments-within-sql-sql-server.html">Comments within SQL</a></td> 584<td>ÐомменÑаÑии в SQL Server</td> 585</tr> 586<tr> 587<td><a href="https://oracleplsql.ru/comparison-operators-sql-server.html">Comparison Operators</a></td> 588<td>ÐпеÑаÑоÑÑ ÑÑавнениÑ</td> 589</tr> 590<tr> 591<td><a href="https://oracleplsql.ru/aliases-sql-server.html">ALIASES</a></td> 592<td>ÐÑевдонимÑ</td> 593</tr> 594</tbody> 595</table> 596<h3>SQL Server ÑÐ¸ÐºÐ»Ñ Ð¸ ÑÑловнÑе опеÑаÑоÑÑ</h3> 597<table> 598<tbody> 599<tr> 600<td><a href="https://oracleplsql.ru/goto-statement-sql-server.html">GOTO Statement</a></td> 601<td>ÐпеÑаÑÐ¾Ñ Ð¿ÐµÑÐµÑ Ð¾Ð´Ð° GOTO</td> 602</tr> 603<tr> 604<td><a href="https://oracleplsql.ru/while-loop-sql-server.html">WHILE LOOP</a></td> 605<td>Цикл WHILE</td> 606</tr> 607<tr> 608<td><a href="https://oracleplsql.ru/for-loop-sql-server.html">FOR LOOP</a></td> 609<td>ÐмиÑаÑÐ¸Ñ Ñикла FOR</td> 610</tr> 611<tr> 612<td><a href="https://oracleplsql.ru/break-sql-server.html">BREAK</a></td> 613<td>ÐпеÑаÑÐ¾Ñ Ð²ÑÑ Ð¾Ð´Ð° из Ñикла</td> 614</tr> 615<tr> 616<td><a href="https://oracleplsql.ru/continue-sql-server.html">CONTINUE</a></td> 617<td>ÐпеÑаÑÐ¾Ñ Ð¿ÑÐ¾Ð´Ð¾Ð»Ð¶ÐµÐ½Ð¸Ñ Ñикла</td> 618</tr> 619<tr> 620<td><a href="https://oracleplsql.ru/if-else-statement-sql-server.html">IF ELSE Statement</a></td> 621<td>УÑловнÑй опеÑаÑÐ¾Ñ IF</td> 622</tr> 623</tbody> 624</table> 625<h3>SQL Server ÑÑловиÑ</h3> 626<table> 627<tbody> 628<tr> 629<td><a href="https://oracleplsql.ru/and-sql-server.html">AND</a></td> 630<td>ÐогиÑеÑкий опеÑаÑÐ¾Ñ AND</td> 631</tr> 632<tr> 633<td><a href="https://oracleplsql.ru/or-sql-server.html">OR</a></td> 634<td>ÐогиÑеÑкий опеÑаÑÐ¾Ñ OR</td> 635</tr> 636<tr> 637<td><a href="https://oracleplsql.ru/and-and-or-sql-server.html">AND and OR</a></td> 638<td>ÐогиÑеÑкий опеÑаÑÐ¾Ñ AND и OR</td> 639</tr> 640<tr> 641<td><a href="https://oracleplsql.ru/like-sql-server.html">LIKE</a></td> 642<td>ÐпÑеделÑеÑ, ÑÐ¾Ð²Ð¿Ð°Ð´Ð°ÐµÑ Ð»Ð¸ ÑÐºÐ°Ð·Ð°Ð½Ð½Ð°Ñ ÑимволÑÐ½Ð°Ñ ÑÑÑока Ñ Ð·Ð°Ð´Ð°Ð½Ð½Ñм Ñаблоном</td> 643</tr> 644<tr> 645<td><a href="https://oracleplsql.ru/in-sql-server.html">IN</a></td> 646<td>ÐпÑеделÑеÑ, ÑÐ¾Ð²Ð¿Ð°Ð´Ð°ÐµÑ Ð»Ð¸ Ñказанное знаÑение Ñ ÐºÐ°ÐºÐ¸Ð¼-либо знаÑением во вложеннÑм запÑоÑе или ÑпиÑке.</td> 647</tr> 648<tr> 649<td><a href="https://oracleplsql.ru/not-sql-server.html">NOT</a></td> 650<td>ÐÑÑиÑание ÑÑловиÑ</td> 651</tr> 652<tr> 653<td><a href="https://oracleplsql.ru/is-null-sql-server.html">IS NULL</a></td> 654<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ Ð¿ÑовеÑки знаÑÐµÐ½Ð¸Ñ NULL</td> 655</tr> 656<tr> 657<td><a href="https://oracleplsql.ru/is-not-null-sql-server.html">IS NOT NULL</a></td> 658<td>ÐÑполÑзÑеÑÑÑ Ð´Ð»Ñ Ð¿ÑовеÑки знаÑÐµÐ½Ð¸Ñ NOT NULL</td> 659</tr> 660<tr> 661<td><a href="https://oracleplsql.ru/between-sql-server.html">BETWEEN</a></td> 662<td>ÐпÑеделÑÐµÑ Ð´Ð¸Ð°Ð¿Ð°Ð·Ð¾Ð½ Ð´Ð»Ñ Ð¿ÑовеÑки ÑÑловиÑ</td> 663</tr> 664<tr> 665<td><a href="https://oracleplsql.ru/exists-sql-server.html">EXISTS</a></td> 666<td>РпÑедложении WHERE внеÑнего запÑоÑа пÑовеÑÑеÑÑÑ Ð½Ð°Ð»Ð¸Ñие ÑÑÑок, возвÑаÑеннÑÑ Ð²Ð»Ð¾Ð¶ÐµÐ½Ð½Ñм запÑоÑом.</td> 667</tr> 668</tbody> 669</table> 670 </div><!-- .entry-content --> 671 672 <footer class="entry-meta"> 673 <span class="cat-links"> 674 Ð ÑбÑика: <a href="https://oracleplsql.ru/category/programming-sql-server" rel="category tag">ÐÑогÑаммиÑование SQL Server</a> </span> 675 676
677 <span class="sep"> | </span> 678 <span class="permalink"><a href="https://oracleplsql.ru/contents-sql-server.html" rel="bookmark" title="ÐÑÑÐ¼Ð°Ñ ÑÑÑлка на SQL Server ÑÑебник">Permalink</a></span> 679 </footer><!-- .entry-meta --> 680<div class="gt_ct">
681<script data-rocketlazyloadscript='https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
681 682<!-- Oracleplsql.ru (низ ÑÑаÑÑÑ) 728 x 90 --> 683<style> 684.orclplsql_adapt_mobile_bottom { width: 320px; height: 100px; } 685@media(min-width: 500px) { .orclplsql_adapt_mobile_bottom { width: 468px; height: 60px; } } 686@media(min-width: 800px) { .orclplsql_adapt_mobile_bottom { width: 728px; height: 90px; } } 687</style> 688<ins class="adsbygoogle orclplsql_adapt_mobile_bottom" 689 style="display:block" 690 data-ad-client="ca-pub-8777261894857145" 691 data-ad-slot="6588458128" 692 data-ad-format="auto" 693 data-full-width-responsive="true"></ins>
694<script> 695 (adsbygoogle = window.adsbygoogle || []).push({}); 696</script>
696 697</div> 698<!--<input type="button" onclick="history.back();" value="Ðазад"/>-->
699<script data-rocketlazyloadscript='//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
699 700<ins class="adsbygoogle" 701 style="display:block" 702 data-ad-format="autorelaxed" 703 data-ad-client="ca-pub-8777261894857145" 704 data-ad-slot="6043257265"></ins>
705<script> 706 (adsbygoogle = window.adsbygoogle || []).push({}); 707</script>
707 708 709</article><!-- #post-7347 --> 710 711 712 713 <nav role="navigation" id="nav-below" class="site-navigation post-navigation"> 714 <h1 class="assistive-text">Post navigation</h1> 715 716 717 <div class="nav-previous"><a href="https://oracleplsql.ru/postgresql-manual.html" rel="prev"><span class="meta-nav">«</span> PostgreSQL ÑÑебник</a></div> <div class="nav-next"><a href="https://oracleplsql.ru/sqlite-manual.html" rel="next">SQLite ÑÑебник <span class="meta-nav">»</span></a></div> 718 719 </nav><!-- #nav-below --> 720 721 722 723 </div><!-- #content .site-content --> 724 </div><!-- #primary .content-area --> 725 726 <div id="secondary" class="widget-area"> 727 <div id="sidebar-1" class="sidebar" role="complementary"> 728 <aside id="custom_html-11" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget">
728<script async src='https://cse.google.com/cse.js?cx=partner-pub-8777261894857145:5121821727'></script>
728 729<div class="gcse-searchbox-only"></div></div></aside><aside id="nav_menu-16" class="widget widget_nav_menu"><h1 class="widget-title">SQL Server</h1><div class="menu-sql-server-container"><ul id="menu-sql-server" class="menu"><li id="menu-item-7654" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-item menu-item-7654"><a href="https://oracleplsql.ru/contents-sql-server.html" aria-current="page">SQL Server Full</a></li> 730<li id="menu-item-7659" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7659"><a href="https://oracleplsql.ru/administration-sql-server.html">ÐдминиÑÑÑиÑование</a></li> 731<li id="menu-item-7668" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7668"><a href="https://oracleplsql.ru/keys-sql-server.html">ÐлÑÑи (primary, foreign)</a></li> 732<li id="menu-item-7671" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7671"><a>ÐндекÑÑ Ð¸ УникалÑнÑе огÑаниÑениÑ</a></li> 733<li id="menu-item-7674" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7674"><a href="https://oracleplsql.ru/procedures-sql-server.html">ÐÑоÑедÑÑÑ</a></li> 734<li id="menu-item-7675" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7675"><a href="https://oracleplsql.ru/functions-sql-server.html">ФÑнкÑии</a></li> 735<li id="menu-item-7676" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7676"><a href="https://oracleplsql.ru/comparison-operators-sql-server.html">ÐпеÑаÑоÑÑ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ñ (=,>=, !=)</a></li> 736<li id="menu-item-7678" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7678"><a href="https://oracleplsql.ru/tables-and-views-sql-server.html">ТаблиÑÑ Ð¸ пÑедÑÑавлениÑ</a></li> 737<li id="menu-item-7682" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7682"><a href="https://oracleplsql.ru/sql-query-types-sql-server.html">Ð¢Ð¸Ð¿Ñ SQL запÑоÑов</a></li> 738<li id="menu-item-7686" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7686"><a href="https://oracleplsql.ru/data-types-sql-server.html">Ð¢Ð¸Ð¿Ñ Ð´Ð°Ð½Ð½ÑÑ </a></li> 739<li id="menu-item-7688" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7688"><a href="https://oracleplsql.ru/loops-and-conditional-statements-sql-server.html">Ð¦Ð¸ÐºÐ»Ñ Ð¸ УÑловнÑе опеÑаÑоÑÑ</a></li> 740<li id="menu-item-7693" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7693"><a href="https://oracleplsql.ru/conditions-sql-server.html">УÑÐ»Ð¾Ð²Ð¸Ñ (and, or, not)</a></li> 741</ul></div></aside><aside id="nav_menu-17" class="widget widget_nav_menu"><h1 class="widget-title">ФÑнкÑии SQL Server</h1><div class="menu-funkczii-sql-server-container"><ul id="menu-funkczii-sql-server" class="menu"><li id="menu-item-7513" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7513"><a href="https://oracleplsql.ru/date-time-function-sql-server.html">ÐаÑа / вÑемÑ</a></li> 742<li id="menu-item-7514" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7514"><a href="https://oracleplsql.ru/advanced-function-sql-server.html">ÐополниÑелÑнÑе</a></li> 743<li id="menu-item-7515" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7515"><a href="https://oracleplsql.ru/conversion-functions-sql-server.html">ÐÑеобÑазованиÑ</a></li> 744<li id="menu-item-7516" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7516"><a href="https://oracleplsql.ru/string-char-functions-sql-server.html">СимволÑнÑе / ÑÑÑоÑнÑе</a></li> 745<li id="menu-item-7517" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-7517"><a href="https://oracleplsql.ru/numeric-mathematical-functions-sql-server.html">ЧиÑловÑе/маÑемаÑиÑеÑкие</a></li> 746</ul></div></aside><aside id="custom_html-12" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget">
746<script data-rocketlazyloadscript='https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js' async ></script>
746 747<!-- Oracleplsql.ru боковой 300Ñ 600 --> 748<ins class="adsbygoogle" 749 style="display:block" 750 data-ad-client="ca-pub-8777261894857145" 751 data-ad-slot="1425058522" 752 data-ad-format="auto"></ins>
753<script> 754 (adsbygoogle = window.adsbygoogle || []).push({}); 755</script>
755 756 757<!-- hit.ua --> 758<a href='http://hit.ua/?x=128731' target='_blank'>
759<script language="javascript" type="text/javascript"><!-- 760Cd=document;Cr="&"+Math.random();Cp="&s=1"; 761Cd.cookie="b=b";if(Cd.cookie)Cp+="&c=1"; 762Cp+="&t="+(new Date()).getTimezoneOffset(); 763if(self!=top)Cp+="&f=1"; 764//--></script>
vendor: 2 bytes, line 764
764
765<script language="javascript1.1" type="text/javascript"><!-- 766if(navigator.javaEnabled())Cp+="&j=1"; 767//--></script>
vendor: 2 bytes, line 767
767
768<script language="javascript1.2" type="text/javascript"><!-- 769if(typeof(screen)!='undefined')Cp+="&w="+screen.width+"&h="+ 770screen.height+"&d="+(screen.colorDepth?screen.colorDepth:screen.pixelDepth); 771//--></script>
vendor: 2 bytes, line 771
771
772<script language="javascript" type="text/javascript"><!-- 773Cd.write("<sc"+"ript src='//c.hit.ua/hit?i=128731&g=0&x=3"+Cp+Cr+ 774"&r="+escape(Cd.referrer)+"&u="+escape(window.location.href)+"'></sc"+"ript>"); 775//--></script>
775</a> 776<!-- / hit.ua --> 777 778<!-- Yandex.Metrika counter --> 779 780<noscript><div><img src="https://mc.yandex.ru/watch/26721072" style="position:absolute; left:-9999px;" alt="" /></div></noscript> 781<!-- /Yandex.Metrika counter --> 782</div></aside> </div><!-- #sidebar-right --> 783 784 </div> 785 786 </div><!-- #main .site-main --> 787 788 <footer id="colophon" class="site-footer" role="contentinfo"> 789 <div class="site-info"> 790 <div>© 2014-2026 Oracle PL/SQL</div> </div> 791 </footer><!-- #colophon .site-footer --> 792</div><!-- #page .hfeed .site --> 793
794<script type="speculationrules"> 795{"prefetch":[{"source":"document","where":{"and":[{"href_matches":"/*"},{"not":{"href_matches":["/wp-*.php","/wp-admin/*","/wp-content/uploads/*","/wp-content/*","/wp-content/plugins/*","/wp-content/themes/f2/*","/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]} 796</script>
vendor: 1 bytes, line 796
796
797<script id="rocket-browser-checker-js-after"> 798"use strict";var _createClass=function(){function defineProperties(target,props){for(var i=0;i<props.length;i++){var descriptor=props[i];descriptor.enumerable=descriptor.enumerable||!1,descriptor.configurable=!0,"value"in descriptor&&(descriptor.writable=!0),Object.defineProperty(target,descriptor.key,descriptor)}}return function(Constructor,protoProps,staticProps){return protoProps&&defineProperties(Constructor.prototype,protoProps),staticProps&&defineProperties(Constructor,staticProps),Constructor}}();function _classCallCheck(instance,Constructor){if(!(instance instanceof Constructor))throw new TypeError("Cannot call a class as a function")}var RocketBrowserCompatibilityChecker=function(){function RocketBrowserCompatibilityChecker(options){_classCallCheck(this,RocketBrowserCompatibilityChecker),this.passiveSupported=!1,this._checkPassiveOption(this),this.options=!!this.passiveSupported&&options}return _createClass(RocketBrowserCompatibilityChecker,[{key:"_checkPassiveOption",value:function(self){try{var options={get passive(){return!(self.passiveSupported=!0)}};window.addEventListener("test",null,options),window.removeEventListener("test",null,options)}catch(err){self.passiveSupported=!1}}},{key:"initRequestIdleCallback",value:function(){!1 in window&&(window.requestIdleCallback=function(cb){var start=Date.now();return setTimeout(function(){cb({didTimeout:!1,timeRemaining:function(){return Math.max(0,50-(Date.now()-start))}})},1)}),!1 in window&&(window.cancelIdleCallback=function(id){return clearTimeout(id)})}},{key:"isDataSaverModeOn",value:function(){return"connection"in navigator&&!0===navigator.connection.saveData}},{key:"supportsLinkPrefetch",value:function(){var elem=document.createElement("link");return elem.relList&&elem.relList.supports&&elem.relList.supports("prefetch")&&window.IntersectionObserver&&"isIntersecting"in IntersectionObserverEntry.prototype}},{key:"isSlowConnection",value:function(){return"connection"in navigator&&"effectiveType"in navigator.connection&&("2g"===navigator.connection.effectiveType||"slow-2g"===navigator.connection.effectiveType)}}]),RocketBrowserCompatibilityChecker}(); 799//# sourceURL=rocket-browser-checker-js-after 800</script>
vendor: 1 bytes, line 800
800
801<script id="rocket-delay-js-js-after"> 802(function() { 803"use strict";var e=function(){function n(e,t){for(var r=0;r<t.length;r++){var n=t[r];n.enumerable=n.enumerable||!1,n.configurable=!0,"value"in n&&(n.writable=!0),Object.defineProperty(e,n.key,n)}}return function(e,t,r){return t&&n(e.prototype,t),r&&n(e,r),e}}();function n(e,t){if(!(e instanceof t))throw new TypeError("Cannot call a class as a function")}var t=function(){function r(e,t){n(this,r),this.attrName="data-rocketlazyloadscript",this.browser=t,this.options=this.browser.options,this.triggerEvents=e,this.userEventListener=this.triggerListener.bind(this)}return e(r,[{key:"init",value:function(){this._addEventListener(this)}},{key:"reset",value:function(){this._removeEventListener(this)}},{key:"_addEventListener",value:function(t){this.triggerEvents.forEach(function(e){return window.addEventListener(e,t.userEventListener,t.options)})}},{key:"_removeEventListener",value:function(t){this.triggerEvents.forEach(function(e){return window.removeEventListener(e,t.userEventListener,t.options)})}},{key:"_loadScriptSrc",value:function(){var r=this,e=document.querySelectorAll("script["+this.attrName+"]");0!==e.length&&Array.prototype.slice.call(e).forEach(function(e){var t=e.getAttribute(r.attrName);e.setAttribute("src",t),e.removeAttribute(r.attrName)}),this.reset()}},{key:"triggerListener",value:function(){this._loadScriptSrc(),this._removeEventListener(this)}}],[{key:"run",value:function(){RocketBrowserCompatibilityChecker&&new r(["keydown","mouseover","touchmove","touchstart"],new RocketBrowserCompatibilityChecker({passive:!0})).init()}}]),r}();t.run(); 804}()); 805 806//# sourceURL=rocket-delay-js-js-after 807</script>
807 808 809
810<script>window.lazyLoadOptions={elements_selector:"img[data-lazy-src],.rocket-lazyload",data_src:"lazy-src",data_srcset:"lazy-srcset",data_sizes:"lazy-sizes",class_loading:"lazyloading",class_loaded:"lazyloaded",threshold:300,callback_loaded:function(element){if(element.tagName==="IFRAME"&&element.dataset.rocketLazyload=="fitvidscompatible"){if(element.classList.contains("lazyloaded")){if(typeof window.jQuery!="undefined"){if(jQuery.fn.fitVids){jQuery(element).parent().fitVids()}}}}}};window.addEventListener('LazyLoad::Initialized',function(e){var lazyLoadInstance=e.detail.instance;if(window.MutationObserver){var observer=new MutationObserver(function(mutations){var image_count=0;var iframe_count=0;var rocketlazy_count=0;mutations.forEach(function(mutation){for(i=0;i<mutation.addedNodes.length;i++){if(typeof mutation.addedNodes[i].getElementsByTagName!=='function'){continue} 811if(typeof mutation.addedNodes[i].getElementsByClassName!=='function'){continue} 812images=mutation.addedNodes[i].getElementsByTagName('img');is_image=mutation.addedNodes[i].tagName=="IMG";iframes=mutation.addedNodes[i].getElementsByTagName('iframe');is_iframe=mutation.addedNodes[i].tagName=="IFRAME";rocket_lazy=mutation.addedNodes[i].getElementsByClassName('rocket-lazyload');image_count+=images.length;iframe_count+=iframes.length;rocketlazy_count+=rocket_lazy.length;if(is_image){image_count+=1} 813if(is_iframe){iframe_count+=1}}});if(image_count>0||iframe_count>0||rocketlazy_count>0){lazyLoadInstance.update()}});var b=document.getElementsByTagName("body")[0];var config={childList:!0,subtree:!0};observer.observe(b,config)}},!1)</script>
813<script data-no-minify="1" async src="https://oracleplsql.ru/wp-content/plugins/wp-rocket/assets/js/lazyload/16.1/lazyload.min.js"></script>
vendor: 1 bytes, line 813
813
814<script src="https://oracleplsql.ru/wp-content/cache/min/1/c399ab51200a46594e69f0c96581fa81.js" data-minify="1" defer></script>
814</body> 815</html> 816<!-- This website is like a Rocket, isn't it? Performance optimized by WP Rocket. Learn more: https://wp-rocket.me - Debug: cached@1791172357 -->
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.