Combining Insert/Update to one Procedure

xodeblack

10 Jan 2012CPOL

257

@ID int,@Name char(20),@Mode char(20)You don't need to send @Mode param.@ID param is enough.If (@ID > 0 ) update...................................else insert....................................

Only logged in members can view this content

Please go to the SQL Table of Contents to view the list of available articles in this section.

Go to top