T-SQL - Sync Table

最新推荐文章于 2021-02-07 14:35:13 发布

xxdxxd

最新推荐文章于 2021-02-07 14:35:13 发布

阅读量188

点赞数 1

文章标签： SQL CMS

/* --1---Create table---- */

create table Sync_Table
([id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Table_Name] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_Sync_Table] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

/* --2---Insert data---- */

insert into Sync_Table ([Table_Name]) values ('CMS_Member')
select * from Sync_Table

/* --3---SP---- */

--exec sp_Sync_Table
create proc sp_Sync_Table
as
begin
declare @number_of_table int
select @number_of_table = count(*) from Sync_Table
print @number_of_table
declare @table_name [varchar](100)
declare @sql nvarchar (max)
declare @n int
set @n = 1
while @n