PageSourceSearch

https://oracleplsql.ru/contents-sql-server.html

html oracleplsql.ru collected 2026-10-05 08:57:48 UTC 56,434 bytes, 816 lines download raw bytes

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 учебник &#8212; 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&#038;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 &raquo; Лента" href="https://oracleplsql.ru/feed" />
29<link rel="alternate" type="application/rss+xml" title="Oracle PL/SQL · MySQL · SQL Server · PostgreSQL · SQLite &raquo; Лента комментариев" 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				Рубрика:&nbsp;<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">&laquo;</span> PostgreSQL учебник</a></div>		<div class="nav-next"><a href="https://oracleplsql.ru/sqlite-manual.html" rel="next">SQLite учебник <span class="meta-nav">&raquo;</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>&copy; 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.