向如下表结构中插入两数字会报错吗?
表结构:table(FInterID,FEntryID)为主键,
FInterID FEntryID FQty插入数据:
Insert Into table(FInterID,FEntryID,FQty)
Select 111,1,90
union
Select 111,2,87
这样有问题吗?
表结构:table(FInterID,FEntryID)为主键,
FInterID FEntryID FQty插入数据:
Insert Into table(FInterID,FEntryID,FQty)
Select 111,1,90
union
Select 111,2,87
这样有问题吗?
Select * Into #tmp
From ADelete From B
Insert Into B
Select * From #tmpDrop table #tmp
报错,搞不懂
select * from
(
select FInterID,FEntryID,counts=count(1) from #tmp
group by FInterID,FEntryID
) tb
where tb.counts>1