All Questions
4 questions
4
votes
1
answer
4k
views
Trigger/Event that fires when a Transaction finishes
I have a query that pulls from about 15 different tables. I am looking to materialize this into a table that stores it in xml/json. (To improve performance.)
The problem I have is that these tables ...
- 2,540
2
votes
1
answer
5k
views
Handling duplicate values using trigger
I have a database where tables are like:
tblCustomer(UserID [Primary Key],Facebook,Twitter,PhoneNum);
tblSales(InvoiceID [Primary Key],CustomerID [Foreign Key],ProductID [Foreign Key]);
I'm ...
- 313
1
vote
1
answer
13k
views
Uncommitable T-SQL transaction after trigger applied to table
Good morning,
I have written a Trigger on a table that should evaluate the entered values (Length, width and Height) and based on those entered values, should update a column (Type) in the same record ...
- 185
0
votes
1
answer
82
views
Duplicate record inserted - why trigger is not preventing it?
I have two tables: DebitIUVs and RPTs. I have record inside DebitIUVs which is with state 118001. My business logic must insert new line inside RPTs table. Inside RPTs table there is additional ...
- 1,163