select * into test2 from... --并不是SQLSERVER中的建表,如要复制表,用create table .. as select... 可以用select xx into bb from...将某一字段值存入变量