ALTER PROCEDURE [dbo].[usp_Tool_TrimTable]
@tablename as sysname
AS
declare @strSQL as varchar(8000)
select @strSQL = ''
select @strSQL = @strSQL + '[' + name + '] = LTRIM(RTRIM([' + name + '])),' + char(10) from
(select distinct name from syscolumns where id = object_id(@tablename) and autoval is null and xtype in(175,239,231,167))
T
if @strSQL<>''
BEGIN
SELECT @strSQL = LEFT(@strSQL,len(@strSQL)-2)
SELECT @strSQL = 'UPDATE ' + @tablename + ' SET ' + char(10) + @strSQL
--PRINT @strSQL
EXEC(@strSQL)
END