测试看看declare @table table(id int identity(1,1),pid int not null,code nvarchar(10) null,name nvarchar(20) default '') insert into @table (pid,code,[name]) values (0,'C01',null) insert into @table (pid,code) values (0,null) insert into @table (pid) values (0) select * from @table
在存储过程中用isnull函数也是可以的吧. select id,pid,isnull(code,'') as code,isnull([name],'') as [name] from @table
如果你使用的是ORACLE数据库,那么你可以使用nvl函数 select nvl(a.xxx,'') from tablename 或使用decode select decode(a.xxx,null,'',a.xxx) from tablename
insert into @table (pid,code,[name]) values (0,'C01',null)
insert into @table (pid,code) values (0,null)
insert into @table (pid) values (0)
select * from @table
select id,pid,isnull(code,'') as code,isnull([name],'') as [name] from @table
select nvl(a.xxx,'') from tablename
或使用decode
select decode(a.xxx,null,'',a.xxx) from tablename