{"id":6140,"date":"2024-02-16T11:38:42","date_gmt":"2024-02-16T11:38:42","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?post_type=web-story&#038;p=6140"},"modified":"2024-02-16T11:38:43","modified_gmt":"2024-02-16T11:38:43","slug":"differences-between-sql-and-t-sql-with-example","status":"publish","type":"web-story","link":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/","title":{"rendered":"Differences between sql and t-sql with example"},"content":{"rendered":"<p><html amp=\"\" lang=\"en\"><head><meta charSet=\"utf-8\"\/><meta name=\"viewport\" content=\"width=device-width,minimum-scale=1,initial-scale=1\"\/><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0.js\"><\/script><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0\/amp-story-1.0.js\" custom-element=\"amp-story\"><\/script><link href=\"https:\/\/fonts.googleapis.com\/css2?display=swap&amp;family=Lora%3Awght%40700\" rel=\"stylesheet\"\/>\n<style amp-boilerplate=\"\">body{-webkit-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-moz-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-ms-animation:-amp-start 8s steps(1,end) 0s 1 normal both;animation:-amp-start 8s steps(1,end) 0s 1 normal both}@-webkit-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-moz-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-ms-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-o-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}<\/style>\n<p><noscript><\/p>\n<style amp-boilerplate=\"\">body{-webkit-animation:none;-moz-animation:none;-ms-animation:none;animation:none}<\/style>\n<p><\/noscript><\/p>\n<style amp-custom=\"\">\n              h1, h2, h3 { font-weight: normal; }<\/p>\n<p>              amp-story-page {\n                background-color: #131516;\n              }<\/p>\n<p>              amp-story-grid-layer {\n                overflow: visible;\n              }<\/p>\n<p>              @media (max-aspect-ratio: 9 \/ 16)  {\n                @media (min-aspect-ratio: 320 \/ 678) {\n                  amp-story-grid-layer.grid-layer {\n                    margin-top: calc((100% \/ 0.5625 - 100% \/ 0.6666666666666666) \/ 2);\n                  }\n                }\n              }<\/p>\n<p>              @media not all and (min-resolution:.001dpcm) {\n                @media {\n                  p.text-wrapper > span {\n                    font-size: calc(100% - 0.5px);\n                  }\n                }\n              }<\/p>\n<p>              .page-fullbleed-area,\n              .page-background-overlay-area {\n                position: absolute;\n                overflow: hidden;\n                width: 100%;\n                left: 0;\n                height: calc(1.1851851851851851 * 100%);\n                top: calc((1 - 1.1851851851851851) * 100% \/ 2);\n              }<\/p>\n<p>              .element-overlay-area {\n                position: absolute;\n                width: 100%;\n                height: 100%;\n                top: 0;\n                left: 0;\n              }<\/p>\n<p>              .page-safe-area {\n                overflow: visible;\n                position: absolute;\n                top: 0;\n                bottom: 0;\n                left: 0;\n                right: 0;\n                width: 100%;\n                height: calc(0.84375 * 100%);\n                margin: auto 0;\n              }<\/p>\n<p>              .mask {\n                position: absolute;\n                overflow: hidden;\n              }<\/p>\n<p>              .fill {\n                position: absolute;\n                top: 0;\n                left: 0;\n                right: 0;\n                bottom: 0;\n                margin: 0;\n              }<\/p>\n<p>              @media (prefers-reduced-motion: no-preference) {\n                .animation-wrapper {\n                  opacity: var(--initial-opacity);\n                  transform: var(--initial-transform);\n                }\n              }<\/p>\n<p>              amp-story-grid-layer.align-bottom {\n                align-content: end;\n                padding: 0;\n                \/* \n                  AMP CTA Layer will exactly occupy 74px regardless of any device.\n                  To space out captions 74px from the BOTTOM (AMP CTA Layer),\n                  74px from the TOP should also be spaced out and thus: 2 * 74px\n                  will be the desired max-height.\n                *\/\n                max-height: calc(100vh - (2 * 74px));\n              }<\/p>\n<p>              .captions-area {\n                padding: 0 32px 0;\n              }<\/p>\n<p>              amp-story-captions {\n                margin-bottom: 16px;\n                text-align: center;\n              }\n              <\/style>\n<p><meta name=\"web-stories-replace-head-start\"\/><title>Differences between sql and t-sql with example<\/title><link rel=\"canonical\" href=\"https:\/\/pickl.ai\/blog\/?post_type=web-story&amp;p=6140\"\/><meta name=\"web-stories-replace-head-end\"\/><\/head><body><amp-story standalone=\"\" publisher=\"Pickl.AI\" publisher-logo-src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2022\/01\/cropped-cropped-favicon.png\" title=\"Differences between sql and t-sql with example\" poster-portrait-src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg\"><amp-story-page id=\"f5790c67-8c76-442c-8381-1cc02d4e4cae\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#b6540d\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-9eea49de-7068-4d94-b42c-97861611456d\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:49.67638%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-31f7e263-2efd-4c0b-ad5b-dffcc58cf56f\">\n<div style=\"position:absolute;width:100%;height:102.93159%;left:0%;top:-1.46579%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989.jpg\" alt=\"21743443_6505989\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:56.47249%;width:76.69903%;height:43.20388%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.7490636704119851% 0.7490636704119851% 0.7490636704119851% 0.7490636704119851%\" id=\"el-6c194f9a-e106-4777-8b9b-ca233650e082\">\n<h1 id=\"differences-between-sql-and-t-sql\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.7832278481012663% 0;font-family:&quot;Lora&quot;,serif;font-size:0.889968em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Differences Between SQL and T-SQL<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"2a5d26d1-f93d-4839-bb8c-e647cbb3bf66\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#b517c8\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-7a0ce39f-8900-4761-95eb-4ca331b6f837\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:28.9644%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-d9a5402b-6b63-4b32-be26-5dd847ddb4b4\">\n<div style=\"position:absolute;width:101.97795%;height:100%;left:-0.98898%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-scaled.jpg\" alt=\"22112357_6554783\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-2048x1138.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-1536x853.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-1024x569.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-768x427.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-300x167.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-150x83.jpg 150w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.86408%;top:33.00971%;width:75.48544%;height:7.44337%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6430868167202572% 0.6430868167202572% 0.6430868167202572% 0.6430868167202572% \/ 4.3478260869565215% 4.3478260869565215% 4.3478260869565215% 4.3478260869565215%\" id=\"el-8158e824-1794-49b9-b67d-457080a02741\">\n<h1 id=\"introduction\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5209003215434087% 0;font-family:&quot;Lora&quot;,serif;font-size:0.582524em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #7ae70c\">Introduction<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.13592%;top:47.57282%;width:76.69903%;height:32.8479%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.9852216748768473% 0.9852216748768473% 0.9852216748768473% 0.9852216748768473%\" id=\"el-fd9555ed-10f5-472f-9966-e98d13428f94\">\n<h3 id=\"sql-structured-query-languaget-sql-transact-sql-are-both-powerful-languages-used-for-managing-relational-databases\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.3037974683544306% 0;font-family:&quot;Lora&quot;,serif;font-size:0.388350em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #003bad\">SQL (Structured Query Language)<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #003bad\">T-SQL (Transact-SQL) are both powerful languages used for managing relational databases.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.86408%;top:84.46602%;width:75.48544%;height:6.14887%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6430868167202572% 0.6430868167202572% 0.6430868167202572% 0.6430868167202572% \/ 5.263157894736842% 5.263157894736842% 5.263157894736842% 5.263157894736842%\" id=\"el-eb5182bb-e113-4cba-9860-ad1657a49e58\"><a href=\"https:\/\/pickl.ai\/blog\/differences-between-sql-and-t-sql-with-example\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/07\/SQL-vs.-T-SQL-2.jpg\" data-tooltip-text=\"Differences Between SQL and T-SQL [with Example]- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.3858520900321541% 0;font-family:&quot;Lora&quot;,serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #6ed911\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"14ecc601-f6c5-470b-be6c-0c3c173bb472\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#dbca09\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-850f62ff-dd5e-4747-b758-e83837790cf1\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:35.59871%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-c5fdcefe-9c21-4b23-ae62-41e192c1adb4\">\n<div style=\"position:absolute;width:104.41%;height:100%;left:-2.205%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-scaled.jpg\" alt=\"21743439_6505016 (1)\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-2048x1365.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-1536x1024.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-1024x683.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-900x600.jpg 900w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-768x512.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-300x200.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-150x100.jpg 150w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:38.99676%;width:76.69903%;height:8.25243%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 3.9215686274509802% 3.9215686274509802% 3.9215686274509802% 3.9215686274509802%\" id=\"el-fb5cc8af-de65-4e01-8592-c23b3fd975bc\">\n<h1 id=\"sql-overview\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5696202531645583% 0;font-family:&quot;Lora&quot;,serif;font-size:0.647249em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">SQL Overview<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:52.75081%;width:76.69903%;height:35.27508%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.9174311926605505% 0.9174311926605505% 0.9174311926605505% 0.9174311926605505%\" id=\"el-72f5572f-53c5-4b51-a9b3-57ea74cfb966\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.25316455696202556% 0;font-family:&quot;Lora&quot;,serif;font-size:0.323625em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #800f2f\">SQL is a standard language for managing relational databases.<\/span><br \/>\n<span style=\"font-weight: 700; color: #800f2f\">It provides a set of commands for querying, updating, and managing databases.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #800f2f\">Example: SELECT * FROM Employees WHERE Department = &#8216;IT&#8217;;<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:94.98382%;width:76.69903%;height:6.31068%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 5.128205128205128% 5.128205128205128% 5.128205128205128% 5.128205128205128%\" id=\"el-964e7165-671c-4e9f-b4f2-5d079aecc6c0\"><a href=\"https:\/\/pickl.ai\/blog\/sql-server-error-26-and-methods-to-resolve-it\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/SQL-Server-Error-26-and-Methods-to-Resolve-It-scaled.jpg\" data-tooltip-text=\"SQL Server Error 26 and Methods to Resolve It\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-2\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.3797468354430377% 0;font-family:&quot;Lora&quot;,serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"2521678c-1d5c-4761-888c-b71b55738ef0\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#4b1283\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-13dc571d-0f56-4b7c-9c84-5f25bf73bc74\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:37.05502%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-2f7329ea-85a3-4c35-acf3-9956d863fb38\">\n<div style=\"position:absolute;width:100%;height:137.99125%;left:0%;top:-18.99563%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738.jpg\" alt=\"22379534_6613738\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.49515%;top:39.96764%;width:76.69903%;height:7.60518%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 4.25531914893617% 4.25531914893617% 4.25531914893617% 4.25531914893617%\" id=\"el-0ac68629-4d4c-4ded-8257-c0e81b8590e3\">\n<h1 id=\"t-sql-overview\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5126582278481017% 0;font-family:&quot;Lora&quot;,serif;font-size:0.582524em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #d4e4c0\">T-SQL Overview<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:53.55987%;width:76.69903%;height:38.67314%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.8368200836820083% 0.8368200836820083% 0.8368200836820083% 0.8368200836820083%\" id=\"el-b082fe6c-c324-4679-bfe8-73be8e7cd341\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.22784810126582297% 0;font-family:&quot;Lora&quot;,serif;font-size:0.291262em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff477e\">T-SQL is an extension of SQL developed by Microsoft for use with SQL Server.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #ff477e\">It includes additional features and functionalities beyond standard SQL.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #ff477e\">Example: SELECT * FROM Employees WHERE Department = &#8216;IT&#8217; ORDER BY LastName;<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:97.411%;width:76.69903%;height:6.14887%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 5.263157894736842% 5.263157894736842% 5.263157894736842% 5.263157894736842%\" id=\"el-43c500d5-804f-4e39-a526-a3aafaf3f3f7\"><a href=\"https:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/04\/SQL-Tips.jpg\" data-tooltip-text=\"Advanced SQL Tips and Tricks for Data Analysts- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-3\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.3797468354430377% 0;font-family:&quot;Lora&quot;,serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #d4e4c0\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"30af909f-1eab-450f-84d2-8757ab0cd3b0\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#e06e04\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-170a99b6-bb4b-4457-902a-7329798ac867\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:41.90939%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-2831b4f8-8e70-4f79-9e84-7008d2d8ac7a\">\n<div style=\"position:absolute;width:104.75427%;height:100%;left:-2.37714%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-scaled.jpg\" alt=\"33905025_69\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-2048x1603.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-1536x1202.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-1024x801.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-768x601.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-300x235.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-150x117.jpg 150w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:42.88026%;width:76.69903%;height:14.23948%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 2.272727272727273% 2.272727272727273% 2.272727272727273% 2.272727272727273%\" id=\"el-068ad2c8-0365-4cdd-bc43-ee4d172a88fa\">\n<h1 id=\"differences-in-syntax\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5126582278481017% 0;font-family:&quot;Lora&quot;,serif;font-size:0.582524em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #590d22\">Differences in Syntax<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:60.19417%;width:76.69903%;height:42.0712%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.7692307692307693% 0.7692307692307693% 0.7692307692307693% 0.7692307692307693%\" id=\"el-ad126404-dadd-49fe-a5e4-5d03a549d2bb\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.22784810126582297% 0;font-family:&quot;Lora&quot;,serif;font-size:0.291262em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #003bad\">T-SQL supports additional syntax and functionalities not available in standard SQL.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #003bad\">T-SQL includes features like error handling, transactions, and stored procedures.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #003bad\">Example: BEGIN TRANSACTION; INSERT INTO Orders VALUES (1001, &#8216;Product A&#8217;, 50); COMMIT TRANSACTION;<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"bf125552-c6ea-4e4e-9641-e17240928434\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#e03568\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-b22fbfbb-222f-4f51-83b5-55c3149879c1\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:41.10032%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-c3dd0234-a76d-4cb8-8282-bc489e69be06\">\n<div style=\"position:absolute;width:100%;height:124.40946%;left:0%;top:-12.20473%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1.jpg\" alt=\"21665294_6500383 (1)\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:42.88026%;width:76.69903%;height:14.23948%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 2.272727272727273% 2.272727272727273% 2.272727272727273% 2.272727272727273%\" id=\"el-0ea20293-8c5d-4a67-8647-eb5c5ba37a48\">\n<h1 id=\"differences-in-functionality\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5126582278481017% 0;font-family:&quot;Lora&quot;,serif;font-size:0.582524em;line-height:1.19;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ffffb7\">Differences in Functionality<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:59.06149%;width:76.69903%;height:38.67314%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.8368200836820083% 0.8368200836820083% 0.8368200836820083% 0.8368200836820083%\" id=\"el-1b9a93bf-5be7-4fe1-a63c-31bd4583d9a5\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.22784810126582297% 0;font-family:&quot;Lora&quot;,serif;font-size:0.291262em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #110966\">T-SQL offers advanced functionalities for working with SQL Server databases.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #110966\">It includes features like table variables, temporary tables, and user-defined functions.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #110966\">Example: DECLARE @TotalSales MONEY; SET @TotalSales = (SELECT SUM(Quantity * Price) FROM Sales);<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:99.51456%;width:72.81553%;height:6.31068%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6666666666666667% 0.6666666666666667% 0.6666666666666667% 0.6666666666666667% \/ 5.128205128205128% 5.128205128205128% 5.128205128205128% 5.128205128205128%\" id=\"el-ef2f21a0-e61f-4a85-bb5b-ab571c46329c\"><a href=\"https:\/\/pickl.ai\/blog\/why-sql-is-important-for-data-analyst\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/04\/SQL-for-Data-Analysts.jpg\" data-tooltip-text=\"Why SQL is important for Data Analyst?- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-4\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.39999999999999974% 0;font-family:&quot;Lora&quot;,serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ffffb7\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"aa8576f0-bfc7-43c9-be90-d4056b69037a\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#0a1137\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-36874e11-f4a5-4f84-8b03-660b34f45d45\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:40.7767%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-dc5980ee-c92c-478f-90e1-8551e86c3be2\">\n<div style=\"position:absolute;width:100%;height:125.39682%;left:0%;top:-12.69841%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730.jpg\" alt=\"21743438_6488730\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:42.88026%;width:76.69903%;height:14.40129%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 2.247191011235955% 2.247191011235955% 2.247191011235955% 2.247191011235955%\" id=\"el-8e0bea80-2093-430c-8538-e939964d6f71\">\n<h1 id=\"compatibility-and-portability\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5126582278481017% 0;font-family:&quot;Lora&quot;,serif;font-size:0.582524em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #cfcc14\">Compatibility and Portability<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:61.16505%;width:76.69903%;height:42.0712%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 0.7692307692307693% 0.7692307692307693% 0.7692307692307693% 0.7692307692307693%\" id=\"el-1f6429ed-fd11-419a-b290-18c7f950b2bc\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.22784810126582297% 0;font-family:&quot;Lora&quot;,serif;font-size:0.291262em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #d4e4c0\">SQL is a standard language supported by various database management systems (DBMS) like MySQL, PostgreSQL, and Oracle.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #d4e4c0\">T-SQL is specific to Microsoft SQL Server and is not fully compatible with other database platforms.<\/span><\/p>\n<p><span style=\"font-weight: 700; color: #d4e4c0\">Example: SQL queries written for MySQL may not work directly in SQL Server without modification.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><\/amp-story><\/body><\/html><\/p>\n","protected":false},"excerpt":{"rendered":"SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases. \n","protected":false},"author":1,"featured_media":6152,"template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"web_stories_publisher_logo":935,"web_stories_poster":[],"web_stories_products":[],"footnotes":""},"web_story_category":[],"web_story_tag":[],"class_list":["post-6140","web-story","type-web-story","status-publish","has-post-thumbnail"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Differences between sql and t-sql with example - Pickl.AI<\/title>\n<meta name=\"description\" content=\"SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Differences between sql and t-sql with example\" \/>\n<meta property=\"og:description\" content=\"SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-16T11:38:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/adfcccafe1795b39fe941ddafe76b6ab\"},\"headline\":\"Differences between sql and t-sql with example\",\"datePublished\":\"2024-02-16T11:38:42+00:00\",\"dateModified\":\"2024-02-16T11:38:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/\"},\"wordCount\":230,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/cropped-21743443_6505989.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/\",\"name\":\"Differences between sql and t-sql with example - Pickl.AI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/cropped-21743443_6505989.jpg\",\"datePublished\":\"2024-02-16T11:38:42+00:00\",\"dateModified\":\"2024-02-16T11:38:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/cropped-21743443_6505989.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/cropped-21743443_6505989.jpg\",\"width\":640,\"height\":853,\"caption\":\"Differences between sql and t-sql with example\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/differences-between-sql-and-t-sql-with-example\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stories\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Differences between sql and t-sql with example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/adfcccafe1795b39fe941ddafe76b6ab\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=ga50c9c5ae9fb5534aba0f0b45ebbe6d3\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g\",\"caption\":\"Admin\"},\"sameAs\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"],\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/administrator\\\/transorgstandbyorangeironman\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Differences between sql and t-sql with example - Pickl.AI","description":"SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/","og_locale":"en_US","og_type":"article","og_title":"Differences between sql and t-sql with example","og_description":"SQL stands for Structured Query Language. It is a standard programming language used for managing and manipulating relational databases.","og_url":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/","og_site_name":"Pickl.AI","article_modified_time":"2024-02-16T11:38:43+00:00","og_image":[{"width":640,"height":853,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/"},"author":{"name":"Admin","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/adfcccafe1795b39fe941ddafe76b6ab"},"headline":"Differences between sql and t-sql with example","datePublished":"2024-02-16T11:38:42+00:00","dateModified":"2024-02-16T11:38:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/"},"wordCount":230,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/","url":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/","name":"Differences between sql and t-sql with example - Pickl.AI","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg","datePublished":"2024-02-16T11:38:42+00:00","dateModified":"2024-02-16T11:38:43+00:00","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg","width":640,"height":853,"caption":"Differences between sql and t-sql with example"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/differences-between-sql-and-t-sql-with-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Stories","item":"https:\/\/www.pickl.ai\/blog\/web-stories\/"},{"@type":"ListItem","position":3,"name":"Differences between sql and t-sql with example"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/adfcccafe1795b39fe941ddafe76b6ab","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=ga50c9c5ae9fb5534aba0f0b45ebbe6d3","url":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g","caption":"Admin"},"sameAs":["https:\/\/www.pickl.ai\/blog\/"],"url":"https:\/\/www.pickl.ai\/blog\/administrator\/transorgstandbyorangeironman\/"}]}},"story_data":{"version":47,"pages":[{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"9eea49de-7068-4d94-b42c-97861611456d"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"21743443_6505989-300x300.jpg","width":300,"height":300,"filesize":32824,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-300x300.jpg"},"large":{"file":"21743443_6505989-1024x1024.jpg","width":1024,"height":1024,"filesize":110413,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-1024x1024.jpg"},"thumbnail":{"file":"21743443_6505989-150x150.jpg","width":150,"height":150,"filesize":20525,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-150x150.jpg"},"medium_large":{"file":"21743443_6505989-768x768.jpg","width":768,"height":768,"filesize":81127,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-768x768.jpg"},"1536x1536":{"file":"21743443_6505989-1536x1536.jpg","width":1536,"height":1536,"filesize":177407,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-1536x1536.jpg"},"magine-hero":{"file":"21743443_6505989-1400x600.jpg","width":1400,"height":600,"filesize":85802,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-1400x600.jpg"},"magine-thumbnail":{"file":"21743443_6505989-900x600.jpg","width":900,"height":600,"filesize":73268,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-900x600.jpg"},"magine-vertical-thumbnail":{"file":"21743443_6505989-600x800.jpg","width":600,"height":800,"filesize":69080,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-600x800.jpg"},"web-stories-poster-portrait":{"file":"21743443_6505989-640x853.jpg","width":640,"height":853,"filesize":75787,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-640x853.jpg"},"web-stories-publisher-logo":{"file":"21743443_6505989-96x96.jpg","width":96,"height":96,"filesize":17124,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-96x96.jpg"},"web-stories-thumbnail":{"file":"21743443_6505989-150x150.jpg","width":150,"height":150,"filesize":20525,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989-150x150.jpg"},"full":{"file":"21743443_6505989.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#206091","blurHash":"UQPGs#?Z?bM~~pM|IU%1-;s:R*Io9as,%LR.","creationDate":"2024-02-16T10:31:45","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743443_6505989.jpg","id":6132,"alt":"21743443_6505989","local":false},"type":"image","x":48,"y":0,"width":316,"height":307,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"31f7e263-2efd-4c0b-ad5b-dffcc58cf56f"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":55,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Differences Between SQL and T-SQL<\/span>","x":48,"y":349,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":267,"id":"6c194f9a-e106-4777-8b9b-ca233650e082"}],"backgroundColor":{"color":{"r":182,"g":84,"b":13}},"id":"f5790c67-8c76-442c-8381-1cc02d4e4cae"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"7a0ce39f-8900-4761-95eb-4ca331b6f837"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1422,"sizes":{"medium":{"file":"22112357_6554783-300x167.jpg","width":300,"height":167,"filesize":8777,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-300x167.jpg"},"large":{"file":"22112357_6554783-1024x569.jpg","width":1024,"height":569,"filesize":51192,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-1024x569.jpg"},"thumbnail":{"file":"22112357_6554783-150x150.jpg","width":150,"height":150,"filesize":4579,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-150x150.jpg"},"medium_large":{"file":"22112357_6554783-768x427.jpg","width":768,"height":427,"filesize":34440,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-768x427.jpg"},"1536x1536":{"file":"22112357_6554783-1536x853.jpg","width":1536,"height":853,"filesize":88227,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-1536x853.jpg"},"2048x2048":{"file":"22112357_6554783-2048x1138.jpg","width":2048,"height":1138,"filesize":131122,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-2048x1138.jpg"},"magine-hero":{"file":"22112357_6554783-1400x600.jpg","width":1400,"height":600,"filesize":68690,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-1400x600.jpg"},"magine-thumbnail":{"file":"22112357_6554783-900x600.jpg","width":900,"height":600,"filesize":50808,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-900x600.jpg"},"magine-vertical-thumbnail":{"file":"22112357_6554783-600x800.jpg","width":600,"height":800,"filesize":27844,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-600x800.jpg"},"web-stories-poster-portrait":{"file":"22112357_6554783-640x853.jpg","width":640,"height":853,"filesize":30122,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-640x853.jpg"},"web-stories-publisher-logo":{"file":"22112357_6554783-96x96.jpg","width":96,"height":96,"filesize":2394,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-96x96.jpg"},"web-stories-thumbnail":{"file":"22112357_6554783-150x83.jpg","width":150,"height":83,"filesize":3281,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-150x83.jpg"},"full":{"file":"22112357_6554783-scaled.jpg","width":2560,"height":1422,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#2938a3","blurHash":"UJ9@1PM|W=%2xzoMW=e.5?s9bFNefAShn%oJ","creationDate":"2024-02-16T10:33:05","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22112357_6554783-scaled.jpg","id":6133,"alt":"22112357_6554783","local":false},"type":"image","x":48,"y":0,"width":316,"height":179,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"d9a5402b-6b63-4b32-be26-5dd847ddb4b4"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":36,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #7ae70c\">Introduction<\/span>","x":53,"y":204,"width":311,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":46,"id":"8158e824-1794-49b9-b67d-457080a02741"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":24,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #003bad\">SQL (Structured Query Language)<\/span>\n\n<span style=\"font-weight: 700; color: #003bad\">T-SQL (Transact-SQL) are both powerful languages used for managing relational databases.<\/span>","x":50,"y":294,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":203,"id":"fd9555ed-10f5-472f-9966-e98d13428f94"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #6ed911\">Learn More<\/span>","x":53,"y":522,"width":311,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":38,"id":"eb5182bb-e113-4cba-9860-ad1657a49e58","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/differences-between-sql-and-t-sql-with-example\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/07\/SQL-vs.-T-SQL-2.jpg","desc":"Differences Between SQL and T-SQL [with Example]- Pickl.AI"}}],"backgroundColor":{"color":{"r":181,"g":23,"b":200}},"id":"2a5d26d1-f93d-4839-bb8c-e647cbb3bf66"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"850f62ff-dd5e-4747-b758-e83837790cf1"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1707,"sizes":{"medium":{"file":"21743439_6505016-1-300x200.jpg","width":300,"height":200,"filesize":17175,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-300x200.jpg"},"large":{"file":"21743439_6505016-1-1024x683.jpg","width":1024,"height":683,"filesize":77507,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-1024x683.jpg"},"thumbnail":{"file":"21743439_6505016-1-150x150.jpg","width":150,"height":150,"filesize":10963,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-150x150.jpg"},"medium_large":{"file":"21743439_6505016-1-768x512.jpg","width":768,"height":512,"filesize":54284,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-768x512.jpg"},"1536x1536":{"file":"21743439_6505016-1-1536x1024.jpg","width":1536,"height":1024,"filesize":127891,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-1536x1024.jpg"},"2048x2048":{"file":"21743439_6505016-1-2048x1365.jpg","width":2048,"height":1365,"filesize":182896,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-2048x1365.jpg"},"magine-hero":{"file":"21743439_6505016-1-1400x600.jpg","width":1400,"height":600,"filesize":100566,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-1400x600.jpg"},"magine-thumbnail":{"file":"21743439_6505016-1-900x600.jpg","width":900,"height":600,"filesize":66999,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-900x600.jpg"},"magine-vertical-thumbnail":{"file":"21743439_6505016-1-600x800.jpg","width":600,"height":800,"filesize":63223,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-600x800.jpg"},"web-stories-poster-portrait":{"file":"21743439_6505016-1-640x853.jpg","width":640,"height":853,"filesize":66161,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-640x853.jpg"},"web-stories-publisher-logo":{"file":"21743439_6505016-1-96x96.jpg","width":96,"height":96,"filesize":7212,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-96x96.jpg"},"web-stories-thumbnail":{"file":"21743439_6505016-1-150x100.jpg","width":150,"height":100,"filesize":8254,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-150x100.jpg"},"full":{"file":"21743439_6505016-1-scaled.jpg","width":2560,"height":1707,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#deecf6","blurHash":"UmN_4gw]?ZbH-.ofj[WV~9NdM|j?M}RkNHs.","creationDate":"2024-02-16T10:36:19","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743439_6505016-1-scaled.jpg","id":6134,"alt":"21743439_6505016 (1)","local":false},"type":"image","x":48,"y":0,"width":316,"height":220,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"c5fdcefe-9c21-4b23-ae62-41e192c1adb4"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":40,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">SQL Overview<\/span>","x":48,"y":241,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":51,"id":"fb5cc8af-de65-4e01-8592-c23b3fd975bc"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":20,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #800f2f\">SQL is a standard language for managing relational databases.<\/span>\n<span style=\"font-weight: 700; color: #800f2f\">It provides a set of commands for querying, updating, and managing databases.<\/span>\n\n<span style=\"font-weight: 700; color: #800f2f\">Example: SELECT * FROM Employees WHERE Department = 'IT';<\/span>","x":48,"y":326,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":218,"id":"72f5572f-53c5-4b51-a9b3-57ea74cfb966"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Learn More<\/span>","x":48,"y":587,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":39,"id":"964e7165-671c-4e9f-b4f2-5d079aecc6c0","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/sql-server-error-26-and-methods-to-resolve-it\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/SQL-Server-Error-26-and-Methods-to-Resolve-It-scaled.jpg","desc":"SQL Server Error 26 and Methods to Resolve It"}}],"backgroundColor":{"color":{"r":219,"g":202,"b":9}},"id":"14ecc601-f6c5-470b-be6c-0c3c173bb472"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"13dc571d-0f56-4b7c-9c84-5f25bf73bc74"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"22379534_6613738-300x300.jpg","width":300,"height":300,"filesize":23327,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-300x300.jpg"},"large":{"file":"22379534_6613738-1024x1024.jpg","width":1024,"height":1024,"filesize":120428,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-1024x1024.jpg"},"thumbnail":{"file":"22379534_6613738-150x150.jpg","width":150,"height":150,"filesize":9798,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-150x150.jpg"},"medium_large":{"file":"22379534_6613738-768x768.jpg","width":768,"height":768,"filesize":83207,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-768x768.jpg"},"1536x1536":{"file":"22379534_6613738-1536x1536.jpg","width":1536,"height":1536,"filesize":202146,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-1536x1536.jpg"},"magine-hero":{"file":"22379534_6613738-1400x600.jpg","width":1400,"height":600,"filesize":105610,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-1400x600.jpg"},"magine-thumbnail":{"file":"22379534_6613738-900x600.jpg","width":900,"height":600,"filesize":86325,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-900x600.jpg"},"magine-vertical-thumbnail":{"file":"22379534_6613738-600x800.jpg","width":600,"height":800,"filesize":83343,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-600x800.jpg"},"web-stories-poster-portrait":{"file":"22379534_6613738-640x853.jpg","width":640,"height":853,"filesize":90870,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-640x853.jpg"},"web-stories-publisher-logo":{"file":"22379534_6613738-96x96.jpg","width":96,"height":96,"filesize":6462,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-96x96.jpg"},"web-stories-thumbnail":{"file":"22379534_6613738-150x150.jpg","width":150,"height":150,"filesize":9798,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738-150x150.jpg"},"full":{"file":"22379534_6613738.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#c4d8ec","blurHash":"UNMkR~V@h2xun3WBXnoftng4V=Z~xuo#VsVr","creationDate":"2024-02-16T10:38:26","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/22379534_6613738.jpg","id":6135,"alt":"22379534_6613738","local":false},"type":"image","x":48,"y":0,"width":316,"height":229,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"2f7329ea-85a3-4c35-acf3-9956d863fb38"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":36,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #d4e4c0\">T-SQL Overview<\/span>","x":35,"y":247,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":47,"id":"0ac68629-4d4c-4ded-8257-c0e81b8590e3"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":18,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #ff477e\">T-SQL is an extension of SQL developed by Microsoft for use with SQL Server.<\/span>\n\n<span style=\"font-weight: 700; color: #ff477e\">It includes additional features and functionalities beyond standard SQL.<\/span>\n\n<span style=\"font-weight: 700; color: #ff477e\">Example: SELECT * FROM Employees WHERE Department = 'IT' ORDER BY LastName;<\/span>","x":48,"y":331,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":239,"id":"b082fe6c-c324-4679-bfe8-73be8e7cd341"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #d4e4c0\">Learn More<\/span>","x":48,"y":602,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":38,"id":"43c500d5-804f-4e39-a526-a3aafaf3f3f7","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/sql-tips-and-tricks-for-data-analysts\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/04\/SQL-Tips.jpg","desc":"Advanced SQL Tips and Tricks for Data Analysts- Pickl.AI"}}],"backgroundColor":{"color":{"r":75,"g":18,"b":131}},"id":"2521678c-1d5c-4761-888c-b71b55738ef0"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"170a99b6-bb4b-4457-902a-7329798ac867"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":2003,"sizes":{"medium":{"file":"33905025_69-300x235.jpg","width":300,"height":235,"filesize":50787,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-300x235.jpg"},"large":{"file":"33905025_69-1024x801.jpg","width":1024,"height":801,"filesize":110727,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-1024x801.jpg"},"thumbnail":{"file":"33905025_69-150x150.jpg","width":150,"height":150,"filesize":43445,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-150x150.jpg"},"medium_large":{"file":"33905025_69-768x601.jpg","width":768,"height":601,"filesize":87733,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-768x601.jpg"},"1536x1536":{"file":"33905025_69-1536x1202.jpg","width":1536,"height":1202,"filesize":163931,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-1536x1202.jpg"},"2048x2048":{"file":"33905025_69-2048x1603.jpg","width":2048,"height":1603,"filesize":218259,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-2048x1603.jpg"},"magine-hero":{"file":"33905025_69-1400x600.jpg","width":1400,"height":600,"filesize":102773,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-1400x600.jpg"},"magine-thumbnail":{"file":"33905025_69-900x600.jpg","width":900,"height":600,"filesize":94479,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-900x600.jpg"},"magine-vertical-thumbnail":{"file":"33905025_69-600x800.jpg","width":600,"height":800,"filesize":89595,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-600x800.jpg"},"web-stories-poster-portrait":{"file":"33905025_69-640x853.jpg","width":640,"height":853,"filesize":93516,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-640x853.jpg"},"web-stories-publisher-logo":{"file":"33905025_69-96x96.jpg","width":96,"height":96,"filesize":39541,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-96x96.jpg"},"web-stories-thumbnail":{"file":"33905025_69-150x117.jpg","width":150,"height":117,"filesize":41423,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-150x117.jpg"},"full":{"file":"33905025_69-scaled.jpg","width":2560,"height":2003,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#e6f2f5","blurHash":"UPOgc[s:%MX6?boMafaxxuWpWVoL~qR*R%of","creationDate":"2024-02-16T10:40:01","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/33905025_69-scaled.jpg","id":6137,"alt":"33905025_69","local":false},"type":"image","x":48,"y":0,"width":316,"height":259,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"2831b4f8-8e70-4f79-9e84-7008d2d8ac7a"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":36,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #590d22\">Differences in Syntax<\/span>","x":48,"y":265,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":88,"id":"068ad2c8-0365-4cdd-bc43-ee4d172a88fa"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":18,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #003bad\">T-SQL supports additional syntax and functionalities not available in standard SQL.<\/span>\n\n<span style=\"font-weight: 700; color: #003bad\">T-SQL includes features like error handling, transactions, and stored procedures.<\/span>\n\n<span style=\"font-weight: 700; color: #003bad\">Example: BEGIN TRANSACTION; INSERT INTO Orders VALUES (1001, 'Product A', 50); COMMIT TRANSACTION;<\/span>","x":48,"y":372,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":260,"id":"ad126404-dadd-49fe-a5e4-5d03a549d2bb"}],"backgroundColor":{"color":{"r":224,"g":110,"b":4}},"id":"30af909f-1eab-450f-84d2-8757ab0cd3b0"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"b22fbfbb-222f-4f51-83b5-55c3149879c1"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"21665294_6500383-1-300x300.jpg","width":300,"height":300,"filesize":21519,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-300x300.jpg"},"large":{"file":"21665294_6500383-1-1024x1024.jpg","width":1024,"height":1024,"filesize":101786,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-1024x1024.jpg"},"thumbnail":{"file":"21665294_6500383-1-150x150.jpg","width":150,"height":150,"filesize":7703,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-150x150.jpg"},"medium_large":{"file":"21665294_6500383-1-768x768.jpg","width":768,"height":768,"filesize":73399,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-768x768.jpg"},"1536x1536":{"file":"21665294_6500383-1-1536x1536.jpg","width":1536,"height":1536,"filesize":168342,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-1536x1536.jpg"},"magine-hero":{"file":"21665294_6500383-1-1400x600.jpg","width":1400,"height":600,"filesize":76829,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-1400x600.jpg"},"magine-thumbnail":{"file":"21665294_6500383-1-900x600.jpg","width":900,"height":600,"filesize":70211,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-900x600.jpg"},"magine-vertical-thumbnail":{"file":"21665294_6500383-1-600x800.jpg","width":600,"height":800,"filesize":66057,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-600x800.jpg"},"web-stories-poster-portrait":{"file":"21665294_6500383-1-640x853.jpg","width":640,"height":853,"filesize":71192,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-640x853.jpg"},"web-stories-publisher-logo":{"file":"21665294_6500383-1-96x96.jpg","width":96,"height":96,"filesize":3907,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-96x96.jpg"},"web-stories-thumbnail":{"file":"21665294_6500383-1-150x150.jpg","width":150,"height":150,"filesize":7703,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1-150x150.jpg"},"full":{"file":"21665294_6500383-1.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#49807f","blurHash":"UXQ9yKtl~WR6o2NHWExa*0iwMxo}XTWCxCWU","creationDate":"2024-02-16T10:41:40","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21665294_6500383-1.jpg","id":6138,"alt":"21665294_6500383 (1)","local":false},"type":"image","x":48,"y":0,"width":316,"height":254,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"c3dd0234-a76d-4cb8-8282-bc489e69be06"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":36,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #ffffb7\">Differences in Functionality<\/span>","x":48,"y":265,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":88,"id":"0ea20293-8c5d-4a67-8647-eb5c5ba37a48"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":18,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #110966\">T-SQL offers advanced functionalities for working with SQL Server databases.<\/span>\n\n<span style=\"font-weight: 700; color: #110966\">It includes features like table variables, temporary tables, and user-defined functions.<\/span>\n\n<span style=\"font-weight: 700; color: #110966\">Example: DECLARE @TotalSales MONEY; SET @TotalSales = (SELECT SUM(Quantity * Price) FROM Sales);<\/span>","x":48,"y":365,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":239,"id":"1b9a93bf-5be7-4fe1-a63c-31bd4583d9a5"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #ffffb7\">Learn More<\/span>","x":48,"y":615,"width":300,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":39,"id":"ef2f21a0-e61f-4a85-bb5b-ab571c46329c","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/why-sql-is-important-for-data-analyst\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/04\/SQL-for-Data-Analysts.jpg","desc":"Why SQL is important for Data Analyst?- Pickl.AI"}}],"backgroundColor":{"color":{"r":224,"g":53,"b":104}},"id":"bf125552-c6ea-4e4e-9641-e17240928434"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"36874e11-f4a5-4f84-8b03-660b34f45d45"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"21743438_6488730-300x300.jpg","width":300,"height":300,"filesize":12999,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-300x300.jpg"},"large":{"file":"21743438_6488730-1024x1024.jpg","width":1024,"height":1024,"filesize":60751,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-1024x1024.jpg"},"thumbnail":{"file":"21743438_6488730-150x150.jpg","width":150,"height":150,"filesize":4980,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-150x150.jpg"},"medium_large":{"file":"21743438_6488730-768x768.jpg","width":768,"height":768,"filesize":42508,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-768x768.jpg"},"1536x1536":{"file":"21743438_6488730-1536x1536.jpg","width":1536,"height":1536,"filesize":103650,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-1536x1536.jpg"},"magine-hero":{"file":"21743438_6488730-1400x600.jpg","width":1400,"height":600,"filesize":40106,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-1400x600.jpg"},"magine-thumbnail":{"file":"21743438_6488730-900x600.jpg","width":900,"height":600,"filesize":39251,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-900x600.jpg"},"magine-vertical-thumbnail":{"file":"21743438_6488730-600x800.jpg","width":600,"height":800,"filesize":40061,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-600x800.jpg"},"web-stories-poster-portrait":{"file":"21743438_6488730-640x853.jpg","width":640,"height":853,"filesize":43374,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-640x853.jpg"},"web-stories-publisher-logo":{"file":"21743438_6488730-96x96.jpg","width":96,"height":96,"filesize":2773,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-96x96.jpg"},"web-stories-thumbnail":{"file":"21743438_6488730-150x150.jpg","width":150,"height":150,"filesize":4980,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730-150x150.jpg"},"full":{"file":"21743438_6488730.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#dbe2ec","blurHash":"UMQvqCMHt-cu?ct9k9W9.8tQnMrqWAozXARl","creationDate":"2024-02-16T10:43:47","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/21743438_6488730.jpg","id":6139,"alt":"21743438_6488730","local":false},"type":"image","x":48,"y":0,"width":316,"height":252,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"dc5980ee-c92c-478f-90e1-8551e86c3be2"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":36,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #cfcc14\">Compatibility and Portability<\/span>","x":48,"y":265,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":89,"id":"8e0bea80-2093-430c-8538-e939964d6f71"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Lora"},"fontSize":18,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #d4e4c0\">SQL is a standard language supported by various database management systems (DBMS) like MySQL, PostgreSQL, and Oracle.<\/span>\n\n<span style=\"font-weight: 700; color: #d4e4c0\">T-SQL is specific to Microsoft SQL Server and is not fully compatible with other database platforms.<\/span>\n\n<span style=\"font-weight: 700; color: #d4e4c0\">Example: SQL queries written for MySQL may not work directly in SQL Server without modification.<\/span>","x":48,"y":378,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":260,"id":"1f6429ed-fd11-419a-b290-18c7f950b2bc"}],"backgroundColor":{"color":{"r":10,"g":17,"b":55}},"id":"aa8576f0-bfc7-43c9-be90-d4056b69037a"}],"fonts":{"Lora":{"family":"Lora","fallbacks":["serif"],"weights":[400,500,600,700],"styles":["regular","italic"],"variants":[[0,400],[0,500],[0,600],[0,700],[1,400],[1,500],[1,600],[1,700]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1006,"des":-274,"tAsc":1006,"tDes":-274,"tLGap":0,"wAsc":1206,"wDes":294,"xH":500,"capH":700,"yMin":-271,"yMax":1114,"hAsc":1006,"hDes":-274,"lGap":0}}},"autoAdvance":true,"defaultPageDuration":7,"currentStoryStyles":{"colors":[]}},"story_poster":{"id":6152,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/02\/cropped-21743443_6505989.jpg","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/web-story"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/users\/1"}],"version-history":[{"count":10,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6140\/revisions"}],"predecessor-version":[{"id":6153,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6140\/revisions\/6153"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media\/6152"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media?parent=6140"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web_story_category?post=6140"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web_story_tag?post=6140"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/6140\/lock"}],"wp:publisherlogo":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media\/935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}