Tag Archives: data types

  1. Conversion Precedence


    September 20, 2022 by Kenneth Fisher

    Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the …
    Continue reading

  2. Explicit and implicit datatype conversions


    August 25, 2022 by Kenneth Fisher

    Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because …
    Continue reading

  3. The sysname datatype defaults to not NULL.


    August 26, 2021 by Kenneth Fisher

    The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
    Continue reading

  4. Right sizing int : T-SQL Tuesday #136


    March 9, 2021 by Kenneth Fisher

    Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. …
    Continue reading

  5. What is the datatype SQL_VARIANT


    April 16, 2020 by Kenneth Fisher

    The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. …
    Continue reading


    Leave a comment

    January 27, 2020 by Kenneth Fisher

    If you read the title to this post and your first thought was That’s not SQL is it? then you …
    Continue reading

  7. SQL Homework – July 2019 – Table Size

    Leave a comment

    July 1, 2019 by Kenneth Fisher

    In general this homework series is meant to give you ideas of things to play with that most if not …
    Continue reading

  8. Data Types Word Search


    September 26, 2018 by Kenneth Fisher

    Just for fun here is a word search with all of the data types available in SQL Server. Well, two …
    Continue reading

  9. Using LEN wrong.


    June 2, 2016 by Kenneth Fisher

    I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
    Continue reading

  10. varchar(1) VS char(1)


    February 15, 2016 by Kenneth Fisher

    The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?) varchar(1) Really? It’s …
    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