PageSourceSearch

https://www.sqlservertutorial.net/sql-server-basics/

html sqlservertutorial.net collected 2026-10-02 05:32:19 UTC 120,242 bytes, 195 lines download raw bytes

1<!doctype html><html lang="en-US"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1">
2
3    
4            
4<script>
5            (() => {
6                let theme = localStorage.getItem("theme");
7                document.querySelector("html").dataset.theme = theme ? theme : "light";
8            })();
9        </script>
9
10    
11    <meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1' />
12<script src="https://increase-rev.cv3-ecf.workers.dev/819f2eu.js" async data-code="23940935" ></script>
12
13
14	
15	<title>SQL Server Basics</title><meta name="description" content="The SQL server basics section shows you how to use the Transact-SQL (T-SQL) statements to interact with SQL Server databases." /><link rel="canonical" href="https://www.sqlservertutorial.net/sql-server-basics/" /><meta property="og:locale" content="en_US" /><meta property="og:type" content="article" /><meta property="og:title" content="SQL Server Basics" /><meta property="og:description" content="The SQL server basics section shows you how to use the Transact-SQL (T-SQL) statements to interact with SQL Server databases." /><meta property="og:url" content="https://www.sqlservertutorial.net/sql-server-basics/" /><meta property="og:site_name" content="SQL Server Tutorial" /><meta property="article:modified_time" content="2024-07-29T14:50:13+00:00" /><meta name="twitter:card" content="summary_large_image" /><meta name="twitter:label1" content="Est. reading time" /><meta name="twitter:data1" content="7 minutes" />
16	
16<script type="application/ld+json" class="yoast-schema-graph">{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/","url":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/","name":"SQL Server Basics","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-basics.svg","datePublished":"2018-04-11T15:12:14+00:00","dateModified":"2024-07-29T14:50:13+00:00","description":"The SQL server basics section shows you how to use the Transact-SQL (T-SQL) statements to interact with SQL Server databases.","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/sql-server-basics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/#primaryimage","url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-basics.svg","contentUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/sql-server-basics.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-basics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQL Server Basics"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}</script>
16
17	
18
19
20
21<style id="essential-optimize-critical-css">.smart-search__panel{border-radius:var(--ss-radius,10px)}.smart-search *,.smart-search ::after,.smart-search ::before{box-sizing:border-box}.smart-search__panel{min-width:0;max-width:100%}.smart-search--appearance-follow-theme .smart-search__panel{background:var(--ss-bg);color:var(--ss-fg)}.ads{text-align:left;margin:.5rem 0}: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}:root{--wp--preset--font-size--normal:16px;--wp--preset--font-size--huge:42px}.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}ul{box-sizing:border-box}.wp-block-code{box-sizing:border-box}.wp-block-code code{direction:ltr;display:block;font-family:inherit;overflow-wrap:break-word;text-align:initial;white-space:break-spaces}: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;
21--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,0) 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)}:where(body){margin:0}body{padding-top:0;padding-right:0;padding-bottom:0;padding-left:0}.hfb-container *,.hfb-container ::after,.hfb-container ::before{box-sizing:border-box}.hfb-btn{appearance:none;-webkit-appearance:none;min-height:36px;display:inline-flex;align-items:center;justify-content:center;gap:5px;margin:0;padding:8px 12px;border:1px solid currentColor;border-color:var(--hfb-border);border-radius:4px;background:0 0;box-shadow:none;color:inherit;font:inherit;font-size:14px;line-height:1;text-transform:none}.hfb-btn::after,.hfb-btn::before{content:none}.hfb-form-container{max-width:560px;margin:1rem auto 0;padding:0;border:0;background:0 0}.hfb-form-container[hidden],.hfb-thank-you[hidden]{display:none}.hfb-feedback-form label{display:block;margin:0 0 6px;color:inherit;font:inherit;font-weight:500}.hfb-feedback-form textarea{appearance:none;display:block;width:100%;min-height:92px;margin:0;padding:10px 12px;resize:vertical;border:1px solid currentColor;border-color:var(--hfb-border);border-radius:4px;background:var(--hfb-surface);box-shadow:none;color:inherit;font:inherit;line-height:1.5}.hfb-form-actions{display:flex;align-items:center;flex-wrap:wrap;gap:12px;margin-top:10px}.hfb-btn-submit{border-color:ButtonText;background:ButtonText;color:ButtonFace;font-weight:500}.hfb-btn-cancel{appearance:none;min-height:34px;margin:0;padding:4px 0;border:0;background:0 0;color:inherit;opacity:.72;font:inherit}.hfb-status{max-width:560px;margin:8px auto 0;color:inherit;opacity:.78;font:inherit;text-align:center}.hfb-status:empty{display:none}.hfb-thank-you{display:flex;align-items:center;justify-content:center;min-height:34px;color:var(--hfb-positive)}.hfb-thank-you p{margin:0;color:inherit;font:inherit;font-weight:500}@media (forced-colors:active){.hfb-btn,.hfb-feedback-form textarea{forced-color-adjust:auto}}.smart-search{--ss-bg:#fff;--ss-fg:#172033;--ss-muted:#667085;--ss-border:#d0d5dd;--ss-accent:#2563eb;--ss-shadow:0 12px 32px rgba(16,24,40,0.14);position:relative;width:100%;max-width:42rem;color:var(--ss-fg);font:inherit}
21.smart-search__field{display:flex;align-items:center;gap:.6rem;min-height:44px;padding:0 .75rem;border:1px solid var(--ss-border);border-radius:10px;background:var(--ss-bg)}.smart-search__icon{width:16px;height:16px;border:2px solid currentColor;border-radius:50%;color:var(--ss-muted);position:relative;flex:0 0 auto}.smart-search__icon:after{content:"";position:absolute;width:6px;height:2px;background:currentColor;right:-5px;bottom:-2px;transform:rotate(45deg);border-radius:2px}.smart-search__input{width:100%;min-width:0;border:0!important;outline:0!important;box-shadow:none!important;background:0 0!important;color:inherit!important;font:inherit;padding:.65rem 0!important}.smart-search__clear{border:0;background:0 0;color:var(--ss-muted);font-size:1.4rem;line-height:1;padding:.25rem}.smart-search__panel{position:absolute;z-index:9999;top:calc(100% + 8px);left:0;right:0;max-height:min(65vh,440px);overflow:auto;padding:.4rem;background:var(--ss-bg);border:1px solid var(--ss-border);border-radius:12px;box-shadow:var(--ss-shadow)}.screen-reader-text{border:0;clip:rect(1px,1px,1px,1px);clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute!important;width:1px;word-wrap:normal!important}@media (prefers-color-scheme:dark){.smart-search{--ss-bg:#101828;--ss-fg:#f2f4f7;--ss-muted:#98a2b3;--ss-border:#344054;--ss-accent:#84adff;--ss-shadow:0 16px 36px rgba(0,0,0,0.4)}}@media (prefers-reduced-motion:reduce){.smart-search *{animation-duration:0s!important}}.smart-search__field,.smart-search__panel{border-radius:var(--ss-radius,10px)}.smart-search,.smart-search *,.smart-search ::after,.smart-search ::before{box-sizing:border-box}.smart-search{min-width:0}.smart-search__field,.smart-search__panel{min-width:0;max-width:100%}.smart-search__panel{width:100%;overflow-x:hidden}.smart-search__input::-webkit-search-cancel-button,.smart-search__input::-webkit-search-decoration,.smart-search__input::-webkit-search-results-button,.smart-search__input::-webkit-search-results-decoration{-webkit-appearance:none;appearance:none;display:none}.smart-search__input{-webkit-appearance:textfield;appearance:textfield}.smart-search--appearance-follow-theme{--ss-bg:var(--ss-theme-bg,#fff);--ss-fg:var(--ss-theme-fg,#172033);--ss-accent:var(--ss-theme-accent,#2563eb);--ss-border:var(--ss-theme-border,#d0d5dd);font-family:var(--ss-theme-font-family,inherit);font-size:var(--ss-theme-font-size,inherit)}.smart-search--appearance-follow-theme .smart-search__field,.smart-search--appearance-follow-theme .smart-search__panel{background:var(--ss-bg);color:var(--ss-fg)}.smart-search-native{display:block;width:100%;min-width:0;margin:0 0 2.25rem!important;padding:0}.widget_search:has(.smart-search-native),.widget_search:has(>.smart-search-native){margin-bottom:0!important}.smart-search-native>.smart-search{width:100%;margin:0}@media (max-width:600px){.smart-search-native{margin-bottom:2rem!important}}html:not([data-theme=dark]) .smart-search{--ss-bg:var(--body-bg-color,#ffffff);--ss-fg:var(--text-color,#172033);--ss-muted:var(--text-muted-color,#667085);--ss-border:var(--border-color,#d0d5dd);--ss-accent:var(--link-color,#2563eb);--ss-dialog-bg:var(--body-bg-color,#ffffff);--ss-selected-bg:var(--hover-background-color,#eff6ff);--ss-kbd-bg:var(--input-bg-color,#f2f4f7);--ss-shadow:0 12px 32px rgba(16,24,40,0.14)}html:not([data-theme=dark]) .smart-search__field{background:var(--input-bg-color,#fff);border-color:var(--border-color,#d0d5dd);color:var(--text-color,#172033)}*,::after,::before{box-sizing:border-box}*{margin:0}body,html{height:100%}body{line-height:1.5;-webkit-font-smoothing:antialiased}img,svg{max-width:100%}button,input,textarea{font:inherit}h1,h2,p{overflow-wrap:break-word}html{background:var(--body-bg-color);color:var(--text-color);scroll-behavior:smooth}body{font-family:var(--font-family);font-size:1rem;line-height:1.8}h1,h2{padding:0;font-weight:500}h1{font-size:1.875rem;color:var(--heading-color)}h2{font-size:1.5rem;margin-top:1rem;color:var(--subheading-color)}p{margin:1rem 0}img{height:auto}.screen-reader-text{border:0;clip:rect(1px,1px,1px,1px);clip-path:inset(50%);
21height:1px;margin:-1px;overflow:hidden;padding:0;position:fixed!important;width:1px;word-wrap:normal!important;outline-style:dashed;outline-width:.125rem;outline-color:var(--text-color)}.left-column{display:none;padding-bottom:1rem}.site-main{padding:0 1rem}.header-wrapper{display:flex;justify-content:space-between;align-items:center;padding:0 1rem;position:relative}.sidebar{padding:1rem}.breadcrumbs{font-size:.9rem}p code{font-family:var(--font-family-code);font-size:.875rem;background-color:var(--inline-code-bg-color);color:var(--inline-code-color);padding:.25em .5em;border-radius:3px}.wp-block-code code{white-space:pre!important;font-family:var(--font-family-code);font-size:.85rem;border-radius:.5rem;border:solid 1px var(--border-color);text-size-adjust:none!important}a{color:var(--link-color);text-decoration:none}a:visited{color:var(--link-color)}article a{text-decoration-line:underline;text-decoration-thickness:1px}ul{padding:0}.widget-title{font-weight:700;font-size:.8rem;letter-spacing:1px;text-transform:uppercase;padding:0 0 1rem;margin:0}.widget_search{margin-bottom:1.5rem}.widget .menu{margin:0 0 1.5rem}.ad,.ads{text-align:left;margin:.5rem 0}.ad-336{max-width:336px;max-height:320px;overflow:hidden}.ad-300{max-width:300px;max-height:280px;overflow:hidden}.ad::before{content:"Advertisements";color:var(--ads-label-color);font-size:10px;display:block;text-transform:uppercase;text-align:center}.widget ul{margin:0;padding:0}.widget li{list-style-type:none;text-align:left;word-wrap:break-word;padding:.25rem 0}.widget li:first-child{padding-top:0}.widget li a{display:inline-block;padding:0 0 .25rem}.sticky{display:none}.site-header{border-bottom:1px solid var(--border-color)}.logo{display:flex;justify-content:center;align-items:center;background:var(--logo-url) no-repeat center center;height:var(--logo-height);width:var(--logo-width);margin:2px 0}.site-branding{flex-shrink:0;flex-grow:0}.site-branding a{display:block;padding:.5rem}.site-navigation{display:flex;align-items:center;justify-content:center}.site-navigation a{text-transform:uppercase;letter-spacing:.05em;font-size:.8rem;font-weight:500;color:var(--menu-color);padding:.5rem}.site-navigation a:visited{color:var(--menu-color)}.menu-toggle,.switch-theme{height:2.5rem;width:2.5rem;display:flex;justify-content:center;align-items:center;outline:0;border:none;border-radius:50%;background-color:var(--body-bg-color)}.menu-toggle{background:var(--hamburger-icon) no-repeat center center}.light-mode-icon{display:none}.dark-mode-icon{display:inline-block}.site-menu{position:absolute;top:100%;right:0;left:0;z-index:-1;visibility:hidden;opacity:0;transform:translateY(-100%);padding:0;margin:0}.site-menu li{list-style:none;border-bottom:solid 1px var(--border-color);padding:.5rem 0}.site-menu li:first-child{border-top:solid 1px var(--border-color)}.site-menu a{display:block}.sub-menu{display:none}.menu-item-has-children a{display:flex;justify-content:space-between;align-items:center}.menu-item-has-children>a:after{content:"";-webkit-mask:var(--down-icon);mask:var(--down-icon);mask-size:cover;-webkit-mask-size:cover;display:inline-block;height:1rem;width:1rem;background-color:var(--text-color);margin-left:5px}.menu-item-has-children .sub-menu li{border:none}.menu-item-has-children .sub-menu a{font-size:.85rem;margin-left:1rem;text-transform:none;white-space:nowrap}svg{fill:currentColor}.wp-block-code code::-webkit-scrollbar{width:1rem}.wp-block-code code{scrollbar-width:thin;scrollbar-color:var(--scrollbar-thumb-color) var(--scrollbar-bg-color)}.wp-block-code code::-webkit-scrollbar-track{background:var(--scrollbar-bg-color)}.wp-block-code code::-webkit-scrollbar-thumb{background-color:var(--scrollbar-thumb-color);border-radius:1rem;border:5px solid var(--scrollbar-bg-color)}.site label{display:block}.site input,.site textarea{background-color:var(--input-bg-color);color:var(--input-color);border:1px solid var(--border-color);width:100%;padding:.5rem .75rem;outline:0;border-radius:5px}@media (min-width:768px){.site{margin:0 auto;display:grid;grid-template-areas:"header header""main sidebar""footer footer";grid-template-columns:1fr 333px;--header-height:80px}.site-header{grid-area:header}.sidebar{grid-area:sidebar;position:relative;border-left:1px solid var(--border-color)}.site-main{grid-area:main;background-color:var(--body-bg-color);overflow:hidden;max-width:min(70ch,100%);margin:0 auto}.site-footer{grid-area:footer;border-top:1px solid var(--border-color)}.sticky{display:grid;place-content:center;position:sticky;top:var(--header-height)}.site-header{background:var(--header-bg-color);width:100%;position:sticky;top:0;z-index:2}html{scroll-padding-top:75px}}@media (min-width:992px){.site{grid-template-areas:"header header header""banner main sidebar""footer footer footer";grid-template-columns:200px 1fr 333px}.left-column{display:block;grid-area:banner;border-right:1px solid var(--border-color)}.menu-item-has-children .sub-menu a{margin-left:0;font-size:.8rem}.menu-toggle{display:none}.site-branding a{padding:0}.site-menu{opacity:1;visibility:visible;position:relative;top:0;left:0;z-index:1;transform:translateY(0);display:flex;justify-content:flex-end;align-items:center}.site-navigation a{padding:1.25rem .75rem}.site-menu li{padding:0}.sub-menu a{padding:.65rem}.menu-item-has-children{position:relative}.site-menu .sub-menu{display:none;background-color:var(--submenu-bg-color);border:solid 1px var(--border-color);border-radius:.25rem}.site-menu>.menu-item-has-children>a:after{content:"";-webkit-mask:var(--down-icon);mask:var(--down-icon);mask-size:cover;-webkit-mask-size:cover;display:inline-block;height:1rem;width:1rem;background-color:var(--text-color)}.site-menu>.menu-item{border-bottom:2px solid transparent}.site-menu>.current-page-ancestor{border-bottom:solid 2px var(--menu-current-color)}.site-menu li:first-child,.site-menu li:last-child{border-top:none}}@media (min-width:1200px){:root{font-size:calc(1rem + .125vw)}}
21.wp-block-heading a.anchor{text-decoration:none;padding:.35em .05em;visibility:hidden;opacity:0}:root{color-scheme:light;--down-icon:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="12" height="12" fill="currentColor" class="menu-down-icon" viewBox="0 0 16 16"><path fill-rule="evenodd" d="M1.646 4.646a.5.5 0 0 1 .708 0L8 10.293l5.646-5.647a.5.5 0 0 1 .708.708l-6 6a.5.5 0 0 1-.708 0l-6-6a.5.5 0 0 1 0-.708z"/></svg>');--hamburger-icon:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="hamburger-icon" viewBox="0 0 16 16"><path fill-rule="evenodd" d="M2.5 12a.5.5 0 0 1 .5-.5h10a.5.5 0 0 1 0 1H3a.5.5 0 0 1-.5-.5zm0-4a.5.5 0 0 1 .5-.5h10a.5.5 0 0 1 0 1H3a.5.5 0 0 1-.5-.5zm0-4a.5.5 0 0 1 .5-.5h10a.5.5 0 0 1 0 1H3a.5.5 0 0 1-.5-.5z"/></svg>');--x-icon:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" viewBox="0 0 16 16"><path d="M2.146 2.854a.5.5 0 1 1 .708-.708L8 7.293l5.146-5.147a.5.5 0 0 1 .708.708L8.707 8l5.147 5.146a.5.5 0 0 1-.708.708L8 8.707l-5.146 5.147a.5.5 0 0 1-.708-.708L7.293 8 2.146 2.854Z"/></svg>')}:root{--font-family:Inter,-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,Oxygen-Sans,Ubuntu,Cantarell,'Helvetica Neue',sans-serif;--font-family-code:'IBM Plex Mono',ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,Liberation Mono,Courier New,monospace;--primary-color:#00369a;--body-bg-color:#fff;--text-color:#212529;--header-bg-color:#fff;--border-color:#e7ebed;--heading-color:#ec5525;--subheading-color:#262626;--link-color:#00369a;--link-color-hover:#00369a;--footer-bg-color:#fafafa;--footer-color:#525252;--footer-link-color:#00369a;--footer-link-color-hover:#00369a;--ads-label-color:#666;--menu-current-color:#ec5525;--menu-color:#323330;--hover-background-color:#f4f4f4;--menu-background-color:#fff;--submenu-bg-color:#fff;--toggle-color:#f4f4f4;--button-bg-color:#33a0da;--button-color:#fff;--button-bg-color-hover:#2182b6;--button-color-hover:#fff;--button-border-color:#33a0da;--inline-code-bg-color:#f5f5f5;--inline-code-color:#545454;--input-bg-color:#fff;--input-color:#262626;--image-filter:grayscale(0%);--page-nav-bg-color:#fff;--mark-bg-color:#fff6ea;--feature-image-bg-color:#f4f4f4;--feature-image-filter:grayscale(100%);--fancy-list-color:rgba(0,0,0,0.15);--output-bg-color:#f9fafb;--output-border-color:#e7ebed;--post-box-shadow:rgba(50,50,93,0.25) 0px 2px 5px -1px,rgba(0,0,0,0.3) 0px 1px 3px -1px;--post-border:none;--svg-color:#323330;--themeable-image-filter:none;--highlight-bg:#fff8dc;--highlight-img-filter:none;--highlight-label:#5555}html{--logo-url:url("https://www.sqlservertutorial.net/wp-content/uploads/sqlservertutorial.svg");--logo-width:179px;--logo-height:50px;--feature-image-bg-color:#52b9aa}:root{--ssh-code-bg:#f6f8fa;--ssh-code-text:#24292f;--ssh-code-border:#d0d7de;--ssh-code-keyword:#cf222e;
21--ssh-code-string:#0a3069;--ssh-code-comment:#6e7781;--ssh-code-number:#0550ae;--ssh-code-literal:#8250df;--ssh-code-radius:8px;--ssh-code-padding:1rem;--ssh-code-font:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace}@media (prefers-color-scheme:dark){:root{--ssh-code-bg:#0d1117;--ssh-code-text:#c9d1d9;--ssh-code-border:#30363d;--ssh-code-keyword:#ff7b72;--ssh-code-string:#a5d6ff;--ssh-code-comment:#8b949e;--ssh-code-number:#79c0ff;--ssh-code-literal:#d2a8ff}}.wp-block-code.ssh-code-block{box-sizing:border-box;overflow:auto;padding:0;border:1px solid var(--ssh-code-border);border-radius:var(--ssh-code-radius);background:var(--ssh-code-bg);color:var(--ssh-code-text)}.wp-block-code.ssh-code-block>code.ssh-highlighted{display:block;box-sizing:border-box;overflow-x:auto;padding:var(--ssh-code-padding);background:0 0;color:inherit;font-family:var(--ssh-code-font);font-size:var(--ssh-code-font-size,.95rem);line-height:var(--ssh-code-line-height,1.6);white-space:pre;tab-size:var(--ssh-code-tab-size,4);text-indent:0!important;letter-spacing:normal!important;word-spacing:normal!important;font-variant-ligatures:none}.wp-block-code.ssh-code-block>code.ssh-highlighted{counter-reset:ssh-line}.wp-block-code.ssh-code-block{position:relative}.wp-block-code.ssh-code-block>code.ssh-highlighted{padding-top:var(--ssh-code-padding)}.wp-block-code.ssh-code-block .ssh-copy-button{position:absolute!important;z-index:2!important;top:10px!important;right:10px!important;display:inline-flex!important;visibility:visible!important;align-items:center;gap:6px;width:auto!important;height:auto!important;padding:6px 9px!important;border:0!important;border-radius:6px!important;box-shadow:none!important;background:var(--ssh-code-bg)!important;color:var(--ssh-code-text)!important;font:12px/1.2 system-ui,sans-serif!important;opacity:.85}.wp-block-code.ssh-code-block:not(.ssh-wrap-lines)>code.ssh-highlighted{white-space:pre!important}.wp-block-code.ssh-code-block{position:relative!important;isolation:isolate;background-color:var(--ssh-code-bg)!important;color:var(--ssh-code-text)!important;border-width:var(--ssh-code-border-width,0)!important;border-style:var(--ssh-code-border-style,solid)!important;border-color:var(--ssh-code-border,transparent)!important}.wp-block-code.ssh-code-block>code.ssh-highlighted{position:relative;z-index:1;background:0 0!important;color:inherit!important}.wp-block-code.ssh-code-block .ssh-copy-button{z-index:3!important;background-color:var(--ssh-code-bg)!important;color:var(--ssh-code-text)!important}.wp-block-code.ssh-code-block>code.ssh-highlighted::first-line{text-indent:0!important;letter-spacing:normal!important;word-spacing:normal!important;font:inherit!important}.ssh-highlighted,.wp-block-code.ssh-code-block{--ssh-code-bg:#f6f8fa;--ssh-code-text:#24292f;--ssh-code-border:transparent;
21--ssh-code-border-width:0px;--ssh-code-border-style:solid;--ssh-code-keyword:#cf222e;--ssh-code-string:#0a3069;--ssh-code-comment:#6e7781;--ssh-code-number:#cf222e;--ssh-code-literal:#0a3069;--ssh-code-line-number:#6e7781;--ssh-code-highlight:#f6f8fa;--ssh-code-font:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;--ssh-code-font-size:0.875rem;--ssh-code-line-height:1.6;--ssh-code-padding:1rem;--ssh-code-radius:8px;--ssh-code-tab-size:4}.ssh-highlighted{color:#333}@media (prefers-color-scheme:dark){.ssh-highlighted,.wp-block-code.ssh-code-block{--ssh-code-bg:#282a36;--ssh-code-text:#f8f8f2;--ssh-code-border:transparent;--ssh-code-border-width:0px;--ssh-code-border-style:solid;--ssh-code-keyword:#ff79c6;--ssh-code-string:#f1fa8c;--ssh-code-comment:#6272a4;--ssh-code-number:#ff79c6;--ssh-code-literal:#f1fa8c;--ssh-code-line-number:#6272a4;--ssh-code-highlight:#282a36;--ssh-code-font:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;--ssh-code-font-size:0.875rem;
21--ssh-code-line-height:1.6;--ssh-code-padding:1rem;--ssh-code-radius:8px;--ssh-code-tab-size:4}.ssh-highlighted{color:#f8f8f2}}</style>
22<link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://www.sqlservertutorial.net/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.sqlservertutorial.net%2Fsql-server-basics%2F" /><link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://www.sqlservertutorial.net/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.sqlservertutorial.net%2Fsql-server-basics%2F&#038;format=xml" />
23<style id="wp-img-auto-sizes-contain-inline-css">
24img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px}
25/*# sourceURL=wp-img-auto-sizes-contain-inline-css */
26</style>
27<style id="wp-block-library-inline-css">
28: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;
28--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}}
29
30/*# sourceURL=/wp-includes/css/dist/block-library/common.min.css */
31</style>
32<style id="wp-block-heading-inline-css">
33h1:where(.wp-block-heading).has-background,h2:where(.wp-block-heading).has-background,h3:where(.wp-block-heading).has-background,h4:where(.wp-block-heading).has-background,h5:where(.wp-block-heading).has-background,h6:where(.wp-block-heading).has-background{padding:1.25em 2.375em}h1.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h1.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h2.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h2.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h3.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h3.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h4.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h4.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h5.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h5.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h6.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h6.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]){rotate:180deg}
34/*# sourceURL=https://www.sqlservertutorial.net/wp-includes/blocks/heading/style.min.css */
35</style>
36<style id="wp-block-list-inline-css">
37ol,ul{box-sizing:border-box}:root :where(.wp-block-list.has-background){padding:1.25em 2.375em}
38/*# sourceURL=https://www.sqlservertutorial.net/wp-includes/blocks/list/style.min.css */
39</style>
40<style id="wp-block-paragraph-inline-css">
41.is-small-text{font-size:.875em}.is-regular-text{font-size:1em}.is-large-text{font-size:2.25em}.is-larger-text{font-size:3em}.has-drop-cap:not(:focus):first-letter{float:left;font-size:8.4em;font-style:normal;font-weight:100;line-height:.68;margin:.05em .1em 0 0;text-transform:uppercase}body.rtl .has-drop-cap:not(:focus):first-letter{float:none;margin-left:.1em}p.has-drop-cap.has-background{overflow:hidden}:root :where(p.has-background){padding:1.25em 2.375em}:where(p.has-text-color:not(.has-link-color)) a{color:inherit}p.has-text-align-left[style*="writing-mode:vertical-lr"],p.has-text-align-right[style*="writing-mode:vertical-rl"]{rotate:180deg}
42/*# sourceURL=https://www.sqlservertutorial.net/wp-includes/blocks/paragraph/style.min.css */
43</style>
44<style id="wp-block-group-inline-css">
45.wp-block-group{box-sizing:border-box}:where(.wp-block-group.wp-block-group-is-layout-constrained){position:relative}
46/*# sourceURL=https://www.sqlservertutorial.net/wp-includes/blocks/group/style.min.css */
47</style>
48
49<style id="classic-theme-styles-inline-css">
50/*! This file is auto-generated */
51.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;
51padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}
52/*# sourceURL=/wp-includes/css/classic-themes.min.css */
53</style>
54
55<style id="global-styles-inline-css">
56: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,0) 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%);
56--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;}
56.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;}
57/*# sourceURL=global-styles-inline-css */
58</style>
59
60<link rel='stylesheet' id='feature-pages-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/46addf847d28c34e9606b5ff49e9d622155956b0a3607eaabb68975f1db878ed.css" media='all' /><link rel='stylesheet' id='hfb-style-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/516d237bc2a3c9767b94710fa89e36ed709e01a3d79402e018e8aac1fd5fa972.css" media='all' /><link rel='stylesheet' id='smart-search-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/a954557bd5b8518caa94ead755b4f79c0dc93a4ac3b0822d7ed6b833b8d33550.css" media='all' /><link rel='stylesheet' id='ev-style-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/14d9c3a04ccb38831a7d347840a91a4d2ab02f8520c888aee93ac9da0bcce9e8.css" media='all' /><link rel='stylesheet' id='ev-svg-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/0edbb60a47a4e09fcd067a7d2217d5ff99c23117bdf91e685bb5ae1a3c928f50.css" media='all' /><link rel='stylesheet' id='ev-color-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/4a68864aaf28af0f3b6cfa5378bbbba28ac9ec9d53d7d13806d8abfa03a18520.css" media='all' /><link rel='stylesheet' id='ev-donation-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/eff9a6e36cacda3a07a0149b25d897ceb43ad4f147bec7ba1364ad01d6ee06ac.css" media='all' /><link rel='stylesheet' id='ev-print-css' href="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/0a212533ac704f244c101c083c313bc110b39df887b453ddee5067152c7bc3c1.css" media='print' /><link rel="https://api.w.org/" href="https://www.sqlservertutorial.net/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://www.sqlservertutorial.net/wp-json/wp/v2/pages/100" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://www.sqlservertutorial.net/xmlrpc.php?rsd" /><meta name="generator" content="WordPress 7.1" /><link rel='shortlink' href='https://www.sqlservertutorial.net/?p=100' />
61<style>		html {			--logo-url: url("https://www.sqlservertutorial.net/wp-content/uploads/sqlservertutorial.svg");			--logo-width: 179px;			--logo-height: 50px;			--feature-image-bg-color:#52b9aa;		}			html[data-theme="dark"] {			--logo-url: url("https://www.sqlservertutorial.net/wp-content/uploads/sqlservertutorial-dark.svg");			--logo-width: 179px;			--logo-height: 50px;		}		html[data-theme='dark'] {  color-scheme: dark;  /*  background color */  --body-bg-color: #171717;  --text-color: #e3e3e3;  --primary-color: #4db2ff;  /* header */  --header-bg-color: #171717;  --header-border-color: #454545;  /* heading color */  --heading-color: #e3e3e3;  --subheading-color: #e3e3e3;  /* Main style */  --link-color: #4db2ff;  --link-color-hover: #0091ff;  --try-it-on-accent-theme: #171717;  /* heading color */  --title-color: #e3e3e3;  /* list item color */  --list-item-color: #e3e3e3;  /* Snippet badge color*/  --badge-bg-color: #e3e3e3;  --badge-color: #323330;  /* Code badge color */  /* footer colors */  --footer-bg-color: #2e2e2e;  --footer-color: #e3e3e3;  --footer-link-color: #e3e3e3;  --footer-link-color-hover: #c7c7c7;  /* ads label color  */  --ads-label-color: #e3e3e3;  /* navbar */  --current-color: #e3e3e3;  --menu-color: #e3e3e3;  --border-color: #454545;  --hover-background-color: #242424;  --menu-background-color: #171717;  --submenu-bg-color: #2e2e2e;  --toggle-color: #242424;  /* button colors */  --button-bg-color: #282828;  --button-color: #e3e3e3;  --button-bg-color-hover: #323330;  --button-color-hover: #e3e3e3;  --button-border-color: #282828;  /* section */  --section-border-color: #454545;  /* code in the content */  --inline-code-bg-color: #454545;  --inline-code-color: #e3e3e3;  /* form */  --input-bg-color: #2e2e2e;  --input-color: #e3e3e3;  --input-border-color: #e3e3e3;  --input-border-focus-color: #4db2ff;  /* reverse image for dark mode */  --image-filter: grayscale(50%);  /* previous / next page navigation */  --page-nav-bg-color: inherit;  --mark-bg-color: #454545;  /* feature image*/  --feature-image-bg-color: #282828;  --feature-image-filter: grayscale(50%);  --fancy-list-color: #e3e3e3;  --output-bg-color: #2e2e2e;  --output-border-color: #2e2e2e;  --svg-color: #f4f4f4;  --themeable-image-filter: invert(1) sepia(0) saturate(1) hue-rotate(0deg);	  --highlight-bg: #282C34;  --highlight-img-filter:  brightness(0) invert(1);  --highlight-label: #727272;}</style><style media="print">.site-main:before {					content: url("https://www.sqlservertutorial.net/wp-content/uploads/sqlservertutorial.svg");					display: block;					margin-right: auto;					margin-left: auto;					text-align: center;
61					max-width:200px;								}</style>
62<script src="https://increaserev.com/ads/ob/tage/aaw.sqlservertutorial.js" async></script>
vendor: 67 bytes, lines 62-66
62
63
64
65
66<script async src="https://www.googletagmanager.com/gtag/js?id=
66G-S3HTFEZV8K
vendor: 12 bytes, line 66
66"></script>
67<script>
68  
vendor: 134 bytes, lines 68-72
68window.dataLayer = window.dataLayer || [];
69  function gtag(){dataLayer.push(arguments);}
70  gtag('js', new Date());
71
72  gtag('config', '
72G-S3HTFEZV8K
vendor: 4 bytes, line 72
72');
73</script>
73<link rel="icon" href="https://www.sqlservertutorial.net/wp-content/uploads/cropped-favicon-1-32x32.png" sizes="32x32" /><link rel="icon" href="https://www.sqlservertutorial.net/wp-content/uploads/cropped-favicon-1-192x192.png" sizes="192x192" /><link rel="apple-touch-icon" href="https://www.sqlservertutorial.net/wp-content/uploads/cropped-favicon-1-180x180.png" /><meta name="msapplication-TileImage" content="https://www.sqlservertutorial.net/wp-content/uploads/cropped-favicon-1-270x270.png" /></head><body class="wp-singular page-template-default page page-id-100 page-parent wp-theme-evolution"><div id="page" class="site"><a class="skip-link screen-reader-text" href="#primary">Skip to content</a><header id="masthead" class="site-header"><div class="wrap header-wrapper"><div class="site-branding"><a href="https://www.sqlservertutorial.net" rel="home" aria-current="page" class="logo" aria-label="Go to the homepage"></a></div><nav id="site-navigation" class="site-navigation"><ul id="primary-menu" class="site-menu"><li id="menu-item-26" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home menu-item-26"><a href="https://www.sqlservertutorial.net/">Home</a></li><li id="menu-item-399" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-399"><a href="https://www.sqlservertutorial.net/getting-started/">Start Here</a></li><li id="menu-item-105" class="menu-item menu-item-type-post_type menu-item-object-page current-menu-item page_item page-item-100 current_page_item menu-item-105"><a href="https://www.sqlservertutorial.net/sql-server-basics/" aria-current="page">Basics</a></li><li id="menu-item-2771" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-2771"><a href="#" role="button">Advanced</a><ul class="sub-menu"><li id="menu-item-2575" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2575"><a href="https://www.sqlservertutorial.net/sql-server-views/">Views</a></li><li id="menu-item-2576" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2576"><a href="https://www.sqlservertutorial.net/sql-server-indexes/">Indexes</a></li><li id="menu-item-2579" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2579"><a href="https://www.sqlservertutorial.net/sql-server-triggers/">Triggers</a></li><li id="menu-item-2577" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2577"><a href="https://www.sqlservertutorial.net/sql-server-stored-procedures/">Stored Procedures</a></li><li id="menu-item-2578" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2578"><a href="https://www.sqlservertutorial.net/sql-server-user-defined-functions/">User-defined Functions</a></li></ul></li><li id="menu-item-3970" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-3970"><a href="#" role="button">API</a><ul class="sub-menu"><li id="menu-item-3971" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3971"><a href="https://www.sqlservertutorial.net/nodejs-sql-server/">Node.js</a></li><li id="menu-item-4132" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-4132"><a href="https://www.sqlservertutorial.net/python-sql-server/">Python</a></li><li id="menu-item-4393" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-4393"><a href="https://www.sqlservertutorial.net/php-sql-server/">PHP</a></li><li id="menu-item-4295" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-4295"><a href="https://www.sqlservertutorial.net/java-sql-server/">Java</a></li><li id="menu-item-4532" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-4532"><a href="https://www.sqlservertutorial.net/go-sql-server/">Go (Golang)</a></li></ul></li><li id="menu-item-2772" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-2772"><a href="#" role="button">Functions</a><ul class="sub-menu"><li id="menu-item-2570" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2570"><a href="https://www.sqlservertutorial.net/sql-server-aggregate-functions/">Aggregate Functions</a></li><li id="menu-item-2574" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2574"><a href="https://www.sqlservertutorial.net/sql-server-window-functions/">Window Functions</a></li><li id="menu-item-2571" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2571"><a href="https://www.sqlservertutorial.net/sql-server-date-functions/">Date Functions</a></li><li id="menu-item-2572" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2572"><a href="https://www.sqlservertutorial.net/sql-server-string-functions/">String Functions</a></li><li id="menu-item-2573" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2573"><a href="https://www.sqlservertutorial.net/sql-server-system-functions/">System Functions</a></li><li id="menu-item-3538" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3538"><a href="https://www.sqlservertutorial.net/sql-server-json-functions/">JSON Functions</a></li><li id="menu-item-3784" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3784"><a href="https://www.sqlservertutorial.net/sql-server-math-functions/">Math Functions</a></li></ul></li><li id="menu-item-3192" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3192"><a href="https://www.sqlservertutorial.net/sql-server-administration/">Administration</a></li></ul><a class="switch-theme" title="Toggle dark mode" href="#"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="dark-mode-icon" viewB
73ox="0 0 16 16"><path d="M6 .278a.768.768 0 0 1 .08.858 7.208 7.208 0 0 0-.878 3.46c0 4.021 3.278 7.277 7.318 7.277.527 0 1.04-.055 1.533-.16a.787.787 0 0 1 .81.316.733.733 0 0 1-.031.893A8.349 8.349 0 0 1 8.344 16C3.734 16 0 12.286 0 7.71 0 4.266 2.114 1.312 5.124.06A.752.752 0 0 1 6 .278zM4.858 1.311A7.269 7.269 0 0 0 1.025 7.71c0 4.02 3.279 7.276 7.319 7.276a7.316 7.316 0 0 0 5.205-2.162c-.337.042-.68.063-1.029.063-4.61 0-8.343-3.714-8.343-8.29 0-1.167.242-2.278.681-3.286z"/><path d="M10.794 3.148a.217.217 0 0 1 .412 0l.387 1.162c.173.518.579.924 1.097 1.097l1.162.387a.217.217 0 0 1 0 .412l-1.162.387a1.734 1.734 0 0 0-1.097 1.097l-.387 1.162a.217.217 0 0 1-.412 0l-.387-1.162A1.734 1.734 0 0 0 9.31 6.593l-1.162-.387a.217.217 0 0 1 0-.412l1.162-.387a1.734 1.734 0 0 0 1.097-1.097l.387-1.162zM13.863.099a.145.145 0 0 1 .274 0l.258.774c.115.346.386.617.732.732l.774.258a.145.145 0 0 1 0 .274l-.774.258a1.156 1.156 0 0 0-.732.732l-.258.774a.145.145 0 0 1-.274 0l-.258-.774a1.156 1.156 0 0 0-.732-.732l-.774-.258a.145.145 0 0 1 0-.274l.774-.258c.346-.115.617-.386.732-.732L13.863.1z"/></svg><svg  xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="light-mode-icon" viewBox="0 0 16 16"><path d="M8 11a3 3 0 1 1 0-6 3 3 0 0 1 0 6zm0 1a4 4 0 1 0 0-8 4 4 0 0 0 0 8zM8 0a.5.5 0 0 1 .5.5v2a.5.5 0 0 1-1 0v-2A.5.5 0 0 1 8 0zm0 13a.5.5 0 0 1 .5.5v2a.5.5 0 0 1-1 0v-2A.5.5 0 0 1 8 13zm8-5a.5.5 0 0 1-.5.5h-2a.5.5 0 0 1 0-1h2a.5.5 0 0 1 .5.5zM3 8a.5.5 0 0 1-.5.5h-2a.5.5 0 0 1 0-1h2A.5.5 0 0 1 3 8zm10.657-5.657a.5.5 0 0 1 0 .707l-1.414 1.415a.5.5 0 1 1-.707-.708l1.414-1.414a.5.5 0 0 1 .707 0zm-9.193 9.193a.5.5 0 0 1 0 .707L3.05 13.657a.5.5 0 0 1-.707-.707l1.414-1.414a.5.5 0 0 1 .707 0zm9.193 2.121a.5.5 0 0 1-.707 0l-1.414-1.414a.5.5 0 0 1 .707-.707l1.414 1.414a.5.5 0 0 1 0 .707zM4.464 4.465a.5.5 0 0 1-.707 0L2.343 3.05a.5.5 0 1 1 .707-.707l1.414 1.414a.5.5 0 0 1 0 .708z"/></svg></a><button class="menu-toggle" aria-controls="primary-menu" aria-expanded="false" aria-label="Primary Menu"></button></nav></div></header><div class="left-column"><div class="sticky"><div data-aaad='true' data-aa-adunit='/21722279357/120x600_OB_sqlservertutorial_desk'></div></div></div><main id="primary" class="site-main"><p class="breadcrumbs"><span><span><a href="https://www.sqlservertutorial.net/">Home</a></span> » <span class="breadcrumb_last" aria-current="page">SQL Server Basics</span></span></p><article id="post-100" class="post-100 page type-page status-publish has-post-thumbnail hentry"><header class="entry-header"><h1 class="entry-title">SQL Server Basics</h1></header><div class="entry-content"><div class="whitelist"><div class="ads ad-336"><div data-aaad='true' data-aa-adunit='/21722279357/336x280_OB_sqlservertutorial_3_M'></div></div></div><div style="margin:18px 0 28px;"><a
74    href="https://apps.apple.com/us/app/savigo-savings-goals/id6756600696?utm_source=sqltutorial&utm_medium=inline&utm_campaign=savigo"
75    target="_blank"
76    rel="noopener noreferrer"
77    aria-label="Get Savigo for iPhone"
78    style="
79      display:flex;
80      align-items:center;
81      flex-wrap:wrap;
82      gap:14px;
83      padding:16px;
84      border:1px solid var(--border-color);
85      border-radius:12px;
86      color:inherit;
87      text-decoration:none;
88    "
89  ><img
90      src="https://www.duypham.app/wp-content/uploads/2026/08/savigo-logo-mark.svg"
91      alt="Savigo"
92      width="48"
93      height="48"
94      loading="lazy"
95      style="
96        display:block;
97        width:48px;
98        height:48px;
99        border-radius:12px;
100        flex:0 0 48px;
101      "
102    ><div style="flex:1 1 260px;min-width:0;"><div
103        style="
104          font-size:16px;
105          line-height:1.35;
106          font-weight:700;
107          letter-spacing:-0.01em;
108        "
109      >
110        You organize your data. Now organize your savings.
111      </div><div
112        style="
113          margin-top:4px;
114          font-size:13px;
115          line-height:1.5;
116          opacity:.7;
117        "
118      >
119        Set savings goals, track your progress, and stay on course.
120      </div></div><span
121      class="savigo-action"
122      style="
123        display:inline-flex;
124        align-items:center;
125        justify-content:center;
126        flex:0 0 auto;
127        min-height:36px;
128        padding:0 15px;
129        border:1px solid #12b981;
130        border-radius:999px;
131        background-color:#12b981;
132        color:#ffffff;
133        font-size:13px;
134        line-height:1;
135        font-weight:700;
136        white-space:nowrap;
137        box-shadow:0 2px 6px rgba(18,185,129,.22);
138        transition:
139          background-color .18s ease,
140          border-color .18s ease,
141          box-shadow .18s ease,
142          transform .18s ease;
143      "
144    >
145      Get Savigo for iPhone&nbsp;<span aria-hidden="true">›</span></span></a></div>
146
147<style>
148  a:hover .savigo-action,
149  a:focus-visible .savigo-action {
150    background-color:#0fa572 !important;
151    border-color:#0fa572 !important;
152    box-shadow:0 4px 10px rgba(18,185,129,.3) !important;
153    transform:translateY(-1px);
154  }
155
156  a:active .savigo-action {
157    transform:translateY(0);
158    box-shadow:0 2px 5px rgba(18,185,129,.22) !important;
159  }
160
161  @media (prefers-reduced-motion: reduce) {
162    .savigo-action {
163      transition:none !important;
164    }
165  }
166</style>
167<div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='querying-data'>Section 1. Querying data <a href="#querying-data" class="anchor" id="querying-data" title="Anchor for Section 1. Querying data">#</a></h2><p class="wp-block-paragraph">This section teaches you how to query data from an SQL Server database. We’ll begin with a simple query that retrieves data from a single table.</p><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select/">SELECT</a>&nbsp;– show you how to query data against a single table.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='sorting-data'>Section 2. Sorting data <a href="#sorting-data" class="anchor" id="sorting-data" title="Anchor for Section 2. Sorting data">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-order-by/">ORDER BY</a>&nbsp;– sort the result set based on values in a specified list of columns</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='limiting-rows'>Section 3. Limiting rows <a href="#limiting-rows" class="anchor" id="limiting-rows" title="Anchor for Section 3. Limiting rows">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/">OFFSET FETCH</a> &#8211; limit the number of rows returned by a query.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select-top/">SELECT TOP</a> &#8211; limit the number of rows or percentage of rows returned in a query&#8217;s result set.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='filtering-data'>Section 4. Filtering data <a href="#filtering-data" class="anchor" id="filtering-data" title="Anchor for Section 4. Filtering data">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select-distinct/">DISTINCT</a> &nbsp;&#8211; select distinct values in one or more columns of a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-where/">WHERE</a>&nbsp;– filter rows in the output of a query based on one or more conditions.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-and/">AND</a>&nbsp;– combine two Boolean expressions and return true if all expressions are true.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-or/">OR</a>–  combine two Boolean expressions and return true if either of the conditions is true.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-in/">IN</a>&nbsp;– check whether a value matches any value in a list or a subquery.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-between/">BETWEEN</a>&nbsp;– test if a value is between a range of values.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-like/">LIKE</a> &nbsp;–&nbsp; check if a character string matches a specified pattern.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alias/">Column &amp; table aliases</a> &#8211; show you how to use column aliases to change the heading of the query output and table aliases to improve the readability of a query.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='joining-tables'>Section 5. Joining tables <a href="#joining-tables" class="anchor" id="joining-tables" title="Anchor for Section 5. Joining tables">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-joins/">Joins</a> &#8211; give you a brief overview of joins types in SQL Server including inner join, left join, right join, and full outer join.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-inner-join/">INNER JOIN</a>&nbsp;– select rows from a table that have matching rows in another table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-left-join/">LEFT JOIN</a>&nbsp;– return all rows from the left table and matching rows from the right table. If the right table does not have corresponding rows, use NULL for the column values from the right table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-right-join/">RIGHT JOIN</a> &#8211; learn a reversed version of the left join.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-full-outer-join/">FULL OUTER JOIN</a> &#8211; return matching rows from both left and right tables and rows from each side if no matching rows exist.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cross-join/">CROSS JOIN</a>&nbsp;– join multiple unrelated tables and create Cartesian products of rows in the joined tables.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-self-join/">Self join</a>&nbsp;– show you how to use the&nbsp;self-join to query hierarchical data and compare rows within the same table.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='grouping-data'>Section 6. Grouping data <a href="#grouping-data" class="anchor" id="grouping-data" title="Anchor for Section 6. Grouping data">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-group-by/">GROUP BY</a>– group the query result based on the values in a specified list of column expressions.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-having/">HAVING</a> – specify a search condition for a group or an aggregate.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-grouping-sets/">GROUPING SETS</a> &#8211; generates multiple grouping sets.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cube/">CUBE</a> &#8211; generate grouping sets with all combinations of the dimension columns.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-rollup/">ROLLUP</a> &#8211; generate grouping sets with an assumption of the hierarchy between input columns.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='section-7-subquery'>&nbsp;Section 7. Subquery <a href="#section-7-subquery" class="anchor" id="section-7-subquery" title="Anchor for &nbsp;Section 7. Subquery">#</a></h2><p class="wp-block-paragraph">This section covers subqueries, which are queries nested within another statement, such as SELECT, INSERT, UPDATE, or DELETE.</p><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-subquery/">Subquery</a> – explain the subquery concept and show you how to use various subquery types to select data.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-correlated-subquery/">Correlated subquery</a> &#8211; introduce you to the correlated subquery concept.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-exists/">EXISTS</a>&nbsp;&#8211; test for the existence of rows returned by a subquery.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-any/">ANY</a> &#8211; compare a value with a single-column set of values returned by a subquery and return TRUE if the value matches any value in the set.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-all/">ALL</a> &#8211; compare a value with a single-column set of values returned by a subquery and return TRUE if the value matches all values in the set.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cross-apply/">CROSS APPLY</a> &#8211; perform an inner join of a table with a table-valued function or a correlated subquery.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-outer-appl
167y/">OUTER APPLY</a> &#8211; perform a left join of a table with a table-valued function or a correlated subquery.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='set-operators'>Section 8. Set Operators <a href="#set-operators" class="anchor" id="set-operators" title="Anchor for Section 8. Set Operators">#</a></h2><p class="wp-block-paragraph">This section guides you through the steps of using set operators, including union, intersect, and except, to combine multiple result sets from input queries.</p><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-union/">UNION</a> – combine the result sets of two or more queries into a single result set.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-intersect/">INTERSECT</a> &#8211; return the intersection of the result sets of two or more queries.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-except/">EXCEPT</a> &#8211; find the difference between the two result sets of two input queries.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='common-table-expression-cte'>Section 9. Common Table Expression (CTE) <a href="#common-table-expression-cte" class="anchor" id="common-table-expression-cte" title="Anchor for Section 9. Common Table Expression (CTE)">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cte/">CTE</a> &#8211; use common table expressions to make complex queries more readable.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-recursive-cte/">Recursive CTE</a> &#8211; query hierarchical data using recursive CTE.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='pivot'>Section 10. Pivot <a href="#pivot" class="anchor" id="pivot" title="Anchor for Section 10. Pivot">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-pivot/">PIVOT</a> &#8211; convert rows to columns</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='modifying-data'>Section 11. Modifying data <a href="#modifying-data" class="anchor" id="modifying-data" title="Anchor for Section 11. Modifying data">#</a></h2><p class="wp-block-paragraph">In this section, you will learn how to modify data in the database using Data Manipulation Language (DML), which includes SQL commands such as INSERT, DELETE, and UPDATE.</p><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert/">INSERT</a>&nbsp;– insert a row into a table</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-multiple-rows/">INSERT multiple rows</a> &#8211; insert multiple rows into a table using a single INSERT statement</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-into-select/">INSERT INTO SELECT</a> &#8211; insert data that comes from the result set of a query into a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-update/">UPDATE</a>&nbsp;– change the existing values in a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-update-join/">UPDATE JOIN</a> &#8211; update values in a table based on values from another table using JOIN clauses.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-delete/">DELETE</a>&nbsp;– delete one or more rows of a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-merge/">MERGE</a> &#8211; walk you through the steps of performing a mixture of insertion, update, and deletion using a single statement.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-transaction/">Transaction</a> &#8211; show you how to start a transaction explicitly using the BEGIN TRANSACTION, COMMIT, and ROLLBACK statements</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='data-definition'>Section 12. Data definition <a href="#data-definition" class="anchor" id="data-definition" title="Anchor for Section 12. Data definition">#</a></h2><p class="wp-block-paragraph">This section shows you how to manage the most important database objects including databases and tables.</p><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-create-database/">CREATE DATABASE</a> &#8211; show you how to create a new database in an SQL Server instance using the CREATE DATABASE statement and SQL Server Management Studio.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-database/">DROP DATABASE</a> &#8211; learn how to delete existing databases.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-create-schema/">CREATE SCHEMA</a> &#8211; describe how to create a new schema in a database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-schema/">ALTER SCHEMA</a> &#8211; show how to transfer a securable from one schema to another within the same database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-schema/">DROP SCHEMA</a> &#8211; learn how to delete a schema from a database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-create-table/">CREATE TABLE</a>
167 – walk you through the steps of creating a new table in a specific schema of a database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-identity/">Identity column</a> &#8211; learn how to use the IDENTITY property to create the identity column for a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-sequence/">Sequence</a> &#8211; describe how to generate a sequence of numeric values based on a specification.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-add-column/">ALTER TABLE ADD column</a> &#8211; show you how to add one or more columns to an existing table</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/">ALTER TABLE ALTER COLUMN</a> &#8211; show you how to change the definition of existing columns in a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-drop-column/">ALTER TABLE DROP COLUMN</a> &#8211; learn how to drop one or more columns from a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-computed-columns/">Computed columns</a> &#8211; how to use the computed columns to reuse the calculation logic in multiple queries.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-table/">DROP TABLE</a>&nbsp;– show you how to delete tables from the database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-truncate-table/">TRUNCATE TABLE</a>&nbsp;– delete all data from a table faster and more efficiently.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select-into/">SELECT INTO</a> &#8211; learn how to create a table and insert data from a query into it.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-rename-table/">Rename a table</a>&nbsp;– &nbsp;walk you through the process of renaming a table to a new one.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-temporary-tables/">Temporary tables</a> &#8211; introduce you to the temporary tables for storing temporary immediate data in stored procedures or database sessions.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-synonym/">Synonym</a> &#8211; explain the synonym and show you how to create synonyms for database objects.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='sql-server-data-types'>Section 13. SQL Server Data Types <a href="#sql-server-data-types" class="anchor" id="sql-server-data-types" title="Anchor for Section 13. SQL Server Data Types">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-data-types/">SQL Server data types</a>&nbsp;– give you an overview of the built-in SQL Server data types.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-bit/">BIT</a> &#8211; store bit data i.e., 0, 1, or NULL in the database with the BIT data type.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-int/">INT</a> &#8211; learn about various integer types in SQL server including BIGINT, INT, SMALLINT, and TINYINT.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-decimal/">DECIMAL</a> &#8211; show you how to store exact numeric values in the database by using DECIMAL or NUMERIC data type.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-char/">CHAR</a> &#8211; learn how to store fixed-length, non-Unicode character strings in the database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-nchar/">NCHAR</a> &#8211;  show you how to store fixed-length, Unicode character strings and explains the differences between <code>CHAR</code> and <code>NCHAR</code> data types</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-varchar/">VARCHAR</a> &#8211; store variable-length, non-Unicode string data in the database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-nvarchar/">NVARCHAR</a> &#8211; learn how to store variable-length, Unicode string data in a table and understand the main differences between VARCHAR and NVARCHAR.<
167/li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-datetime2/">DATETIME2</a> &#8211; illustrate how to store both date and time data in a database.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-date/">DATE</a>&nbsp;–&nbsp;discuss the date data type and how to store the dates in the table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-time/">TIME</a> &#8211; show you how to store time data in the database by using the TIME data type.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-datetimeoffset/">DATETIMEOFFSET</a> &#8211; show you how to manipulate datetime with the time zone.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-guid/">GUID</a> &#8211; learn about the GUID and how to use the NEWID() function to generate GUID values.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='constraints'>Section 14. Constraints <a href="#constraints" class="anchor" id="constraints" title="Anchor for Section 14. Constraints">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-primary-key/">Primary key</a>  – explain the primary key concept and show you how to use the primary key constraint to manage the primary key of a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-foreign-key/">Foreign key</a> – introduce you to the foreign key concept and show you use the <code>FOREIGN KEY</code> constraint to enforce the link of data in two tables.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-not-null-constraint/">NOT NULL constraint</a> &#8211; show you how to ensure a column does not accept NULL.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-unique-constraint/">UNIQUE constraint</a>&nbsp;&#8211; ensure that data contained in a column, or a group of columns, is unique among rows in a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-check-constraint/">CHECK constraint</a> – walk you through the process of adding logic for checking data before storing them in tables.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='expressions'>Section 15. Expressions <a href="#expressions" class="anchor" id="expressions" title="Anchor for Section 15. Expressions">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-case/">CASE</a> &#8211; add if-else logic to SQL queries by using simple and searched CASE expressions.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-coalesce/">COALESCE</a> &#8211; handle NULL values effectively using the COALESCE expression.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-nullif/">NULLIF</a> &#8211; return NULL if the two arguments are equal; otherwise, return the first argument.</li></ul></div></div><div class="wp-block-group"><div class="wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow"><h2 class="wp-block-heading" id='useful-tips'>Section 16. Useful Tips <a href="#useful-tips" class="anchor" id="useful-tips" title="Anchor for Section 16. Useful Tips">#</a></h2><ul class="wp-block-list"><li><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-find-duplicates/">Find duplicates</a> &#8211; show you how to find duplicate values in one or more columns of a table.</li><li><a href="https://www.sqlservertutorial.net/sql-server-basics/delete-duplicates-sql-server/">Delete duplicates</a> &#8211; describe how to remove duplicate rows from a table.</li></ul></div></div><section class="hfb-container hfb-style-minimal hfb-layout-inline hfb-align-center" data-post-id="100" aria-label="Page feedback"><div class="hfb-question"><p class="hfb-message">Was this tutorial helpful?</p><div class="hfb-buttons" role="group" aria-label="Was this tutorial helpful?"><button type="button" class="hfb-btn hfb-btn-yes" data-sentiment="positive" aria-pressed="false">
167<svg class="hfb-icon" viewBox="0 0 12 12" fill="none" aria-hidden="true" focusable="false"><path d="M3.5 11H2a1 1 0 0 1-1-1V6.5a1 1 0 0 1 1-1h1.5m3.5-1v-2A1.5 1.5 0 0 0 5.5 1l-2 4.5V11h5.64a1 1 0 0 0 1-.85l.69-4.5a1 1 0 0 0-1-1.15H7Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"/></svg><span>Yes</span></button><button type="button" class="hfb-btn hfb-btn-no" data-sentiment="negative" aria-pressed="false"><svg class="hfb-icon" viewBox="0 0 12 12" fill="none" aria-hidden="true" focusable="false"><path d="M3.5 1H2a1 1 0 0 0-1 1v3.5a1 1 0 0 0 1 1h1.5m3.5 1v2A1.5 1.5 0 0 1 5.5 11l-2-4.5V1h5.64a1 1 0 0 1 1 .85l.69 4.5a1 1 0 0 1-1 1.15H7Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"/></svg><span>No</span></button></div></div><div class="hfb-form-container" hidden><form class="hfb-feedback-form" novalidate><label for="hfb-feedback-message-100-1">Please help us improve</label>
168                    <textarea id="hfb-feedback-message-100-1" name="feedback_message" rows="4" maxlength="1000"></textarea>
169                    <div class="hfb-form-actions"><button type="submit" class="hfb-btn hfb-btn-submit">Submit Feedback</button><button type="button" class="hfb-btn-cancel">Cancel</button></div></form></div><div class="hfb-status" role="status" aria-live="polite"></div><div class="hfb-thank-you" hidden><p>Thank you for your feedback!</p></div><input type="hidden" class="hfb-form-display-mode" value="negative"></section><div class="ad ad-336"><div data-aaad='true' data-aa-adunit='/21722279357/336x280_OB_postgresqltutorial_2'></div></div></div></article><nav class="page-nav" aria-label="Page navigation"><div class="prev-page"><a class="prev-page-anchor" href="https://www.sqlservertutorial.net/getting-started/load-sample-database/"><div class="page-nav-arrow" aria-hidden="true"><img src="https://www.sqlservertutorial.net/wp-content/themes/evolution/img/left.svg" height="32" width="32" class="icon-prev-page" alt=""></div><div class="page-nav-main page-nav-first"><div class="page-nav-title">Previous</div><div class="page-title">Load Sample Database</div></div></a></div><div class="next-page"><a class="next-page-anchor" href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select/"><div class="page-nav-main page-nav-second"><div class="page-nav-title">Up next</div><div class="page-title">SQL Server SELECT</div></div><div class="page-nav-arrow" aria-hidden="true"><img src="https://www.sqlservertutorial.net/wp-content/themes/evolution/img/right.svg" height="32" width="32" class="icon-next-page" alt=""></div></a></div></nav></main><aside id="secondary" class="widget-area sidebar"><section id="search-2" class="widget widget_search"><div class="smart-search-native smart-search-native--widget"><div class="smart-search smart-search--overlay smart-search--comfortable smart-search--scheme-auto smart-search--appearance-follow-theme smart-search--shape-soft" style="--ss-radius:10px;--ss-accent:#2563eb;--ss-custom-bg:#ffffff;--ss-custom-fg:#172033;--ss-custom-border:#d0d5dd;--ss-light-box-background:#ffffff;--ss-light-box-text:#172033;--ss-light-box-placeholder:#667085;--ss-light-box-border:#d0d5dd;--ss-light-popup-background:#ffffff;--ss-light-popup-text:#172033;--ss-light-popup-muted:#667085;--ss-light-popup-border:#d0d5dd;--ss-light-accent:#2563eb;--ss-light-hover:#eff6ff;--ss-dark-box-background:#2e2e2e;--ss-dark-box-text:#e3e3e3;--ss-dark-box-placeholder:#b8b8b8;--ss-dark-box-border:#454545;--ss-dark-popup-background:#171717;--ss-dark-popup-text:#e3e3e3;--ss-dark-popup-muted:#a9a9a9;--ss-dark-popup-border:#454545;--ss-dark-accent:#4db2ff;--ss-dark-hover:#242424;--ss-box-border-width:1px;--ss-popup-border-width:1px;--ss-box-radius:10px;--ss-popup-radius:12px;--ss-custom-shadow:0 16px 40px rgba(16,24,40,.18)" data-smart-search data-config="{&quot;indexUrl&quot;:&quot;\/wp-content\/uploads\/smart-search\/search-index.7a7349a824b7.json&quot;,&quot;appUrl&quot;:&quot;\/wp-content\/plugins\/smart-site-search\/assets\/js\/search-app.js&quot;,&quot;mode&quot;:&quot;overlay&quot;,&quot;nativeFallbackUrl&quot;:&quot;https:\/\/www.sqlservertutorial.net\/?s=&quot;,&quot;appearanceMode&quot;:&quot;follow-theme&quot;,&quot;customSearchSelector&quot;:&quot;&quot;,&quot;queryParameter&quot;:&quot;q&quot;,&quot;minQueryLength&quot;:2,&quot;maxResults&quot;:8,&quot;threshold&quot;:0.320000000000000006661338147750939242541790008544921875,&quot;keyboardShortcuts&quot;:true,&quot;highlightTitle&quot;:true,&quot;openNewTab&quot;:false,&quot;loadingStrategy&quot;:&quot;interaction&quot;,&quot;enableTypeFilters&quot;:true,&quot;enableSnippets&quot;:true,&quot;snippetLength&quot;:180,&quot;synonyms&quot;:[],&quot;analytics&quot;:{&quot;enabled&quot;:false,&quot;provider&quot;:&quot;browser-event&quot;,&quot;minLength&quot;:2},&quot;locale&quot;:&quot;en_US&quot;,&quot;localeFiltering&quot;:false,&quot;messages&quot;:{&quot;loading&quot;:&quot;Loading search\u2026&quot;,&quot;noResults&quot;:&quot;No results found.&quot;,&quot;error&quot;:&quot;Search could not be loaded.&quot;,&quot;allTypes&quot;:&quot;All content&quot;,&quot;results&quot;:&quot;results&quot;,&quot;pages&quot;:&quot;Pages&quot;,&quot;startTyping&quot;:&quot;Start typing to search.&quot;,&quot;recentSearches&quot;:&quot;Recent searches&quot;,&quot;clearRecent&quot;:&quot;Clear&quot;}}"><label class="screen-reader-text" for="smart-search-2">Search</label><div class="smart-search__field"><span class="smart-search__icon" aria-hidden="true"></span><input id="smart-search-2" class="smart-search__input" type="search" placeholder="Search this site…" autocomplete="off" role="combobox" aria-autocomplete="list" aria-expanded="false" aria-controls="smart-search-2-results"><button class="smart-search__clear" type="button" aria-label="Clear search" hidden>×</button></div><div id="smart-search-2-results" class="smart-search__panel" role="listbox" hidden></div><div class="smart-search__status screen-reader-text" aria-live="polite"></div></div></div></section><section id="nav_menu-2" class="widget widget_nav_menu"><h2 class="widget-title">Getting Started</h2><div class="menu-getting-started-container"><ul id="menu-getting-started" class="menu"><li id="menu-item-723" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-723"><a href="https://www.sqlservertutorial.net/getting-started/what-is-sql-server/">What is SQL Server</a></li><li id="menu-item-76" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-76"><a href="https://www.sqlservertutorial.net/getting-started/install-sql-server/">Install the SQL Server</a></li><li id="menu-item-81" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-81"><a href="https://www.sqlservertutorial.net/getting-started/connect-to-the-sql-server/">Connect to the SQL Server</a></li><li id="menu-item-87" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-87"><a href="https://www.sqlservertutorial.net/getting-started/sql-server-sample-database/">SQL Server Sample Database</a></li><li id="menu-item-136" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-136"><a href="https://www.sqlservertutorial.net/getting-started/load-sample-database/">Load Sample Database</a></li></ul></div></section><section id="evolution_ad-22" class="widget widget_evolution_ad"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_sqlservertutorial'></div></div></section><section id="nav_menu-4" class="widget widget_nav_menu"><h2 class="widget-title">Data Manipulation</h2><div class="menu-data-manipulation-container"><ul id="menu-data-manipulation" class="menu"><li id="menu-item-106" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-106"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select/">SELECT</a></li><li id="menu-item-180" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-180"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-order-by/">ORDER BY</a></li><li id="menu-item-488" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-488"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/">OFFSET FETCH</a></li><li id="menu-item-738" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-738"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select-top/">SELECT TOP</a></li><li id="menu-item-179" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-179"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select-distinct/">SELECT DISTINCT</a></li><li id="menu-item-184" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-184"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-where/">WHERE</a></li><li id="menu-item-645" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-645"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-null/">NULL</a></li><li id="menu-item-338" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-338"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-and/">AND</a></li><li id="menu-item-337" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-337"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-or/">OR</a></li><li id="menu-item-299" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-299"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-in/">IN</a></li><li id="menu-item-289" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-289"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-between/">BETWEEN</a></li><li id="menu-item-316" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-316"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-like/">LIKE</a></li><li id="menu-item-218" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-218"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alias/">Column &#038; Table Aliases</a></li><li id="menu-item-1089" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1089"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-joins/">Joins</a></li><li id="menu-item-266" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-266"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-inner-join/">INNER JOIN</a></li><li id="menu-item-265" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-265"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-left-join/">LEFT JOIN</a></li><li id="menu-item-1114" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1114"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-right-join/">RIGHT JOIN</a></li><li id="menu-item-1101" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1101"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-full-outer-join/">FULL OUTER JOIN</a></li><li id="menu-item-281" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-281"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-self-join/">Self Join</a></li>
169<li id="menu-item-348" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-348"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cross-join/">CROSS JOIN</a></li><li id="menu-item-3869" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3869"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cross-apply/">CROSS APPLY</a></li><li id="menu-item-217" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-217"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-group-by/">GROUP BY</a></li><li id="menu-item-221" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-221"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-having/">HAVING</a></li><li id="menu-item-667" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-667"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-grouping-sets/">GROUPING SETS</a></li><li id="menu-item-756" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-756"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cube/">CUBE</a></li><li id="menu-item-755" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-755"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-rollup/">ROLLUP</a></li><li id="menu-item-447" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-447"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-subquery/">Subquery</a></li><li id="menu-item-455" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-455"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-correlated-subquery/">Correlated Subquery</a></li><li id="menu-item-423" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-423"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-exists/">EXISTS</a></li><li id="menu-item-426" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-426"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-any/">ANY</a></li><li id="menu-item-422" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-422"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-all/">ALL</a></li><li id="menu-item-367" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-367"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-union/">UNION</a></li><li id="menu-item-366" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-366"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-intersect/">INTERSECT</a></li><li id="menu-item-376" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-376"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-except/">EXCEPT</a></li><li id="menu-item-1602" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1602"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-cte/">Common Table Expression (CTE)</a></li><li id="menu-item-1601" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1601"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-recursive-cte/">Recursive CTE</a></li><li id="menu-item-521" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-521"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert/">INSERT</a></li><li id="menu-item-520" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-520"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-multiple-rows/">INSERT Multiple Rows</a></li><li id="menu-item-519" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-519"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-into-select/">INSERT INTO SELECT</a></li><li id="menu-item-647" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-647"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-update/">UPDATE</a></li><li id="menu-item-1876" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1876"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-update-join/">UPDATE JOIN</a></li><li id="menu-item-648" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-648"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-delete/">DELETE</a></li><li id="menu-item-1721" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1721"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-merge/">MERGE</a></li><li id="menu-item-1735" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1735"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-pivot/">PIVOT</a></li><li id="menu-item-3217" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3217"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-transaction/">Transaction</a></li></ul></div></section><section id="evolution_ad-23" class="widget widget_evolution_ad"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_sqlservertutorial_2'></div></div></section><section id="nav_menu-5" class="widget widget_nav_menu"><h2 class="widget-title">Data Definition</h2><div class="menu-data-definition-language-container"><ul id="menu-data-definition-language" class="menu"><li id="menu-item-1649" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1649"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-create-database/">Create New Database</a></li><li id="menu-item-1648" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1648"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-database/">Drop Database</a></li><li id="menu-item-1975" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1975"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-create-schema/">Create Schema</a></li>
169<li id="menu-item-1974" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1974"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-schema/">Alter Schema</a></li><li id="menu-item-1973" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1973"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-schema/">Drop Schema</a></li><li id="menu-item-583" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-583"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-create-table/">Create New Table</a></li><li id="menu-item-582" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-582"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-identity/">Identity Column</a></li><li id="menu-item-1896" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1896"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-sequence/">Sequence</a></li><li id="menu-item-578" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-578"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-add-column/">Add Column</a></li><li id="menu-item-576" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-576"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/">Modify Column</a></li><li id="menu-item-577" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-577"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-drop-column/">Drop Column</a></li><li id="menu-item-1884" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1884"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-computed-columns/">Computed Columns</a></li><li id="menu-item-579" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-579"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-rename-table/">Rename Table</a></li><li id="menu-item-581" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-581"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-drop-table/">Drop Table</a></li><li id="menu-item-580" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-580"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-truncate-table/">Truncate Table</a></li><li id="menu-item-848" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-848"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-temporary-tables/">Temporary Tables</a></li><li id="menu-item-1981" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1981"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-synonym/">Synonym</a></li><li id="menu-item-1673" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1673"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-select-into/">SELECT INTO</a></li><li id="menu-item-653" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-653"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-primary-key/">PRIMARY KEY</a></li><li id="menu-item-652" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-652"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-foreign-key/">FOREIGN KEY</a></li><li id="menu-item-651" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-651"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-check-constraint/">CHECK Constraint</a></li><li id="menu-item-650" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-650"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-unique-constraint/">UNIQUE Constraint</a></li><li id="menu-item-649" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-649"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-not-null-constraint/">NOT NULL Constraint</a></li></ul></div></section><section id="evolution_ad-24" class="widget widget_evolution_ad"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_postgresqltutorial_2'></div></div></section><section id="nav_menu-15" class="widget widget_nav_menu"><h2 class="widget-title">Data Types</h2><div class="menu-data-types-container"><ul id="menu-data-types" class="menu"><li id="menu-item-1675" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1675"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-data-types/">Data Types</a></li><li id="menu-item-1676" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1676"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-bit/">BIT</a></li><li id="menu-item-1682" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1682"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-c
169har-data-type/">CHAR</a></li><li id="menu-item-1679" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1679"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-date/">DATE</a></li><li id="menu-item-1686" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1686"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-datetime2/">DATETIME2</a></li><li id="menu-item-1677" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1677"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-datetimeoffset/">DATETIMEOFFSET</a></li><li id="menu-item-1681" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1681"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-decimal/">Decimal</a></li><li id="menu-item-1680" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1680"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-int/">INT</a></li><li id="menu-item-1683" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1683"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-nchar/">NCHAR</a></li><li id="menu-item-1685" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1685"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-nvarchar/">NVARCHAR</a></li><li id="menu-item-1678" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1678"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-time/">TIME</a></li><li id="menu-item-1684" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1684"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-varchar/">VARCHAR</a></li></ul></div></section><section id="nav_menu-14" class="widget widget_nav_menu"><h2 class="widget-title">Expressions</h2><div class="menu-expressions-container"><ul id="menu-expressions" class="menu"><li id="menu-item-1504" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1504"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-case/">CASE</a></li><li id="menu-item-1505" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1505"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-coalesce/">COALESCE</a></li><li id="menu-item-1506" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1506"><a href="https://www.sqlservertutorial.net/sql-server-basics/sql-server-nullif/">NULLIF</a></li></ul></div></section><section id="evolution_ad-25" class="widget widget_evolution_ad"><div class="ad ad-300"><div data-aaad='true' data-aa-adunit='/21722279357/300x250_OB_sqlservertutorial_4'></div></div></section></aside><footer id="colophon" class="site-footer"><div class="site-footer-widgets"><div class="site-footer-sidebar widget"><h2 class="widget-title">About SQLServerTutorial.net</h2><div class="textwidget custom-html-widget">SQLServerTutorial.net website designed for Developers, Database Administrators, and Solution Architects who want to get started SQL Server quickly.</div><div class="smart-search-native smart-search-native--widget"><div class="smart-search smart-search--overlay smart-search--comfortable smart-search--scheme-auto smart-search--appearance-follow-theme smart-search--shape-soft" style="--ss-radius:10px;--ss-accent:#2563eb;--ss-custom-bg:#ffffff;--ss-custom-fg:#172033;--ss-custom-border:#d0d5dd;--ss-light-box-background:#ffffff;--ss-light-box-text:#172033;--ss-light-box-placeholder:#667085;--ss-light-box-border:#d0d5dd;--ss-light-popup-background:#ffffff;--ss-light-popup-text:#172033;--ss-light-popup-muted:#667085;--ss-light-popup-border:#d0d5dd;--ss-light-accent:#2563eb;--ss-light-hover:#eff6ff;--ss-dark-box-background:#2e2e2e;--ss-dark-box-text:#e3e3e3;--ss-dark-box-placeholder:#b8b8b8;--ss-dark-box-border:#454545;--ss-dark-popup-background:#171717;--ss-dark-popup-text:#e3e3e3;--ss-dark-popup-muted:#a9a9a9;--ss-dark-popup-border:#454545;--ss-dark-accent:#4db2ff;--ss-dark-hover:#242424;--ss-box-border-width:1px;--ss-popup-border-width:1px;--ss-box-radius:10px;--ss-popup-radius:12px;--ss-custom-shadow:0 16px 40px rgba(16,24,40,.18)" data-smart-search data-config="{&quot;indexUrl&quot;:&quot;\/wp-content\/uploads\/smart-search\/search-index.7a7349a824b7.json&quot;,&quot;appUrl&quot;:&quot;\/wp-content\/plugins\/smart-site-search\/assets\/js\/search-app.js&quot;,&quot;mode&quot;:&quot;overlay&quot;,&quot;nativeFallbackUrl&quot;:&quot;https:\/\/www.sqlservertutorial.net\/?s=&quot;,&quot;appearanceMode&quot;:&quot;follow-theme&quot;,&quot;customSearchSelector&quot;:&quot;&quot;,&quot;queryParameter&quot;:&quot;q&quot;,&quot;minQueryLength&quot;:2,&quot;maxResults&quot;:8,&quot;threshold&quot;:0.320000000000000006661338147750939242541790008544921875,&quot;keyboardShortcuts&quot;:true,&quot;highlightTitle&quot;:true,&quot;openNewTab&quot;:false,&quot;loadingStrategy&quot;:&quot;interaction&quot;,&quot;enableTypeFilters&quot;:true,&quot;enableSnippets&quot;:true,&quot;snippetLength&quot;:180,&quot;synonyms&quot;:[],&quot;analytics&quot;:{&quot;enabled&quot;:false,&quot;provider&quot;:&quot;browser-event&quot;,&quot;minLength&quot;:2},&quot;locale&quot;:&quot;en_US&quot;,&quot;localeFiltering&quot;:false,&quot;messages&quot;:{&quot;loading&quot;:&quot;Loading search\u2026&quot;,&quot;noResults&quot;:&quot;No results found.&quot;,&quot;error&quot;:&quot;Search could not be loaded.&quot;,&quot;allTypes&quot;:&quot;All content&quot;,&quot;results&quot;:&quot;results&quot;,&quot;pages&quot;:&quot;Pages&quot;,&quot;startTyping&quot;:&quot;Start typing to search.&quot;,&quot;recentSearches&quot;:&quot;Recent searches&quot;,&quot;clearRecent&quot;:&quot;Clear&quot;}}"><label class="screen-reader-text" for="smart-search-3">Search</label><div class="smart-search__field"><span class="smart-search__icon" aria-hidden="true"></span><input id="smart-search-3" class="smart-search__input" type="search" placeholder="Search this site…" autocomplete="off" role="combobox" aria-autocomplete="list" aria-expanded="false" aria-controls="smart-search-3-results"><button class="smart-search__clear" type="button" aria-label="Clear search" hidden>×</button></div><div id="smart-search-3-results" class="smart-search__panel" role="listbox" hidden></div><div class="smart-search__status screen-reader-text" aria-live="polite"></div></div></div></div><div class="site-footer-sidebar widget"><h2 class="widget-title">Latest Tutorials</h2><ul><li><a href="https://www.sqlservertutorial.net/go-sql-server/go-sql-server-insert/">Go SQL Server: Inserting Data</a></li><li><a href="https://www.sqlservertutorial.net/go-sql-server/go-connect-sql-server/">Go: Connecting to SQL Server</a></li><li><a href="https://www.sqlservertutorial.net/go-sql-server/">Go SQL Server</a></li><li><a href="https://www.sqlservertutorial.net/php-sql-server/php-sql-server-call-stored-procedure-output-parameters/">PHP SQL Server: Calling Stored Procedure with OUTPUT Parameters</a></li><li><a href="https://www.sqlservertutorial.net/php-sql-server/php-sql-server-call-stored-procedure/">PHP SQL Server: Calling Stored Procedures</a></li></ul></div><div class="site-footer-sidebar widget"><h2 class="widget-title">Site Links</h2><div class="menu-site-links-container"><ul id="menu-site-links" class="menu"><li id="menu-item-2813" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2813"><a href="https://www.sqlservertutorial.net/donation/">Donation ❤️</a></li><li id="menu-item-33" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-33"><a href="https://www.sqlservertutorial.net/about/">About</a></li><li id="menu-item-32" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-32"><a href="https://www.sqlservertutorial.net/contact/">Contact</a></li><li id="menu-item-31" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-31"><a href="https://www.sqlservertutorial.net/privacy/">Privacy Policy</a></li><li id="menu-item-30" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-30"><a href="https://www.sqlservertutorial.net/terms-of-use/">Terms of Use</a></li></ul></div></div></div><div class="site-info"><div class="textwidget custom-html-widget"><p>
170	Copyright &copy; 2025 by <a href="https://www.sqlservertutorial.net/" title="SQL Server Tutorial"> www.sqlservertutorial.net</a>. All Rights Reserved.
171</p><small>Microsoft Corporation does not sponsor the tutorials on sqlservertutorial.net, and this website has no relationship with Microsoft Corporation.</small></div></div></div></footer></div>
172
173<script type="speculationrules">
174{"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/evolution/*","/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]}
175</script>
vendor: 1 bytes, line 175
175
176<script id="hfb-frontend-js-extra">
177var hfbData = {"restUrl":"https://www.sqlservertutorial.net/wp-json/helpful-feedback/v1/submit","settings":{"message_text":"Was this tutorial helpful?","yes_label":"Yes","no_label":"No","form_label":"Please help us improve","submit_label":"Submit Feedback","cancel_label":"Cancel","thank_you_message":"Thank you for your feedback!","form_display_mode":"negative","enable_form":true,"enable_notifications":false,"notification_email":"[email protected]","block_style":"minimal","block_layout":"inline","content_alignment":"center","auto_display_enabled":true,"auto_display_post":true,"auto_display_page":true,"excluded_post_ids":[7,18,16,20],"excluded_category_ids":[]}};
178//# sourceURL=hfb-frontend-js-extra
179</script>
vendor: 1 bytes, line 179
179
180<script defer id="hfb-frontend-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/4f5d51d1d3c7422a4759780dd60a1d47505a6ce899c8a38f600647ad9c06fedd.js"></script>
vendor: 1 bytes, line 180
180
181<script data-wp-strategy="defer" defer id="smart-search-fuse-js" src="https://www.sqlservertutorial.net/wp-content/plugins/smart-site-search/assets/vendor/fuse/fuse.min.js?ver=7.1.0"></script>
vendor: 1 bytes, line 181
181
182<script data-wp-strategy="defer" defer id="smart-search-loader-js" src="https://www.sqlservertutorial.net/wp-content/plugins/smart-site-search/assets/js/loader.js?ver=1789277685"></script>
vendor: 1 bytes, line 182
182
183<script defer id="ev-back-to-top-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/024922f436c6d4436b682f9e83d0c6367c6d48a03cd3175d4592bd54464510b6.js"></script>
vendor: 1 bytes, line 183
183
184<script defer id="ev-mode-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/0fc203da487b00de48db716f8b3dd8e2c4ba24f7aa1f03f488614241fb446146.js"></script>
vendor: 1 bytes, line 184
184
185<script defer id="ev-navbar-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/4eef569cf2c290b7cdecc6fc85c66c4221de64cd4d0b7712bdb1d76eb052dc4f.js"></script>
vendor: 1 bytes, line 185
185
186<script defer id="ev-mobile-menu-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/d291592c932823d2d5c7f7d2d56c9fb5c10219f2d24452b77bfc61b9f1cafa0e.js"></script>
vendor: 1 bytes, line 186
186
187<script defer id="ev-search-table-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/47d69b4f1968e54aaeb5cb711ac54fa21c82a8949fe1df45c08db8cf47dce1e7.js"></script>
vendor: 1 bytes, line 187
187
188<script defer id="ev-app-js" src="https://www.sqlservertutorial.net/wp-content/uploads/essential-optimize/cache/800bb98420ebfae2e871bfb7aafe43ee228a1c842a8982306041d86559900545.js"></script>
188
189
190
191
192<script type="module" src="https://static.cloudflareinsights.com/beacon.min.js/v31edd6df95cf4e85bb4c19e7a9bdbcba1788362987495" integrity="sha512-iIg7k2xntmwu6/uSb5tpc/hySgZc4eoL31yB29W6tJFo2akwjPWcEqnCEdJvGexCL0KEQwVYv5BlowfhVz26hg==" data-cf-beacon='{"version":"2024.11.0","token":"6f94f7cdc69541238015c3312d29666e","r":1,"spa":2}' crossorigin="anonymous"></script>
vendor: 1 bytes, line 192
192
193<script type="module" src="https://static.cloudflareinsights.com/beacon.min.js/v31edd6df95cf4e85bb4c19e7a9bdbcba1788362987495" integrity="sha512-iIg7k2xntmwu6/uSb5tpc/hySgZc4eoL31yB29W6tJFo2akwjPWcEqnCEdJvGexCL0KEQwVYv5BlowfhVz26hg==" data-cf-beacon='{"version":"2024.11.0","token":"6f94f7cdc69541238015c3312d29666e","r":1,"spa":2}' crossorigin="anonymous"></script>
193
194</body></html>
195<!-- Smart Static | Build: ss-20260915-062159-eicfvn | Version: 1.5.8 | Generated: 2026-09-15T13:21:59+07:00 -->

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.