Category Archives: T-SQL

  1. To the page and back again

    1

    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?

    11

    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?

    9

    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?

    3

    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

    1

    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

    4

    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

    2

    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

    2

    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

Follow

Get every new post delivered to your Inbox.

Join 847 other followers