如何将sql查询结果（不止一项）插入到一张表中，我们一般可以用如下形式的sql
insert into table1
select field1,field2,... from table2
where ...
它要求对应的插入项类型必须一致。
另外，当select的查询结果是table1的所有字段的时候，可以省略table1的列字段，写成如下形式：
insert into table1(field1,field2,...)
select field1,field2,... from table2
where ...
在实际当中我们可能遇到 进行表单填报数据时,这时表单里面的值是变量
strSql.Append("insert into tny_surveyArea(");
strSql.Append("surveyAreaId,TaskID,biologyId,biologyType,generationId,wormAgeId,statusId,damageCodeId,occurArea,deadTreeCount,Remark,SurveyTypeId,SurveyDate,surveyUserID,inputUserId,CheckStatus,GPSCoor,IsCheckData,SmallFieldID,Geometry, Geometry_XLO, Geometry_YLO, Geometry_XHI, Geometry_YHI");
strSql.Append(")");
strSql.Append(" select ");
strSql.Append("'" + model.surveyAreaId + "',");
strSql.Append("" + model.TaskID + ",");
strSql.Append("'" + model.biologyId + "',");
strSql.Append("'" + model.biologyType + "',");
&nb
SQL Server Filtered Indexes - What They Are, How to Use and Performance Advantages
Written By: Arshad Ali -- 7/2/2009 -
Problem
SQL Server 2008 introduces Filtered Indexes which is an index with a WHERE clause. Doesn’t it sound awesome especially for a table that has huge amount of data and ......
