比如说test数据库 有表 a1 ,a2 ....test1 有 数据库test2 有表 b1 ,b2 ,我现在想把 a1 表的结构和数据复制到 test2 中.要怎么做? INSERT INTO HOMEH.Dbo.MEMBER (memberid,code,property,memberlevel,name,spell,sex,idencard,post,address,province,city,telphone,mobile,email,password,integral,balance,regdate,checkstatus,checktime,status, manage,membercard SELECT memberid,code,property,memberlevel,name,spell,sex,idencard,post,address,province,city,telphone,mobile,email,password,integral,balance,regdate,checkstatus,checktime,status, manage,membercard FROM HOME.dbo.MEMBER