-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Archives: September 2015

Dynamic SQL & Quotename

Not quite fineprint, but sure feels like it!

Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.

However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more

0 comments, 625 reads

Posted in SQL Barbarian on 23 September 2015

Dynamic SQL & Quotename

Not quite fineprint, but sure feels like it!

Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.

However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more

0 comments, 134 reads

Posted in SQL Barbarian on 23 September 2015

XML Attribute VS Element Assignment when working with SQL

XML handling with aliases

I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias naming.

It’s a generally understood best practice to not use the deprecated syntax of column aliasing using a quoted name. For example:

select
[escapedWithBracketsIsGood] = case when raining then…
Read more

0 comments, 166 reads

Posted in SQL Barbarian on 21 September 2015

XML Attribute VS Element Assignment when working with SQL

XML handling with aliases

I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias naming.

It’s a generally understood best practice to not use the deprecated syntax of column aliasing using a quoted name. For example:

select<br></br>
[escapedWithBracketsIsGood] = case when raining then…
Read more

0 comments, 73 reads

Posted in SQL Barbarian on 21 September 2015

Split personality text editing in SSMS with Sublime Text 3

Split personality text editing in SSMS with Sublime Text 3

My preview post showed a demonstration of the multi-cursor editing power of Sublime Text 3 when speeding up your coding with SQL server.

There is a pretty straight forward way to setup sublime (or one of your preferred text editors)… Read more

0 comments, 530 reads

Posted in SQL Barbarian on 14 September 2015

Split personality text editing in SSMS with Sublime Text 3

Split personality text editing in SSMS with Sublime Text 3

My preview post showed a demonstration of the multi-cursor editing power of Sublime Text 3 when speeding up your coding with SQL server.

There is a pretty straight forward way to setup sublime (or one of your preferred text editors)… Read more

0 comments, 66 reads

Posted in SQL Barbarian on 14 September 2015

Multi-Cursor Editing SQL feels like the movie Inception just became real

  • Yes… multicursor editing is epic
  • No… SSMS doesn’t support multi-cursor editing the way it should.
  • Yes… you can do some basic editing with multiple lines using alt-shift
  • No… it doesn’t come close to what you can do with Sublime.

Cool thing is you can open text in Sublime synced w/SSMS… Read more

0 comments, 282 reads

Posted in SQL Barbarian on 10 September 2015

Multi-Cursor Editing SQL feels like the movie Inception just became real

- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should. - Yes… you can do some basic editing with multiple lines using alt-shift - No… it doesn’t come close to what you can do with Sublime.

Cool thing is you can open text… Read more

0 comments, 84 reads

Posted in SQL Barbarian on 9 September 2015