SELECT 'insert into CurrentDBName.dbo.'+NAME+' select * from dbName.dbo.'+name FROM sysobjects WHERE xtype='U' AND name !='userInfo'
SELECT 'insert into CurrentDBName.dbo.' + NAME + ' select * from dbName.dbo.' + name FROM sysobjects WHERE xtype = 'U' AND name != 'user'
1、你这个跟C#无关。 2、用SQLServer自带的导入导出工具,把非人员表的全部表导过去。
insert into A.dbo.TB1 select * from B.dbo.TB1 insert into A.dbo.TB2 select * from B.dbo.TB2 。 insert into A.dbo.TBN select * from B.dbo.TBN如果表特别多,可以动态生成这些语句 然后再执行。
SELECT 'insert into CurrentDBName.dbo.'+NAME+' select * from dbName.dbo.'+name FROM sysobjects WHERE xtype='U' AND name !='userInfo'
SELECT 'insert into CurrentDBName.dbo.' + NAME
+ ' select * from dbName.dbo.' + name
FROM sysobjects
WHERE xtype = 'U'
AND name != 'user'
2、用SQLServer自带的导入导出工具,把非人员表的全部表导过去。
insert into A.dbo.TB2 select * from B.dbo.TB2
。
insert into A.dbo.TBN select * from B.dbo.TBN如果表特别多,可以动态生成这些语句 然后再执行。