I thought it was 20 characters and not 30 inside CAST/CONVERT.

Thanks for the straightforward and back-to-basics question.

+1

For one moment, I thought there was a catch somewhere as the question and code all looked very easy.

It's interesting how the first part of the UNION is a derived...

Are you using a administrator account to install?

It seems like a restriction on the Windows side to me.

Keep in mind that in SQL Server, variables are declared with a @ character before the name. Sometimes I forget that because I work...

Steve Jones - SSC Editor (6/28/2012)

---

Glad you liked it, but I can't take credit for discovering this. Mr Randal, of SQL Skills, taught me this. Now I really want to...

Thank you for the explanation, Gail.

I've never tried that myself and was wondering.

Interesting question! Thank you!

But I was confused with the alternative:

"Take either a full OR differential backup and then a log backup"

Shouldn't this be:

"Take either a full AND differential backup and...

Great question! Thought it would be 2. But there is a explicit transaction beginning there.

I just didn't know it would all be rolled back on error. Does the XACT_ABORT setting...

All I have to say is: keep those questions coming. 😀

Exactly...

Duncan Pryde (6/27/2012)

---

You can't define indexes explicitly (i.e. by CREATE INDEX) in a CREATE TABLE statement. As far as I know the only way to create indexes in CREATE TABLE...

Hugo Kornelis (6/22/2012)

---

codebyo (6/22/2012)

---

Thanks for the question and thanks to Hugo for the detailed explanation.

This could be a useful code to set some fields from a a few restricted rows...

Thanks for the question and thanks to Hugo for the detailed explanation.

This could be a useful code to set some fields from a a few restricted rows to some value...

Sean Lange (6/19/2012)

---

Thomas Abraham (6/19/2012)

---

Sean Lange (6/19/2012)

---

I wish my mind was still...