Home Forums Article Discussions Article Discussions by Author Discuss content posted by Prasad Bhogadi Insert Update Stored Procedure for a table RE: Insert Update Stored Procedure for a table

  • January 28, 2008 at 9:57 am

    #772530

    Prasad Bhogadi (1/28/2008)

    Hello Rod,

    Thank you for the comments, I see what you were doing! You tried to generate the stored procedure for a table that has no Identity defined and as you might have noticed in my description about the stored procedure "Script asssumes that it has a primary key with auto identity defined".

    If you try generating the stored procedure for a table that has Identity defined for the primary key, you will be able to generate a complete stored procedure script with BEGIN and END.

    Thanking you for your suggestions and I would incorporate the logic to handle tables without IDENTITY column.

    Thanks

    Prasad

    Prasad, I completely missed that line ("Script assumes that it has a primary key with auto identity defined"). WOW, no wonder!! We have several tables, the vast majority of which don't have an identity column in them. Well, even so your script gives me the basics, which I think I can work with.

    Rod

    Kindest Regards, Rod Connect with me on LinkedIn.