Monthly Archives: February 2013

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

    8

    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

  2. DROP and CREATE vs ALTER

    24

    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

    Leave a comment

    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

    5

    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.

    1

    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

    19

    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 1,615 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013