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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Feeding data into multiple tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-08 : 09:27:33
Ali writes "I am a production DBA but the people at work are developing a Web Site (using Win2K, SQL2K, IIS 5.0 and Commerce Server 2K) and want me to make suggestions as to how to quickly update a table in real time with changes to a handful of rows that then get percolated to other linked tables quickly and without too much overhead.

I was thinking along the lines of triggers and a SP that maybe you pass a few variables to, is the best way to do it?

Apologise in advance if this question is too simplistic but I am not a developer!

Regards

ALI"
   

- Advertisement -