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 |
|
B5CSE
Starting Member
25 Posts |
 Posted - 2005-04-05 : 10:28:53
|
| one tell me about the relations and its importance in database but another person tell me to the relations is not easy and danger and advise me to replace it by transactions I want to know can we replace relations by transactions and what are advantages and disadvatages of both ways note I donot more knowledge what is transactions as devloper |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-05 : 11:05:08
|
| You can't replace relations with transactions. Whoever told you this is stupid. If you don't know what transactions are as a developer, please stop developing. You can study all about them by buying ANY SQL Server book, or by looking up transaction in Books Online.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-04-05 : 11:12:50
|
DerrickTrying to translate his post maybe the person who said this to him/her meant use transactions and control the process flow in the transaction rather than rely on the referential integrity/constraints on the table(s)That was my take on it anyway, but i am probably wrong (i usually am!)AndyBeauty is in the eyes of the beerholder  |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-04-05 : 14:39:26
|
| Andy, I understood the post like You did.B5CSE, the person that "advices" you to "replace relations by transactions" does not knowwhat he is talking about, or he is very stupid. Ignore that "advice".Relations protects the integrity of Your data.Transactions protects data from being changed/overwritten within a process step.Oh well, just RTFM.rockmoose |
|
|
|
|
|
|
Relations or Transactions