{"id":191974,"date":"2019-01-14T15:12:29","date_gmt":"2019-01-14T14:12:29","guid":{"rendered":"https:\/\/guide.jtl-software.com\/database\/executing-sql-on-the-database\/"},"modified":"2023-06-14T14:55:30","modified_gmt":"2023-06-14T12:55:30","slug":"executing-sql-on-the-database","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/","title":{"rendered":"Executing SQL on the database"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-wawi\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-wawi\" id=\"executing-sql-on-the-database\">Executing SQL on the database <span id='anchor-executing-sql-on-the-database' data-href='#executing-sql-on-the-database' class='far fa-link' data-anchor><\/span><\/h1><div class=\"custom-box\">\n\t<div class=\"d-flex align-items-center mb-4\">\n\t\t\t\t\t\t\t<span class=\"mr-3 fa-stack flex-shrink-0 fa-1x\">\n\t\t\t<span class=\"fas fa-circle fa-stack-2x text-shaftblue\"><\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 fas fa-clipboard-list text-white fa-stack-1x\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\n\t\t<h3 class=\"mb-0 \" id=\"your-task-initial-situation\">Your task\/initial situation <span id='anchor-your-task-initial-situation' data-href='#your-task-initial-situation' class='far fa-link' data-anchor><\/span><\/h3>\t<\/div>\n\t<div class=\"box-content\">\n\t\tYou want to execute an SQL command for your JTL-Wawi database. In the following paragraphs, we will explain how to download and set up the programs Microsoft SQL Server Management Studio and Heidi SQL. Afterwards you will be able to issue SQL commands and saved procedures (which have been provided to you by our support team via the JTL-Forum, for example).\t<\/div>\n<\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"sql-server-management-studio\">SQL Server Management Studio <span id='anchor-sql-server-management-studio' data-href='#sql-server-management-studio' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tDownload the <span class=\"highlight\">SQL Server Management Studio<\/span>:\r\n<a class=\"external text\" href=\"https:\/\/docs.microsoft.com\/de-de\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver15\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">Go to the Microsoft website: Download Management Studio<\/a><\/li><li class=\"media-single-line\">\n\tLook up the name of the server in the <span class=\"highlight\">Datenbankverwaltung<\/span>\u00a0(Database administration).<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-001.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-001.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-001.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-001-1024x616.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-001-768x462.jpg 640w\" width=\"1439\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"865\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-auf-datenbank-ausfuehren-001.jpg&quot;,&quot;w&quot;:1439,&quot;h&quot;:865}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"3\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tStart the SQL Server Management Studio. Enter the SQL server under <span class=\"highlight\">Server name<\/span> and then click <span class=\"highlight\">Connect<\/span>.<\/li><\/ol>\t\t\t\t\t\t\t\t\t\t<a >\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/500px-Jtl-wawi-sql-auf-datenbank-ausfuehren-002.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/500px-Jtl-wawi-sql-auf-datenbank-ausfuehren-002.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/500px-Jtl-wawi-sql-auf-datenbank-ausfuehren-002.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/500px-Jtl-wawi-sql-auf-datenbank-ausfuehren-002.jpg 640w\" width=\"500\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"374\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<ol start=\"4\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tAfter you have logged in, open the <span class=\"highlight\">Databases<\/span> directory in the Object Explorer on the left. Select the <span class=\"highlight\">eazybusiness<\/span> entry and then click <span class=\"highlight\">New Query<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-003.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-003.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-003.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-003-1024x261.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-003-768x195.jpg 640w\" width=\"1387\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"353\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-auf-datenbank-ausfuehren-003.jpg&quot;,&quot;w&quot;:1387,&quot;h&quot;:353}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"5\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tThe editor opens. Enter an <span class=\"highlight\">SQL command<\/span>. Then click on <span class=\"highlight\">Execute<\/span> at the top of the screen.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-004.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-004.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-004.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-004-1024x581.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-004-768x436.jpg 640w\" width=\"1393\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"790\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-auf-datenbank-ausfuehren-004.jpg&quot;,&quot;w&quot;:1393,&quot;h&quot;:790}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<b>Attention: Important technical note!<\/b>\r\nIf you want to execute the query for several tenants, repeat the steps starting from Step 4 and select the respective tenant database instead of the eazybusiness database.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center h3\" id=\"heidi-sql\">Heidi SQL <span id='anchor-heidi-sql' data-href='#heidi-sql' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tDownload the\u00a0<span class=\"highlight\">Heidi Installer<\/span> and install the tool:\r\n<a class=\"external text\" href=\"http:\/\/www.heidisql.com\/download.php\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">Heid SQL Website: Download tool<\/a><\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-005.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-005.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-005.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-005-1024x614.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-005-768x460.jpg 640w\" width=\"1421\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"852\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-auf-datenbank-ausfuehren-005.jpg&quot;,&quot;w&quot;:1421,&quot;h&quot;:852}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"2\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tLook up the name of the server in the <span class=\"highlight\">Datenbankverwaltung<\/span>\u00a0(Database administration).<\/li><li >\n\tStart <span class=\"highlight\">Heidi SQL<\/span> and click <span class=\"highlight\">Neu<\/span>\u00a0(New). Adjust the following settings on the right-hand side:<\/li><\/ol><ul class=\"ml-6 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Verbindungstyp\u00a0(Network type): <\/b>Microsoft SQL Server\u00a0(named pipe)\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Hostname\/IP: <\/b>Servername\\JTLWAWI\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Benutzername\/Passwort\u00a0(Username\/password): <\/b>sa\/*******\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Datenbanken\u00a0(Databases): <\/b>Enter the name of your database, e.g. eazybusiness.\t<\/li><\/ul><ol start=\"4\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tClick <span class=\"highlight\">\u00d6ffnen<\/span>\u00a0(Open).<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-006.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-006.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-006.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-006-1024x613.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-006-768x460.jpg 640w\" width=\"1392\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"833\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-auf-datenbank-ausfuehren-006.jpg&quot;,&quot;w&quot;:1392,&quot;h&quot;:833}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"5\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tSelect the \u201ceazybusiness\u201d database. Then click <span class=\"highlight\">Abfrage<\/span>\u00a0(Query) and enter the desired SQL query into the editor. Then click on the arrow to run the query (see screenshot).<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-007.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-007-768x425.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-007.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-007-1024x566.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-auf-datenbank-ausfuehren-007-768x425.jpg 640w\" width=\"768\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"425\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-auf-datenbank-ausfuehren-007.jpg&quot;,&quot;w&quot;:1396,&quot;h&quot;:772}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<b>Attention: Important technical note!<\/b>\r\nIf you want to execute the query for several tenants, repeat the steps starting from Step 4 and select the respective tenant database instead of the eazybusiness database.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":191953,"menu_order":599,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-191974","page","type-page","status-publish","hentry","pages_category-sql-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Executing SQL on the database &#8211; JTL-Guide<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Executing SQL on the database &#8211; JTL-Guide\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T12:55:30+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\",\"name\":\"Executing SQL on the database &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2019-01-14T14:12:29+00:00\",\"dateModified\":\"2023-06-14T12:55:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Wawi\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Executing SQL on the database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Executing SQL on the database &#8211; JTL-Guide","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:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/","og_locale":"en_US","og_type":"article","og_title":"Executing SQL on the database &#8211; JTL-Guide","og_description":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/","og_site_name":"JTL-Guide","article_modified_time":"2023-06-14T12:55:30+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/","name":"Executing SQL on the database &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2019-01-14T14:12:29+00:00","dateModified":"2023-06-14T12:55:30+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Wawi","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/"},{"@type":"ListItem","position":2,"name":"Database","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/"},{"@type":"ListItem","position":3,"name":"Executing SQL on the database"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=191974"}],"version-history":[{"count":1,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191974\/revisions"}],"predecessor-version":[{"id":192001,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191974\/revisions\/192001"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191953"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=191974"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=191974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}