INSERT INTO DB_02.dbo.MF_POS
SELECT *
FROM DB_01.dbo.MF_POS
WHERE NOT EXISTS(
SELECT *
FROM DB_02.dbo.MF_POS
WHERE DB_02.dbo.MF_POS.OS_NO=DB_01.dbo.MF_POS.OS_NO) AND
DB_01.dbo.MF_POS.OS_ID='SO' and DB_01.MF_POS.OS_NO LIKE 'SOB9%'出现以下提示:服务器: 消息 107,级别 16,状态 2,行 1
列前缀 'DB_01.MF_POS_Z' 与查询中所用的表名或别名不匹配。如果去掉这个and DB_01.MF_POS.OS_NO LIKE 'SOB9%'条件就可以了,我不知道原因,请指点一下!
SELECT *
FROM DB_01.dbo.MF_POS
WHERE NOT EXISTS(
SELECT *
FROM DB_02.dbo.MF_POS
WHERE DB_02.dbo.MF_POS.OS_NO=DB_01.dbo.MF_POS.OS_NO) AND
DB_01.dbo.MF_POS.OS_ID='SO' and DB_01.MF_POS.OS_NO LIKE 'SOB9%'出现以下提示:服务器: 消息 107,级别 16,状态 2,行 1
列前缀 'DB_01.MF_POS_Z' 与查询中所用的表名或别名不匹配。如果去掉这个and DB_01.MF_POS.OS_NO LIKE 'SOB9%'条件就可以了,我不知道原因,请指点一下!
语法:数据库名.所有者.对象名
如果在sql语句中很多地方都需要这样使用,可以创建同义词。方便使用。如:CREATE SYNONYM pos1 for DB_01.dbo.MF_POS
go
CREATE SYNONYM pos2 for DB_02.dbo.MF_POS
goINSERT INTO pos2
SELECT * FROM pos1
WHERE NOT EXISTS(SELECT * FROM pos2 WHERE pos2.OS_NO=pos1.OS_NO)
AND pos1.OS_ID='SO' and pos1.OS_NO LIKE 'SOB9%'
语法:数据库名.所有者.对象名DB_01.MF_POS.OS_NO 少了个dbo
String or binary data would be truncated.
The statement has been terminated.这个是什么意思?