Category Archives: T-SQL

  1. Escaping strings

    Leave a comment

    September 24, 2018 by Kenneth Fisher

    No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom. …
    Continue reading

  2. You can’t DELETE TOP (x) with an ORDER BY

    8

    September 19, 2018 by Kenneth Fisher

    Did you know you can’t do this? Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword …
    Continue reading

  3. Using Table Valued Parameters with sp_executesql

    3

    September 13, 2018 by Kenneth Fisher

    Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to …
    Continue reading

  4. SQL Puzzle: Advent of Code

    Leave a comment

    August 29, 2018 by Kenneth Fisher

    A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
    Continue reading

  5. Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties

    3

    August 20, 2018 by Kenneth Fisher

    Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
    Continue reading

  6. What are my permissions?

    1

    August 16, 2018 by Kenneth Fisher

    Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
    Continue reading

  7. Counting NULLs

    4

    July 16, 2018 by Kenneth Fisher

    Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As …
    Continue reading

  8. Code I’d Hate To Live Without: T-SQL Tuesday #104

    3

    July 10, 2018 by Kenneth Fisher

    It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his …
    Continue reading

  9. SQL Puzzle – FizzBuzz3d

    18

    June 27, 2018 by Kenneth Fisher

    I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case …
    Continue reading

  10. Strings vs Identifiers

    3

    June 20, 2018 by Kenneth Fisher

    A common mistake, and one I make frequently myself is to use a string in place of an identifier, or …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,486 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013