Post reply

Insert Generator - Stored Procedure

  • March 22, 2014 at 1:14 am

    #289628

    Comments posted to this topic are about the item Insert Generator - Stored Procedure

  • April 15, 2014 at 3:00 am

    #1706015

    Very nice stored proc. However would like you to explain it in at various places

    such as

    what is the use of sys.index_columns

    I mean thorough explanation would also be very helpful.

    Thanks

    Lokesh

    email - er.lokeshsharma08@gmail.com

    Lokesh Sharma
    sql4all.org

  • April 15, 2014 at 6:54 pm

    #1706275

    The sys.index_columns view is utilized because it gives me the ability to join to the key_constraints view to see if the identity column is a primary key or not. This important due to the procedure parameters I accept.

    This procedure builds out a query, that when executed (which the procedure does), the results will generate the INSERT script. Based on the parameters entered it will either include the existing IDENTITY values or it will leave them out of the INSERT script. If excluded, new IDENTITY values will be generated in the destination table upon execution.

    The cursor in the procedure loops through each field in a table analyzing the field data type to determine how the select statement needs to be built out. Based on the parameters it could be built out with NOT EXISTS statements so duplicate data is not entered or it will script out just the INSERT statement.

  • July 15, 2015 at 1:07 am

    #1812544

    It is not working for tables having UNIQUEIDENTIFIER data type. (GUID)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply