dalewilbanks.net

Home

This website exists to…

  • Demonstrate latest technology for building Web,Mobile, and SOA Applications
  • Document best practices for application development across all disciplines

This site started with the ASP.Net MVC3 Web Application template, and was modified to correct the navigation tabs. The site uses jQuery and jQueryUI controls.


MERGE – the ultimate TSQL statement.  Great article from Hugo Kornelius on replacing UPDATE..FROM with MERGE.
Just starting using MERGE (aka UPSERT) as a replacement for TSQL’s UPDATE..FROM, and may start using it for INSERT also. Could MERGE replace both INSERT and UPDATE in my toolbox? hmm…


TSQL Best Practices – example code from the Spark 2015 conference.

Download here


TSQL – Parameterized WHERE clause

If you are not using sprocs, but creating sql on the fly, it should be parameterized, not string concatenated, for performance and security reasons.   How do you make your WHERE clause parameters optional?  SqlTeam has a great article on this:

http://www.sqlteam.com/article/implementing-a-dynamic-where-clause

Simply use  columnA = COALESCE(@paramA, columnA).    If paramA is null, then you get columnA = columnA, and all rows will return.  Simple and genius 😉


“Don’t Make Me Think, Revision 3”


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s