I think this was a good demonstration of where these 2005+ features can be useful. I have a job coming up where this could really help.

IMO, none of the few...

Or something like:

UPDATE tbl_Question1Answers FROM

INSERTED JOIN tbl_Question1Answers ON INSERTED.<PrimaryKey> = tbl_Question1Answers.<PrimaryKey>

SET lastupdated = getdate()

For your scenario, I'm not aware of any significant practical difference between this and Gail's suggestion, I...

lars (11/23/2008)

---

if i execute the [dbo].[_SPLOG_AutoGenStatements] with different tables and option i get allways

this error msg.

Meldung 208, Ebene 16, Status 0, Prozedur _SPLOG_AutoGenStatements, Zeile 177

unknown Objectname '#sp'.

is there something missing...

I went through a similar exercise not long ago...

I haven't actually run the code from this article, since I'm quite happy with mine :P, but looked through it and...

RE: CR/LF/NewLine (Cade Roux)

Actually, with Transact-SQL, it's even easier, just embed the newline in your string. Try this in your Management Studio/Query Analyzer

SELECT 'This is a string

with some

embedded new line...

Ok, so I'm a (posting) noob on this site, but aren't loops discouraged in these forums?

If you have a zero-based Tally table, you can replace your initializer and loop with...