Category Archives: T-SQL

  1. How do I tell if identity_insert is turned on and if so what table?

    4

    June 24, 2022 by Kenneth Fisher

    TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty …
    Continue reading

  2. Running dynamic SQL in a different database

    9

    May 19, 2022 by Kenneth Fisher

    This is one of those things that on hindsight was a stupid problem, but still cost me hours and a …
    Continue reading

  3. How can I use the identity column, without knowing identity column’s name.

    Leave a comment

    May 12, 2022 by Kenneth Fisher

    One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The …
    Continue reading

  4. My job managing a calling list. : T-SQL Tuesday #150

    1

    May 10, 2022 by Kenneth Fisher

    I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I …
    Continue reading

  5. SQL Homework – May 2022 – Books on Line

    Leave a comment

    May 5, 2022 by Kenneth Fisher

    No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of …
    Continue reading

  6. Scripting with a temp stored procedure

    2

    March 17, 2022 by Kenneth Fisher

    A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time …
    Continue reading

  7. Shift calculations (or same time every day)

    2

    March 15, 2022 by Kenneth Fisher

    One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. …
    Continue reading

  8. An increased opportunity. Remote user groups. : T-SQL Tuesday #148

    Leave a comment

    March 8, 2022 by Kenneth Fisher

    Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a …
    Continue reading

  9. SQL Homework – March 2022 – Formatting

    Leave a comment

    March 1, 2022 by Kenneth Fisher

    Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries …
    Continue reading

  10. You can’t use GO in dynamic SQL.

    2

    February 10, 2022 by Kenneth Fisher

    This is one of those things that when I look back on it seems really obvious. Note: If at the …
    Continue reading

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

Join 3,705 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013