Click here to Skip to main content
15,348,239 members
Home / Discussions / Database
   

Database

 
GeneralRe: Read Only Database Pin
Mycroft Holmes25-Jun-14 0:35
professionalMycroft Holmes25-Jun-14 0:35 
GeneralRe: Read Only Database Pin
Bastien Vandamme26-Jun-14 0:02
MemberBastien Vandamme26-Jun-14 0:02 
QuestionGet the max elements in a join? Pin
Bastien Vandamme22-Jun-14 17:14
MemberBastien Vandamme22-Jun-14 17:14 
AnswerRe: Get the max elements in a join? Pin
Kornfeld Eliyahu Peter22-Jun-14 19:31
professionalKornfeld Eliyahu Peter22-Jun-14 19:31 
AnswerRe: Get the max elements in a join? Pin
Jörgen Andersson22-Jun-14 20:08
professionalJörgen Andersson22-Jun-14 20:08 
QuestionIs it recommended to use trigger to manage business rules with SQL Server? Pin
Bastien Vandamme22-Jun-14 17:00
MemberBastien Vandamme22-Jun-14 17:00 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 19:15
professionalKornfeld Eliyahu Peter22-Jun-14 19:15 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
GuyThiebaut22-Jun-14 21:59
professionalGuyThiebaut22-Jun-14 21:59 
Kornfeld Eliyahu Peter wrote:
trigger fires trigger that fires trigger...and so on.

With SQL Server there is an inbuilt protection system where you will not get a recursive firing of triggers.
I tested this recently as I was concerned about this sort of behaviour.
“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 22:02
professionalKornfeld Eliyahu Peter22-Jun-14 22:02 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 22:20
professionalJörgen Andersson22-Jun-14 22:20 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 22:21
professionalKornfeld Eliyahu Peter22-Jun-14 22:21 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 22:24
professionalJörgen Andersson22-Jun-14 22:24 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 22:28
professionalKornfeld Eliyahu Peter22-Jun-14 22:28 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 19:52
professionalJörgen Andersson22-Jun-14 19:52 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Mycroft Holmes23-Jun-14 1:04
professionalMycroft Holmes23-Jun-14 1:04 
QuestionCompare two tabel and add/update query Pin
member002618-Jun-14 20:44
Membermember002618-Jun-14 20:44 
AnswerRe: Compare two tabel and add/update query Pin
Mycroft Holmes18-Jun-14 22:33
professionalMycroft Holmes18-Jun-14 22:33 
QuestionValidate Date Time value on Sqlite before insert / update Pin
rahmat198517-Jun-14 22:29
Memberrahmat198517-Jun-14 22:29 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
Mycroft Holmes17-Jun-14 22:57
professionalMycroft Holmes17-Jun-14 22:57 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen18-Jun-14 0:28
professionalEddy Vluggen18-Jun-14 0:28 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Mycroft Holmes18-Jun-14 12:44
professionalMycroft Holmes18-Jun-14 12:44 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Bernhard Hiller19-Jun-14 22:26
MemberBernhard Hiller19-Jun-14 22:26 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen20-Jun-14 0:30
professionalEddy Vluggen20-Jun-14 0:30 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 9:45
professionalPIEBALDconsult20-Jun-14 9:45 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen20-Jun-14 10:01
professionalEddy Vluggen20-Jun-14 10:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.