1.0https://www.w3computing.com/sqlserver2012w3compadminhttps://www.w3computing.com/sqlserver2012/author/w3compadmin/INSERT Statement (INSERT INTO) - SQL Serverrich600338<blockquote class="wp-embedded-content" data-secret="RNslRPh5CI"><a href="https://www.w3computing.com/sqlserver2012/insert-statement-insert-into/">INSERT Statement (INSERT INTO)</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.w3computing.com/sqlserver2012/insert-statement-insert-into/embed/#?secret=RNslRPh5CI" width="600" height="338" title="“INSERT Statement (INSERT INTO)” — " data-secret="RNslRPh5CI" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://www.w3computing.com/sqlserver2012/wp-includes/js/wp-embed.min.js
</script>
The INSERT statement inserts rows (or parts of them) into a table. It has two different forms: Using the first form, exactly one row (or part of it) is inserted into the corresponding table. The second form of the INSERT statement inserts the result set from the SELECT statement or from the stored procedurehttp://www.w3computing.com/sqlserver2012/wp-content/uploads/sites/5/2018/04/example-7.9.png