I disagree, naming conventions should reflect the factory needs. So, it may be that [Sales.XXX] is good in some environment.

If I want to be pedant, the right answer is "All of the above".

Because of lacking of batch separator "GO".

If you run the script no procedure is created.

paul 25096 (11/4/2015)

---

I think the reason "Options 1, 2 and 3" has more votes than "Option 2" is because of course you should also avoid statements that cause a syntax...

Excellent!

I get it wrong because I forgot this from BOL:

READUNCOMMITTED and NOLOCK hints apply only to data locks. All queries, including those with READUNCOMMITTED and NOLOCK hints, acquire Sch-S (schema...

Easy questions.

Thanks!

😀

But, what happen?

Interesting question!

Thanks.

Toreador!

Default collation is case insensitive.

😀

Good!

Next month I want to start using filetable.

I'm really curious.

😀

I couldn't test it, but I find this:

https://msdn.microsoft.com/en-us/library/gg492086%28v=sql.120%29.aspx

Ed Wagner (9/2/2015)

---

I'm thinking that your thinking is right. 😉

I wonder if this counts as...

"String literals as column aliases" are a deprecated feature!

Louis Hillebrand (9/2/2015)

---

3 or 9 depends how you define different...

column AS alias

column AS 'alias'

column AS [alias]

column alias

column 'alias'

column [alias]

alias = column

'alias' = column

[alias] = column

And I didn't use double quotes.

I...

The right answer

SELECT mynum AS test

FROM dbo.myTable AS mt;

SELECT test = mynum

FROM dbo.myTable AS mt;

SELECT 'test' = mynum

FROM dbo.myTable AS mt;

SELECT mynum test

FROM dbo.myTable AS...

That's a...