我有一个最初用于oracle的查询,现在我正在将其转换为sql,并收到以下错误消息:
消息102,级别15,状态1,第1行“importing”附近语法不正确。
我还连接到另一个sql server。
开始导入数据
-- Import Realmast
USE TAXPAYER
DROP TABLE VISION_REALMAST1
SELECT *
INTO dbo.VISION_REALMAST
FROM [TOMSQLVISION].[VISION_2020].[REAL_PROP].[REALMAST]
--DROP THE PUBLIC EMPLOYEES
DELETE FROM dbo.VISION_REALMAST1
WHERE REM_INET_SUPPRESS = 1
-- Update the GIS ID field in realmast
UPDATE dbo.VISION_REALMAST1
SET REM_GIS_ID = CAST(CAST(REM_MBLU_MAP AS INT) AS VARCHAR(20)) +'-'+ CAST(CAST(REM_MBLU_BLOCK AS INT) AS VARCHAR(20))
暂无答案!
目前还没有任何答案,快来回答吧!