-
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!
-
Returning Decimal (reply)
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!
-
Returning Decimal (reply)
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|