IF EXISTS (SELECT *
FROM sysobjects
WHERE name = 'data') BEGIN INSERT data
SELECT *
FROM data1
id
WHERE NOT EXISTS
(SELECT *
FROM promove
WHERE id = id.xm) END
FROM sysobjects
WHERE name = 'data') BEGIN INSERT data
SELECT *
FROM data1
id
WHERE NOT EXISTS
(SELECT *
FROM promove
WHERE id = id.xm) END
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = 'data1') BEGIN INSERT data1
SELECT *
FROM data
XM
WHERE NOT EXISTS
(SELECT *
FROM DATA1
WHERE XM = XM.xm) END
MS SQL server 一定要写代码才能完成这种操作吗?删除一条记录也写代码?
"使用复制技术啊 第一次做好以后你都不用弄了 以后都会自动复制啊"这样做如果我不要的数据,没有经过我验证不是就也发上去了.这样达不到我检查数据啊.
FROM sysobjects
WHERE name = 'data1') BEGIN INSERT data1
SELECT *
FROM data
A
WHERE NOT EXISTS
(SELECT *
FROM DATA1
WHERE A = A.xm) END
删一条记录都得用到代码,哎~烦,用ACCESS升到SQL看来也蛮难的...没有一定时间学还不是一下能成的.