摘要:
createtable#temp(idintidentity(1,1),zisenvarchar(200))declare@zisenvarchar(200)declare@nintdeclare@rowsintselect@n=1insert#temp(zise)selectprosizefromttselect@rows=@@rowcountwhile@n<=@rowsbeginselect@zise=prosizefromttwhereprosize=(selectzisefrom#tempwhereid=@n)--对字段里面不规则空格进行化为一个空格set@zise=ltrim( 阅读全文