Data in a formatted table in SQL Server

server| data in the database development, due to the arbitrary user input information, may be generated in the table string type of
Data at both ends of the existence of spaces, or the case of inconsistencies, to the future data application process caused unnecessary trouble. This is a simple use of a stored procedure to solve these problems.

/* Collation System Data * *
CREATE PROCEDURE Pro_clearupdata
As
--The first part of the collation string data to remove the space between the two ends
DECLARE @tableName varchar (50)--table name
DECLARE @columnName varchar (50)--Column name
Declare cur_find cursor FOR select So.name,sc.name
From Syscolumns SC, sysobjects so, Systypes St
where So.name <> ' dtproperties '
and St.xtype=sc.xtype
and st.name= ' varchar '
and Sc.id=so.id
and so.xtype= ' u '
--Find all user tables that contain varchar type fields
Open Cur_find
FETCH NEXT from Cur_find into @tableName, @columnName
While @ @fetch_status =0
Begin
--Remove both ends of field space
EXEC (' update ' + @tableName + ' Set ' + @columnName + ' =ltrim (RTrim (' + @columnName + '))
FETCH NEXT from Cur_find into @tableName, @columnName
End
Close Cur_find
Deallocate Cur_find
Go