现在有两个表:
TDOA_WRSysTablesCREATE TABLE [dbo].[TDOA_WRSysTables](
[TableID] [nvarchar](50) NOT NULL,
[TableName] [nvarchar](50) NOT NULL,
[Description] [nvarchar](120) NULL,
[TableMemo] [text] NULL,
[TableGroup] [nvarchar](12) NULL,
[TableFlag] [char](1) NULL CONSTRAINT [DF_S_Tables_TableFlag] DEFAULT ('S'),
[Visible] [tinyint] NULL CONSTRAINT [DF_S_Tables_Visible] DEFAULT ((1)),
[VisibleIndex] [int] NULL,
[CreatedDate] [datetime] NULL,
[InitTableFlag] [int] NULL CONSTRAINT [DF_Sys_Tables_InitTableFlag] DEFAULT ((1)),
[Condition] [nvarchar](200) NULL,
CONSTRAINT [PK_S_Tables] PRIMARY KEY CLUSTERED
(
[TableName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]TDOA_WRSysTablesField
CREATE TABLE [dbo].[TDOA_WRSysTablesField](
[tableid] [nvarchar](50) NOT NULL,
[colid] [int] NOT NULL,
[FieldName] [nvarchar](50) NULL,
[Description] [nvarchar](120) NULL,
[FieldType] [nvarchar](50) NULL,
[Fieldlength] [int] NULL,
[AllowNull] [tinyint] NULL CONSTRAINT [DF_S_Tables1_AllowNull] DEFAULT ((1)),
[DefaultValue] [nvarchar](50) NULL,
[KeyField] [tinyint] NULL CONSTRAINT [DF_S_Tables1_KeyField] DEFAULT ((0)),
[FieldMemo] [text] NULL,
[Visible] [tinyint] NULL CONSTRAINT [DF_S_Tables1_Visible] DEFAULT ((1)),
[VisibleIndex] [int] NULL,
[FieldFlag] [char](1) NULL CONSTRAINT [DF_Table_1_TableFlag] DEFAULT ('S'),
[CreatedDate] [datetime] NULL,
CONSTRAINT [PK_S_Tables1] PRIMARY KEY CLUSTERED
(
[tableid] ASC,
[colid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
问题:
想通过这两个表中配置的信息,去查找数据库中对应的表的内容信息
库有可能不是一个(不确定),如:有可能用户表在EIS库中,用户对应的客户在Customer库中,
求一存储过程,或更好的方法 谢谢
TDOA_WRSysTablesCREATE TABLE [dbo].[TDOA_WRSysTables](
[TableID] [nvarchar](50) NOT NULL,
[TableName] [nvarchar](50) NOT NULL,
[Description] [nvarchar](120) NULL,
[TableMemo] [text] NULL,
[TableGroup] [nvarchar](12) NULL,
[TableFlag] [char](1) NULL CONSTRAINT [DF_S_Tables_TableFlag] DEFAULT ('S'),
[Visible] [tinyint] NULL CONSTRAINT [DF_S_Tables_Visible] DEFAULT ((1)),
[VisibleIndex] [int] NULL,
[CreatedDate] [datetime] NULL,
[InitTableFlag] [int] NULL CONSTRAINT [DF_Sys_Tables_InitTableFlag] DEFAULT ((1)),
[Condition] [nvarchar](200) NULL,
CONSTRAINT [PK_S_Tables] PRIMARY KEY CLUSTERED
(
[TableName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]TDOA_WRSysTablesField
CREATE TABLE [dbo].[TDOA_WRSysTablesField](
[tableid] [nvarchar](50) NOT NULL,
[colid] [int] NOT NULL,
[FieldName] [nvarchar](50) NULL,
[Description] [nvarchar](120) NULL,
[FieldType] [nvarchar](50) NULL,
[Fieldlength] [int] NULL,
[AllowNull] [tinyint] NULL CONSTRAINT [DF_S_Tables1_AllowNull] DEFAULT ((1)),
[DefaultValue] [nvarchar](50) NULL,
[KeyField] [tinyint] NULL CONSTRAINT [DF_S_Tables1_KeyField] DEFAULT ((0)),
[FieldMemo] [text] NULL,
[Visible] [tinyint] NULL CONSTRAINT [DF_S_Tables1_Visible] DEFAULT ((1)),
[VisibleIndex] [int] NULL,
[FieldFlag] [char](1) NULL CONSTRAINT [DF_Table_1_TableFlag] DEFAULT ('S'),
[CreatedDate] [datetime] NULL,
CONSTRAINT [PK_S_Tables1] PRIMARY KEY CLUSTERED
(
[tableid] ASC,
[colid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
问题:
想通过这两个表中配置的信息,去查找数据库中对应的表的内容信息
库有可能不是一个(不确定),如:有可能用户表在EIS库中,用户对应的客户在Customer库中,
求一存储过程,或更好的方法 谢谢
IF(OBJECT_ID('T1')) IS NOT NULL
DROP TABLE T1
CREATE TABLE T1
(
F_ID INT IDENTITY(1,1),
F_NAME VARCHAR(100)
)
INSERT INTO T1 (F_NAME)
SELECT TOP 10 NAME FROM SYSOBJECTS ORDER BY ID ASC
IF(OBJECT_ID('T2')) IS NOT NULL
DROP TABLE T2
CREATE TABLE T2
(
F_ID INT IDENTITY(1,1),
F_NAME VARCHAR(100)
)
INSERT INTO T2 (F_NAME)
SELECT TOP 10 NAME FROM SYSOBJECTS ORDER BY ID DESC IF (OBJECT_ID('TempDB..#T_TableOrder'))IS NOT NULL
DROP TABLE #T_TableOrder
SELECT * INTO #T_TableOrder FROM (
SELECT *,'DB1' AS F_Type FROM T1
UNION
SELECT *,'DB2' AS F_Type FROM T2
)A
ORDER BY F_Type SELECT * FROM #T_TableOrder WHERE NAME ='TableName'