SPROC multipe inderts in tables

nikosdra · July 26th, 2003, 03:17 PM

Hello, here's what I want to do:

In my Sproc I declare a parameter, and then I want to insert the value of this parameter in 4 different tables (one after another, just in one field, the other fields will accept default values).

Can I do this easily in ONE Stored Proc???

Thanks in advance

Nick

Jeff Mason · July 26th, 2003, 04:10 PM

Quote:

quote:Can I do this easily in ONE Stored Proc???

Sure. You just place the INSERT statements one after another:

Code:

INSERT INTO Table1 (T1Col)
    VALUES (@Parameter);

INSERT INTO Table2 (T2Col)
    VALUES (@Parameter);

INSERT INTO Table3 (T3Col)
    VALUES (@Parameter);

etc.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com