IsNull("字段名") or 字段 is null http://topic.csdn.net/t/20020409/16/633784.html
if object_id('tempdb..#')is not null drop table # go create table #(PIC binary(100)) insert # select cast('test' as binary) insert # select null insert # select cast('' as binary) select * from # where isnull(cast(pic as varchar(100)),'')<>'' (影響 1 個資料列)*/
http://topic.csdn.net/t/20020409/16/633784.html
go
create table #(PIC binary(100))
insert # select cast('test' as binary)
insert # select null
insert # select cast('' as binary)
select * from # where isnull(cast(pic as varchar(100)),'')<>''
(影響 1 個資料列)*/
(SP_Picture)is not null