Monthly Archives: February 2013

  1. Insert multiple values sets into a table in one command


    February 28, 2013 by Kenneth Fisher

    The INSERT command has two distinct ways to load data into a table. And Both of these are very handy …
    Continue reading



    February 25, 2013 by Kenneth Fisher

    When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic …
    Continue reading

  3. Multiple instances, single query window


    February 18, 2013 by Kenneth Fisher

    Anyone who has been reading my blog for a while should realize that several divisions in my company have been …
    Continue reading

  4. Something to watch out for when using sp_rename on Stored Procedures, Functions and Views


    February 11, 2013 by Kenneth Fisher

    For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically …
    Continue reading

  5. EXECUTE, not required, but advisable.


    February 6, 2013 by Kenneth Fisher

    The other day one of the developers I work with gave me a script similar to this: He was getting …
    Continue reading

  6. Duplicate rows in a table


    February 4, 2013 by Kenneth Fisher

    I recently got the following email: “I just keyed in two rows into a table with all identical column values. …
    Continue reading

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013