SQLServerCentral / Discuss Content Posted by Gregory Larsen / Article Discussions / Article Discussions by Author / Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 14:30:14 GMT20RE: Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statementhttp://www.sqlservercentral.com/Forums/Topic1238575-90-1.aspxVery good question. Looks like the article output is incorrect. The id values should be 19 and 20. I'll will get this update. Thank you for pointing this out. GregMon, 29 Oct 2012 21:41:37 GMTGreg LarsenRE: Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statementhttp://www.sqlservercentral.com/Forums/Topic1238575-90-1.aspxWhy does the Id column in listing 9 start with 21 after the previous is dropped and the new one is made an identity?Sorry... newbie here.Mon, 29 Oct 2012 11:23:08 GMTScottC91RE: Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statementhttp://www.sqlservercentral.com/Forums/Topic1238575-90-1.aspxAnother useful variation of the INSERT command is the "SIF" format to create a table with fields based on the source table:[code="plain"]SELECT Id, Name, Quantity INTO SomeOtherTable -- Or even @SomeOtherTable FROM Fruit[/code]This will create a table ("SomeOtherTable") with the Id, Name, and Quantity columns from the Fruit table. You can specify a WHERE clause to limit the records you pull out (WHERE Quantity &gt; 2). Useful for on-the-fly requirements to get a subset of records out of a larger table to manipulate or scan through.Wed, 05 Sep 2012 09:48:56 GMTACinKCRE: Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statementhttp://www.sqlservercentral.com/Forums/Topic1238575-90-1.aspxI was unaware of the output option for this. I'm not sure I'll ever really need it but it is cool to know I have the option.Wed, 05 Sep 2012 07:19:18 GMTjfogelStairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statementhttp://www.sqlservercentral.com/Forums/Topic1238575-90-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/75781/">Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement</A>[/B]Thu, 19 Jan 2012 05:38:10 GMTGreg Larsen