Also, if the identity increment was -1, then both option 1 and 3 would be correct, as there is no clustered index to order it, and no ORDER BY statement...

Interesting that the - got in the wrong place in the question, I saw the "-0" and thought that something might be up, but I picked that option anyhow since...

I agree, but I think variable concatenation is very commonly used, so it is important for people to...

Hugo KornelisI did read your post, but the Connect item you linked to was not what I meant when I wrote that I knew this to be documented by MS....

Great question, and a very understandable explanation. Thanks!

I figured it was possible because of trailing spaces, and tested it, but I messed my test rig up, so I got it wrong... 🙁

Thanks for the question!

Interesting question, thanks.

Thanks Oleg for the explanation of why it happens, I think most people don't already know that, so it is very helpful.

I think it is interesting that people say they are losing...

Interesting question, but I don't know that I would expect everyone to have the system DB IDs memorized. (Or even to know that DBs have IDs.) But given some basic...

Jonathan AC Roberts (6/21/2010)

Both methods achieve the same thing but using certificates is generally recommended. Some things are different for example if there is auditing a table with a trigger...

SQL_Elvis (6/21/2010)

---

One benefit is that the Certificate and certificate user account are managed outside of the stored procedure code and can be updated or the user account changed without having...

Nice question, it made me think a more than usual, thanks!

Nice question, thanks!

I agree only one of the choices seemed to be a disadvantage, which made me wonder if I was missing something.

I know a little old, but I am going through old questions. I didn't get it correct, as I didn't know that QA didn't properly recognize comments. So I learned...