SQL Server
去掉首尾空格
代码
UPDATE 表table
SET 属性a = RTRIM(LTRIM(属性a))
示例
UPDATE BU8MC_MatInfo_Loss
SET MatId = RTRIM(LTRIM(MatId)),
MatName = RTRIM(LTRIM(MatName)),
Department = RTRIM(LTRIM(Department)),
Station = RTRIM(LTRIM(Station)),
StorageType = RTRIM(LTRIM(StorageType))