110,545
社区成员
发帖
与我相关
我的任务
分享
private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, CommandType cmdType, string cmdText, IDataParameter[] cmdParms)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
if (cmdParms != null)
{
foreach (SqlParameter parameter in cmdParms)
{
if (parameter != null)
{
if (((parameter.Direction == ParameterDirection.InputOutput) || (parameter.Direction == ParameterDirection.Input)) && (parameter.Value == null))
{
parameter.Value = DBNull.Value;
}
cmd.Parameters.Add(parameter);
}
}
}
这样就能把String字符串里的sql语句一次性都执行玩INSERT INTO table1 (mc,zb_mc,xx_mc,leibie)
SELECT 'aa',NULL,NULL,1390 union
SELECT 'bb',NULL,NULL,1400 union
SELECT 'cc',NULL,NULL,1410 union
SELECT 'dd',NULL,NULL,1420 union
SELECT 'ee',NULL,NULL,1430 union
SELECT 'ff',NULL,NULL,1440
INSERT INTO table1 (mc,zb_mc,xx_mc,leibie)
SELECT('aa',NULL,NULL,1390)union
SELECT('bb',NULL,NULL,1400)union
SELECT('cc',NULL,NULL,1410)union
SELECT('dd',NULL,NULL,1420)union
SELECT('ee',NULL,NULL,1430)union
SELECT('ff',NULL,NULL,1440)
为什么执行这条语句的时候提示我多条错误:消息 102,级别 15,状态 1,第 2 行
',' 附近有语法错误。
declare @i int,@j int
set @i=1
while(@i<=6)
begin
insert into BillInfo(BillID,BID ,IWtime ,Storage)
values(cast(@j as varchar(20)),1,'2012-11-19',100)
end
set @i=@i+1
insert into U_Info values('aaa',20),('aaa',20)--sql 2005 因该支持这种方法的啊
insert into U_Info
select 'bbb',50
UNION ALL select 'ccc',60
UNION ALL select 'ccc',60