281 reputation
1312
bio website stackexchange.com/users/…
location England
age 38
visits member for 2 years, 1 month
seen Oct 31 at 16:31

profile for SteB on Stack Exchange, a network of free, community-driven Q&A sites
Disclaimer: I like to wait at least an hour before accepting an answer.

Software developer, sci-fi and film/TV fan working on LOB apps using Delphi, T-SQL, PHP, HTML, CSS and Powershell.

I like to relax with good films, TV or books including: The Matrix, Underworld, Stargate, Buffy, The West Wing, and works by Joss Whedon, Ridley Scott, David Weber or Peter F. Hamilton.

In my spare time I assist with the browser-based football game Football Glory.


Jun
6
accepted Does the Inserted table contain Identity values?
Jun
6
comment Does the Inserted table contain Identity values?
Thanks - it's just deletes, your RowCount fixes this (from my so far limited testing). In retrospect, my original question is obviously Yes, the Identity value is in the Inserted table when running an Insert statement.
Jun
5
comment Does the Inserted table contain Identity values?
Removing the AuditTerms table isn't an option since we need the datetime of any deletes. I've re-read the MSDN article and didn't realise an update was essentially a Delete followed by an Insert and would therefore have data in the Deleted table. I'm having trouble following your logic how this causes the issue though.
Jun
4
comment Does the Inserted table contain Identity values?
@ypercube - I've added the TermKeys def and corrected the AuditTerms definition.
Jun
4
revised Does the Inserted table contain Identity values?
Added TermKeys definition, corrected AuditTerms definition
Jun
4
comment Does the Inserted table contain Identity values?
@MartinSmith - I've updated the question as requested
Jun
4
revised Does the Inserted table contain Identity values?
Added full trigger and table definition
Jun
4
comment Does the Inserted table contain Identity values?
@MartinSmith - I've removed a lot of code to try and illustrate the issue, there's a similar statement for checking the Deleted table, it's an INSERT, UPDATE, DELETE trigger. Should I separate the logic into discrete INSERT, UPDATE and DELETE triggers?
Jun
4
revised Does the Inserted table contain Identity values?
Add IF EXISTS check
Jun
4
asked Does the Inserted table contain Identity values?
Nov
18
awarded  Yearling
May
20
awarded  Constituent
May
20
awarded  Caucus
Feb
26
awarded  Informed
Feb
25
awarded  Fanatic
Feb
6
accepted Reference the database from a stored proc?
Feb
6
comment Reference the database from a stored proc?
Thanks, I'm thinking I'll pass the name into the sproc and have an option to run for all tables.
Feb
6
asked Reference the database from a stored proc?
Jan
21
awarded  Tag Editor
Jan
21
revised kerberos wiki excerpt
added 118 characters in body