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 - 2005-06-17 : 07:55:34
|
| Henry writes "Hi,I am new to programming and i am writting a software in Java and to run on an SQL server database. My question is, can any take a look at my table realationship and tell me whether what i have done is correct adn the kind of triggers to use?This is the project specification: "A tape maintenance database for a church". When a new tape is inserted into the form it should first chech a table called previous tape to see if the tape exists and if it does it display "A tape with that name exists" otherwise it is saved. Now i want the tape information when inserted to fire a trigger and the trigger should insert into the other tables.Please, i need advice on this scenario adn how i should go about it.Thank you SQL team." |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-17 : 09:56:26
|
| sounds OK whats the problem.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
|
|
|
triggers