[Quote]L' Eomot Inversé

---

I agree that relational programming would be very different from writing .net apps, but I'm not really sure you can do relational programming in SQL.

[/Quote]

I dont know if...

Ok, I'm hijacking my own thread, 😀

Create Table Orders

(

OrderID BigInt Identity(1,1) Not Null,

CustomerID BigInt Not Null,

Constraint [PK_Orders] Primary Key(OrderID)

)

go

Create Table Customers

(

CustomerID BigInt Not Null Identity(1,1),

...

Sean Lange (9/21/2012)

---

I still say you are asking for nothing but trouble trying to keep this stuff stored like this but if you are insistent on doing it then I...

I finally decided to use CTE in this trigger after reading Sql Documentation and googling:

CREATE TRIGGER [trUpdateOrderTotal]

ON [dbo].[OrderDetail]

FOR DELETE, INSERT, UPDATE

AS

BEGIN

Declare @evt Int = 0;

SET NOCOUNT ON

IF(EXISTS(SELECT * FROM inserted))

Set...

Sean Lange (9/20/2012)

---

F8R (9/20/2012)

---

Thank you for all hint and sugestion, I think I need to unlearn my 'old' knowledge, :D.

I'm new to Sql Server and honestly, I'm not very good...

Thank you for all hint and sugestion, I think I need to unlearn my 'old' knowledge, :D.

I'm new to Sql Server and honestly, I'm not very good at Database Design...