{"id":61,"date":"2013-04-22T23:59:00","date_gmt":"2013-04-22T23:59:00","guid":{"rendered":"http:\/\/ashokaon.tech\/?p=61"},"modified":"2020-07-18T00:20:53","modified_gmt":"2020-07-17T18:50:53","slug":"easiest-way-to-generate-insert-script-in-sql-server","status":"publish","type":"post","link":"https:\/\/ashokaon.tech\/blog\/easiest-way-to-generate-insert-script-in-sql-server\/","title":{"rendered":"Easiest way to Generate Insert Script in SQL Server"},"content":{"rendered":"<p><span style=\"font-size: 10px;background-color:#FFFF99;display:block\">(Note: This blog post was originally published under my old domain(codesmiles.com), <a href=\"http:\/\/codesmiles.com\/post\/Easiest-Way-To-Generate-Insert-Script-in-SQL-Server.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>. <a href=\"https:\/\/web.archive.org\/web\/2013*\/http:\/\/codesmiles.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Web Archive link<\/a>.<\/span><\/p>\n<p>We all know that there is no handy built-in command for generating insert statements for the data present in a table in SQL Server (apart from issuing a Generate Scripts\u2026 command on the Database and choosing to Script Data also).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"sql-server-generate-insert-statements-ssmstools\" src=\"blog\/wp-content\/uploads\/sql-server-generate-insert-statements-ssmstools.jpg\" border=\"0\" alt=\"sql-server-generate-insert-statements-ssmstools\" width=\"240\" height=\"118\"><\/p>\n<p>There is this tool called <a href=\"http:\/\/www.ssmstoolspack.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SSMS Tools pack<\/a> which I am using for years that provides a handy way to generate scripts for various purposes including Insert statements when you just right click the table for which you need the scripts.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"display: inline\" title=\"sql-server-generate-insert-statements\" src=\"blog\/wp-content\/uploads\/sql-server-generate-insert-statements.jpg\" alt=\"sql-server-generate-insert-statements\" width=\"516\" height=\"348\"><\/p>\n<p>You can get the complete set of features provided by the tool <a href=\"http:\/\/www.ssmstoolspack.com\/Features\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p>I\u2019ll try to post about other cool features of <a href=\"http:\/\/www.ssmstoolspack.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SSMS Tools Pack<\/a> in future.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>(Note: This blog post was originally published under my old domain(codesmiles.com), here. Web Archive link. We all know that there is no handy built-in command for generating insert statements for the data present in a table in SQL Server (apart from issuing a Generate Scripts\u2026 command on the Database and<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,21,22],"tags":[19,18,20,14],"_links":{"self":[{"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/posts\/61"}],"collection":[{"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":3,"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":284,"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/posts\/61\/revisions\/284"}],"wp:attachment":[{"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ashokaon.tech\/blog\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}