SQL的插入

 1: INSERT INTO colum_name(s) Values (cloum_value)

2,SELECT colum_name(s) INTO newtable FROM oldname (将数据插入到newtable表中,newtable 会自动创建,如果数据库中已存在,则无法插入)

3,INSERT INTO @tablename colum_name(s) SELECT coum_name(s) FROM tablename

(@tablename 为定义的表变量,

如 DECLARE @tablename TABLE

(

colum_name type

)

表字段必须与 tablename一致

 )