Why does MSSQL server allow the attached code to work

JasonB

Why can we define a integer datatype and pass an empty string in that gets evaluated to zero rather than NULL?

declare @testinteger integer
select @testinteger = ''
select @testinteger

How can we get this to eval to NULL?

ck9663

Because there's an explicit conversion of data. Read this, on the lower part there's a table that describe the im/explicit conversions.

Try this instead:

Expand|Select|Wrap|Line Numbers

  
declare @testinteger integer

select @testinteger = NULL

select @testinteger

Why does MSSQL server allow the attached code to work

re: Why does MSSQL server allow the attached code to work

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about