{"id":651,"date":"2019-04-05T00:11:15","date_gmt":"2019-04-05T07:11:15","guid":{"rendered":"https:\/\/doubleecpu.com\/?page_id=651"},"modified":"2019-06-26T00:40:44","modified_gmt":"2019-06-26T07:40:44","slug":"sql-server","status":"publish","type":"page","link":"https:\/\/doubleecpu.com\/index.php\/shop\/sql-server\/","title":{"rendered":"SQL Server"},"content":{"rendered":"\n<p>Create Node.js apps using SQL Server on Windows<\/p>\n\n\n\n<p>1 <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/developer-get-started\/node\/windows\/\">Setup SQL Server<\/a><br>Setup basic installation type, read and Accept the license terms, Select installation location, Install<\/p>\n\n\n\n<p>2 Install Chocolately and Node.js on Windows 10 using command prompt (cmd)<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">@\"%SystemRoot%\\System32\\WindowsPowerShell\\v1.0\\powershell.exe\" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command \"iex ((New-Object System.Net.WebClient).DownloadString('https:\/\/chocolatey.org\/install.ps1'))\" &amp;&amp; SET \"PATH=%PATH%;%ALLUSERSPROFILE%\\chocolatey\\bin\"<br><\/pre>\n\n\n\n<p>3 Install nodejs using command prompt<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">choco install -y nodejs<\/pre>\n\n\n\n<p>4 Install the <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=56567\">OBDC Driver <\/a>Microsoft\u00ae ODBC Driver 17 for SQL Server<\/p>\n\n\n\n<p> 5 Install <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=53591\">sqlcmd <\/a>Microsoft\u00ae Command Line Utilities 14.0 for SQL Server<\/p>\n\n\n\n<p>6 Install <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-2017\">SSMS<\/a> Microsoft\u00ae Download SQL Server Management Studio<\/p>\n\n\n\n<p>7 Connect to SQL Server using the command prompt<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlcmd -S localhost -U sa -P your_password<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Create Node.js apps using SQL Server on Windows 1 Setup SQL ServerSetup basic installation type, read and Accept the license terms, Select installation location, Install 2 Install Chocolately and Node.js on Windows 10 using command prompt (cmd) @&#8221;%SystemRoot%\\System32\\WindowsPowerShell\\v1.0\\powershell.exe&#8221; -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command &#8220;iex ((New-Object System.Net.WebClient).DownloadString(&#8216;https:\/\/chocolatey.org\/install.ps1&#8217;))&#8221; &amp;&amp; SET &#8220;PATH=%PATH%;%ALLUSERSPROFILE%\\chocolatey\\bin&#8221; 3 Install nodejs using command &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/doubleecpu.com\/index.php\/shop\/sql-server\/\" class=\"more-link\">Read more<span class=\"screen-reader-text\"> &#8220;SQL Server&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":22,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-651","page","type-page","status-publish","hentry"],"featured_media_urls":[],"_links":{"self":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/comments?post=651"}],"version-history":[{"count":0,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/651\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/22"}],"wp:attachment":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/media?parent=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}