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 |
|
LewMar010
Starting Member
1 Post |
 Posted - 2008-05-01 : 11:28:46
|
| Hello all.For my first foray into this forum I have a tricky one....We have a table in our database called tblJob with two columns: id IDENTITITY(1,1) jobNbr VARCHAR (5) (This would be, for example '12323') When a new job is created (i.e. job Number 12323), the client wants a trigger on this table that creates a new table called tblJobData12323.Does anyone know how I can accomplish this?Thank you in advance.PJPJ |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-01 : 13:07:38
|
| Why do you want to do this? So you will keep on adding new tables for each new job record created in tblJob? |
 |
|
|
|
|
|
Stretching the Limits of Triggers in SQL Server