The following will also work

CREATE TABLE [.[[.[[.[[.]].]].]].]]]

( myid INT

, mychar VARCHAR(200)

);

or

CREATE TABLE [[[[[[[]]]]]]]]]

( myid INT

, mychar...

The # needs to be inside the brackets

CREATE TABLE [#this.is.a.test]

Got it wrong. I've only used user defined table types, for which you need AS not FROM. I wonder why the syntax is different?

Larnu (11/4/2015)

---

But you've corrected the question now. The question wasn't should you avoid "Create procedure [1Myproc]", it's "Create procedure 1Myproc". With the same respect i could therefore say that "sp_MyProc"...

Larnu (11/4/2015)

---

But you can do it - I gave you the syntax.

Whether...

tripleAxe (11/4/2015)

---

You do have a choice - you could...

edwardwill (10/30/2015)

---

Toreador (10/30/2015)

---

The correct answer should be END TRY - the completion of the try, which scores 5 points in Union, 4 in League. The Try Conversion (TRY_CONVERT) then scores...

The correct answer should be END TRY - the completion of the try, which scores 5 points in Union, 4 in League. The Try Conversion (TRY_CONVERT) then scores an additional...

Maybe most people work in places where nobody is daft enough to do anything like this so it will have been a...

So how many pages of "the correct answer should be 5" replies will we...

Oops!

Interesting question, and I managed to get it wrong, even though that the question includes the answer!

"The following query ignores the SET LANGUAGE statement except under compatibility level 120: "

The correct answer is that an error occurs, as neither of those tables exists 😉

The correct answer is that an error is returned as the columns are defined as "Id" and referenced as "ID" 😉

I got it right, but with the wrong reasoning. My rationale was that there is a trivial way of getting the answer we need, so it's unlikely that SQLServer would...