insert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping
怎么去除出现的重复数据!
YP_YPJX表里以前有数据!
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping
怎么去除出现的重复数据!
YP_YPJX表里以前有数据!
select distinct YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping SELECT DISTINCT * INOT #T FROM YP_YPJX DELETE YP_YPJX INSERT YP_YPJX SELECT * FROM #T
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1)
from yaoping k
where not exists(select * from YP_YPJX j where k.YPJX=j.MC and dbo.GETPYWB(k.YPDW,0)=j.pym
and dbo.GETPYWB(k.YPDW,1)=j.wbm
)
insert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping select distinct * from YP_UPJXinsert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping select distinct * from YP_UPJX
YP_YPJX (MC,pym,wbm)
select
YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1)
from
yaoping k
where
not exists
(select
*
from
YP_YPJX j
where
k.YPJX=j.MC
and
dbo.GETPYWB(k.YPDW,0)=j.pym
and
dbo.GETPYWB(k.YPDW,1)=j.wbm)
insert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping SELECT DISTINCT * INTO #T FROM YP_YPJX DELETE YP_YPJX INSERT YP_YPJX SELECT * FROM #T先查询出所有不重复的,再删除表,再插入
insert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping select distinct * into #tb from YP_UPJX
delete from YP_YPJX
insert into YP_YPJX
select * from #tb楼主要结果,看看来个
insert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1)
from yaoping k
where ypjx+dbo.GETPYWB(YPDW,0)+dbo.GETPYWB(YPDW,1) not in
(select MC+pym+wbm) from YP_YPJX
谢谢
消息 156,级别 15,状态 1,第 5 行
关键字 'from' 附近有语法错误。
谢谢
消息 156,级别 15,状态 1,第 5 行
关键字 'from' 附近有语法错误。
(SELECT 1 FROM YP(select YPJX ,dbo.GETPYWB(YPDW,0)AS B, dbo.GETPYWB(YPDW,1) AS C from yaoping )AS T WHERE
NOT EXISTS(SELECT 1 FROM YP_YPJX T WHERE T.MC=T1.YPJX AND T.PYM=T1.B AND T.WBM=T1.C))
BEGIN
insert YP_YPJX (MC,pym,wbm)
select YPJX ,dbo.GETPYWB(YPDW,0), dbo.GETPYWB(YPDW,1) from yaoping
END??这样试试,先判断一下如果存在那样的数据就插入
谢谢!
但是还是错误的!
消息 156,级别 15,状态 1,第 2 行
关键字 'select' 附近有语法错误。
消息 102,级别 15,状态 1,第 2 行
')' 附近有语法错误。
消息 102,级别 15,状态 1,第 3 行
')' 附近有语法错误。