sql server 2005数据库中格式化信息并除去空白行

使用sql语句整理表中信息，除去空白行

整理入库信息：

UPDATE [al].[dbo].[bcd]
   SET [companyname] = ltrim(rtrim([companyname]))
      ,[main_products] = ltrim(rtrim([main_products]))
      ,[mode] = ltrim(rtrim([mode]))
      ,[phone] = ltrim(rtrim([phone]))
      ,[contact] =ltrim(rtrim([contact]))

UPDATE [al].[dbo].[bcd]
   SET [companyname] = replace([companyname],' ','')
      ,[main_products] = replace([main_products],' ','')
      ,[mode] = replace([mode],' ','')
      ,[phone] = replace([phone],' ','')
      ,[contact] =replace([contact],' ','')

删除空白行：

delete from bcd where companyname=''

查询处理后信息:

select * from bcd