sql 增删改查

插入：insert into #dictdoc(DICTVALUE,DICTLIST) select distinct ColorName,ColorName from goodsattr where ColorName <> ''

 创建   create table #dictdoc ( 
                DICTID int,
               ORGID char(11),
               RFTYPE char(1),
               FDNAME varchar(20),
              DICTVALUE  nvarchar(200),
              DICTLIST nvarchar(200),
              REMARK nvarchar(256),
              DICTCODE varchar(10),
              MODULEID char(16)
        )

删除表：drop table #dictdoc 

更新  ：declare @m int,@n int
select @m=2423,@n=0
update #dictdoc 
  set dictid = @m,@m=@m+1,dictcode = @n,@n=@n+1,
  orgid = '00000000000',fdname = 'ColorName'

截取 ：select distinct substring(goodscode,2,1) from goodsdoc

跨表：update shanghaijm..goodsdoc set shanghaijm..goodsdoc.goodscode = b.goodscode
from goodsdoc b 
where shanghaijm..goodsdoc.goodsid = b.goodsid