34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE DATABASE DBTestBac
ON
(name=DBTestBac, filename='D:\DBTestBac.mdf')
use DBTestBac
create table
table1(col1 varchar(10),col2 varchar(10),col3 varchar(10),col4 varchar(10),col5 varchar(10))
insert into table1 select * from DBServer..table1
CREATE DATABASE DBTestBac
ON
(name=mydbroot, filename='D:\DBTestBac.mdf'
)
use DBTestBac
create table
table1(col1 varchar(10),col2 varchar(10),col3 varchar(10),col4 varchar(10),col5 varchar(10))
create database DBTestBac
go
use DBTestBac
select DBTest.dbo.table1 into table1 where 1<>1
select DBTest.dbo.table2 into table2 where 1<>1
...