前面加库句
例如
create table employee(
employeeid int ,
employeename nvarchar(50))数据库有 HumanResource同 Sale
向Sale 库有的employee 插入数据Insert into Sale.dbo.employee(employeeid,employeename)
select employeeid,employeename from HumanResource.dbo.Employee
例如
create table employee(
employeeid int ,
employeename nvarchar(50))数据库有 HumanResource同 Sale
向Sale 库有的employee 插入数据Insert into Sale.dbo.employee(employeeid,employeename)
select employeeid,employeename from HumanResource.dbo.Employee
例如
create table employee(
employeeid int ,
employeename nvarchar(50))数据库有 HumanResource同 Sale
向Sale 库有的employee 插入数据Insert into Sale.dbo.employee(employeeid,employeename)
select employeeid,employeename from HumanResource.dbo.Employee
查询数据库,得到结果集
结果集遍历
对每条数据,执行INSERT
在button的click事件中,先select,然后放到随便一个数组容器里
然后遍历,再insert就ok了