Reputation
1,580
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 9 27
Newest
 Caucus
Impact
~96k people reached

Jul
27
awarded  Caucus
May
25
awarded  Nice Answer
May
3
awarded  Taxonomist
Apr
17
awarded  Nice Question
Feb
25
comment Is it okay to put dots in SQL Server database names?
Why use a dash - when you can use an underscore _ and not have to enclose the name in square brackets at all?
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Ugh... column names with spaces in them...
Feb
5
awarded  Self-Learner
Feb
5
comment Easily show rows that are different between two tables or queries
@MarkStorey-Smith In the spirit of better late than never, I've provided DDL and DML with sample data.
Feb
5
revised Easily show rows that are different between two tables or queries
Add DDL and DML
Feb
5
revised Easily show rows that are different between two tables or queries
added 255 characters in body
Feb
5
revised Easily show rows that are different between two tables or queries
Formatting, changed alias style
Feb
5
comment Easily show rows that are different between two tables or queries
It's not a typo, it's equivalent to SELECT 'A' AS Which. However, I prefer the Alias = Column syntax and should have written it that way--changing it now.
Jan
28
awarded  Yearling
Dec
8
awarded  Popular Question
Sep
30
awarded  Explainer
Sep
24
awarded  Autobiographer
Jul
22
awarded  Notable Question
Jul
2
awarded  Curious
Apr
10
awarded  Notable Question
Mar
7
awarded  Famous Question