Returning Decimal

I need to know a general syntax for inserting user information from an application into 6 Tables using one stored procedure. Is it something like:

Select fieldname, fieldname AS INSERT INTO tablename (@fieldname, @fieldname)

and keep going down the line, or do I need a BEGIN or GO somewhere?

Thanks!

INSERT into <tablename>
(field1, field2)
Values
(@Value1, Value2)

------------
Alice at 3/3/01 8:49:56 AM


I need to know a general syntax for inserting user information from an application into 6 Tables using one stored procedure. Is it something like:

Select fieldname, fieldname AS INSERT INTO tablename (@fieldname, @fieldname)

and keep going down the line, or do I need a BEGIN or GO somewhere?

Thanks!

Thanks Paul! Even though I put this under a wrong heading! :)

------------
Paul at 3/3/01 9:05:22 AM


INSERT into <tablename>
(field1, field2)
Values
(@Value1, Value2)

------------
Alice at 3/3/01 8:49:56 AM


I need to know a general syntax for inserting user information from an application into 6 Tables using one stored procedure. Is it something like:

Select fieldname, fieldname AS INSERT INTO tablename (@fieldname, @fieldname)

and keep going down the line, or do I need a BEGIN or GO somewhere?

Thanks!