你可以写一个语句,在适当的时候进行触发,来达到更改数据库的目的 update table1 set col1='' where col1 is null
比如双色球中的一条记录:很庞大啊。目的是达到了,但我做的比这个的例还要多得多,而且以后还有不同的表格,列都很多,妈妈莎,阿门! "select a0,isnull([01],'') as [01],isnull([02],'') as [02],isnull([03],'') as [03],"+ "isnull([04],'') as [04],isnull([05],'') as [05],isnull([06],'') as [06],isnull([07],'') as [07],"+ "isnull([08],'') as [08],isnull([09],'') as [09],isnull([10],'') as [10],isnull([11],'') as [11],"+ "isnull([12],'') as [12],isnull([13],'') as [13],isnull([14],'') as [14],isnull([15],'') as [15],"+ "isnull([16],'') as [16],isnull([17],'') as [17],isnull([18],'') as [18],isnull([19],'') as [19],"+ "isnull([20],'') as [20],isnull([21],'') as [21],isnull([22],'') as [22],isnull([23],'') as [23],"+ "isnull([24],'') as [24],isnull([25],'') as [25],isnull([26],'') as [26],isnull([27],'') as [27],"+ "isnull([28],'') as [28],isnull([29],'') as [29],isnull([30],'') as [30],isnull([31],'') as [31],"+ "isnull([32],'') as [32],isnull([33],'') as [33]hsj20041004(光芒) 你的方法尝试学习中,谢谢。
isnull(col,'')我把它写入select中试试,就col太多了,近百例(晕!:):))。
前端是c#.net的winForm中的datagrid.
update table1 set col1='' where col1 is null
"select a0,isnull([01],'') as [01],isnull([02],'') as [02],isnull([03],'') as [03],"+
"isnull([04],'') as [04],isnull([05],'') as [05],isnull([06],'') as [06],isnull([07],'') as [07],"+
"isnull([08],'') as [08],isnull([09],'') as [09],isnull([10],'') as [10],isnull([11],'') as [11],"+
"isnull([12],'') as [12],isnull([13],'') as [13],isnull([14],'') as [14],isnull([15],'') as [15],"+
"isnull([16],'') as [16],isnull([17],'') as [17],isnull([18],'') as [18],isnull([19],'') as [19],"+
"isnull([20],'') as [20],isnull([21],'') as [21],isnull([22],'') as [22],isnull([23],'') as [23],"+
"isnull([24],'') as [24],isnull([25],'') as [25],isnull([26],'') as [26],isnull([27],'') as [27],"+
"isnull([28],'') as [28],isnull([29],'') as [29],isnull([30],'') as [30],isnull([31],'') as [31],"+
"isnull([32],'') as [32],isnull([33],'') as [33]hsj20041004(光芒) 你的方法尝试学习中,谢谢。