Thursday, June 16, 2011

how to produce 0 without using any number in sql server ?


1.
select $
2.
select £
3.
Declare @num int
Set @num = ''
Select @num

this is more useful. see what happens when a set an integer to null

Note that the following does NOT produce 0, it will produce NULL

Declare
Select
@num int @num

No comments:

Post a Comment