Category Archives: T-SQL

  1. To the page and back again


    January 18, 2016 by Kenneth Fisher

    To the page It’s not one of those things you have to do frequently but every now and again you …
    Continue reading

  2. What is RESULT SETS?


    January 14, 2016 by Kenneth Fisher

    I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before …
    Continue reading

  3. What does that N in nvarchar really mean?


    December 28, 2015 by Kenneth Fisher

    In any study of Data Types in SQL Server you are going to have to look at the various string …
    Continue reading

  4. What is the current database context?


    December 21, 2015 by Kenneth Fisher

    Every now and again it can be very helpful to know what the current database context is when you are …
    Continue reading

  5. Hiding one or more columns

    Leave a comment

    November 12, 2015 by Kenneth Fisher

    This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain …
    Continue reading

  6. Generating scripts for previous versions of SQL


    October 21, 2015 by Kenneth Fisher

    I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
    Continue reading

  7. Working with “special” names


    October 19, 2015 by Kenneth Fisher

    What do you do when you need to use a special character in a name? Well, I guess I should …
    Continue reading

  8. Updating a view


    September 30, 2015 by Kenneth Fisher

    I was recently asked how to update views. Specifically the question was about using triggers to update a view. So …
    Continue reading

  9. “sql_handle” is not a recognized table hints option.

    Leave a comment

    September 23, 2015 by Kenneth Fisher

    I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
    Continue reading

  10. Using @@ROWCOUNT can be a bit tricky


    September 16, 2015 by Kenneth Fisher

    @@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently …
    Continue reading


Get every new post delivered to your Inbox.

Join 847 other followers