Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Why SQL Server converts '' to zero RE: Why SQL Server converts '' to zero

  • July 25, 2013 at 1:15 pm

    #1635891

    I asked this same question a few months back and got some good replies; just thought I'd share this:

    http://www.sqlservercentral.com/Forums/Topic1397471-391-1.aspx

    Check this out:

    SELECT CAST(REPLICATE(CAST('' AS int),10) AS char(10)) AS [10 0's]

    SELECT 22+$ AS [$22.00]

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001