var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: getting a constraint value from query in a trigger?
say i have a query like:
UPDATE table SET status = 1 WHERE id = 1000
if i have a trigger on that table, is there anyway i can get the id ?
i know i can get the status by SELECT status FROM Inserted, but anyway to get what the id is? or would i just have to update the id as well?
hmm, looks like i can't even get the id if i try to update since it's an identity column
SELECT id FROM inserted
inserted AND deleted are full blown copies of the table that's affected for the rows that are be modified or added.
You [Id] should be there
What are you trying to do?
oops, actually i just realized SELECT id from inserted works fine even though id isn't updated