thanks guys... SCOPE_IDENTITY worked out well !!!

hi all,

Grasshopper's solution will not work out, since inheritance is something like when you change the column width at database level you need not to bother about procedure/function which uses...