表数据null值清除

-- =============================================
-- Author:-- Create date:-- Description: <表数据null值清除>
-- =============================================
ALTER procedure [dbo].[ClearNull]
@tablename varchar(20)
as
begin
BEGIN TRANSACTION
declare @str1 varchar(5000)
declare @str2 varchar(5000)
declare @p1 varchar(20)
declare @p2 varchar(20)
set @str1='select a.name as name,b.name as descr into cmsmq_temp from syscolumns a LEFT JOIN systypes b ON a.xtype=b.xtype'
set @str1=@str1+' LEF