Home Forums SQL Server 2008 SQL Server 2008 - General how to make sproc return errors for underlying table errors RE: how to make sproc return errors for underlying table errors
ScottPletcher
SSC Guru
Points: 100948
More actions
July 1, 2015 at 2:48 pm
#1809668
You didn't get an error because a bit column will treat any value greater than 1 as 1, so SQL converted the "2" to a 1.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.