Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darenkov
Yak Posting Veteran
90 Posts |
 Posted - 2005-01-24 : 01:51:16
|
| Hi again,I was hoping for some advice on best practice.I am pulling data from an asp.net page which I am hoping to insert into to separate tables.My problem is that I am not sure how to best do this. Can I get the values from the page via a procedure and insert into 2 separate tables within the same procedure? OR is there a better way, ie use a procedure to insert into first table, and then an AFTER TRIGGER to insert into the next? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-24 : 01:54:14
|
| Id use a stored proc.Actually, I'd question why you need two copies of the data first, then use a stored proc.Damian |
 |
|
|
darenkov
Yak Posting Veteran
90 Posts |
Posted - 2005-01-24 : 04:17:39
|
| i never said i needed two copies of the data. the data from the one page is actually intended for two separate tables, one being the MEMBER table and the other being the LOGIN table (as I am capturing information relating to both entities of the same page) |
|
|
|
|
|
|
insert values into multiple tables