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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-31 : 09:35:11
|
Chris writes "Let me begin by saying that I am VERY new to SQL programming. I am hoping there is a very simple solution to this problem.
I am trying to write a trigger and/or stored procedure system for a database that will Insert, Update, or Delete a respective record in one of several secondary, identical tables. The table chosen out of the secondary tables depends on the specific value found in a column of the original table. Thus, I need to be able to specify the name of the secondary table at run time.
I have researched the documentation and sources on the web and all I have been able to figure out is the "sp_ExecuteSQL" extended stored procedure. I have used the Northwind example provided in the documentation under "Building Statements at Run Time" as a model.
Anyone know of any other technique? Where can I look for further suggestions? What is the simplest solution for this problem?" |
|
|
|
|
|
Dynamic Run Time SQL