22,209
社区成员
发帖
与我相关
我的任务
分享
select a.ctablecode
From hr_sys_setdict a, UFDATA_168_2019.dbo.hr_sys_setdict b
where a.ctablecode like 'hr_ct%'
and a.ctablecode = b.ctablecode
and a.ctablecode not in(select distinct name from sysobjects where name like 'hr_ct%' and xtype='V')
-- 确认数据库环境
select @@version
--> 返回Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)...
-- 打开master数据库
use master
-- 创建表master.dbo.hr_sys_setdict
create table hr_sys_setdict(ctablecode varchar(50))
-- 创建数据库UFDATA_168_2019
create database UFDATA_168_2019
-- 打开UFDATA_168_2019数据库
use UFDATA_168_2019
-- 创建表UFDATA_168_2019.dbo.hr_sys_setdict
create table hr_sys_setdict(ctablecode varchar(50))
-- 打开master数据库
use master
-- 执行查询
select hr_sys_setdict.ctablecode
From hr_sys_setdict, UFDATA_168_2019.dbo.hr_sys_setdict
where hr_sys_setdict.ctablecode like 'hr_ct%'
and hr_sys_setdict.ctablecode = UFDATA_168_2019.dbo.hr_sys_setdict.ctablecode
and hr_sys_setdict.ctablecode not in(select distinct name from sysobjects where name like 'hr_ct%' and xtype='V')
/*
Msg 1013, Level 16, State 1, Line 19
The objects "UFDATA_168_2019.dbo.hr_sys_setdict" and "hr_sys_setdict" in the FROM clause have the same exposed names.
Use correlation names to distinguish them.
*/
select hr_sys_setdict.ctablecode From hr_sys_setdict, UFDATA_168_2019.dbo.hr_sys_setdict where hr_sys_setdict.ctablecode like 'hr_ct%' and hr_sys_setdict.ctablecode = UFDATA_168_2019.dbo.hr_sys_setdict.ctablecode and hr_sys_setdict.ctablecode not in(select distinct name from sysobjects where name like 'hr_ct%' and xtype='V')