Generate Insert/Update/Delete Sprocs for a table

Total article views: 241 | Views in the last 30 days: 7

 Rate this |   Join the discussion |  Briefcase

A week ago I posted this script. It was a much simpeler version without error checking. Now all the sprocs return the same errors.

    0 THERE WERE NO ERRORS
  -99 UNEXPECTED NR OF RECORDS AFFECTED
  0 THE SQL ERROR NUMBER

Also with the insert statement the @ID is set. So you can retrieve the Identity of the last row inserted.

The construct with the returnvalue could be simpeler but then we could not use it with the .net applicationblocks.

This script will generate Insert,Update,Delete,Get stored procedures for a given table.

It will only work if the Primary key is also an Identity field.

If you like it vote for it.......

Total article views: 241 | Views in the last 30 days: 7