如果是在sql server中保存时提示 SET ANSI_NULLS 设置不正确之类的错误 则删除存储过程,然后在查询分析器中执行创建存储过程的语句来创建存储过程就行了.
是在sql server中保存時出現SET ANSI_NULLS之類的錯誤,我按你的方法在查詢分析器中可以建立存儲過程,但在.net中卻不能調用,望賜教.存儲過程代碼如下: CREATE PROCEDURE sp_Import ASbegin transaction delete from cst delete from sfc delete from itminsert into cst select T$PDNO,T$SITM from baan..BAAN.TTICST001110 insert into sfc select T$PDNO,T$MITM from baan..BAAN.TTISFC001110 insert into itm select T$ITEM,T$DSCA from baan..BAAN.TTIITM001110 commit transactionGOC#調用存儲過程的代碼如下: SqlConnection cn=new SqlConnection(Data.GetConnStr()); SqlCommand cmd=new SqlCommand("sp_Import",cn); cmd.CommandType=CommandType.StoredProcedure;cn.Open(); cmd.ExecuteNonQuery(); cn.Close();
錯誤提示如下: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dllAdditional information: System error.但如下代碼在查詢分析器中可以運行: delete from cst delete from sfc delete from itminsert into cst select T$PDNO,T$SITM from baan..BAAN.TTICST001110 insert into sfc select T$PDNO,T$MITM from baan..BAAN.TTISFC001110 insert into itm select T$ITEM,T$DSCA from baan..BAAN.TTIITM001110
--再试试看看是否因为字段名的原因导致CREATE PROCEDURE sp_Import ASbegin transaction delete from cst delete from sfc delete from itminsert into cst select [T$PDNO],[T$SITM] from baan..BAAN.TTICST001110 insert into sfc select [T$PDNO],[T$MITM] from baan..BAAN.TTISFC001110 insert into itm select [T$ITEM],[T$DSCA] from baan..BAAN.TTIITM001110 commit transactionGO
则删除存储过程,然后在查询分析器中执行创建存储过程的语句来创建存储过程就行了.
CREATE PROCEDURE sp_Import
ASbegin transaction
delete from cst
delete from sfc
delete from itminsert into cst select T$PDNO,T$SITM from baan..BAAN.TTICST001110
insert into sfc select T$PDNO,T$MITM from baan..BAAN.TTISFC001110
insert into itm select T$ITEM,T$DSCA from baan..BAAN.TTIITM001110
commit transactionGOC#調用存儲過程的代碼如下:
SqlConnection cn=new SqlConnection(Data.GetConnStr());
SqlCommand cmd=new SqlCommand("sp_Import",cn);
cmd.CommandType=CommandType.StoredProcedure;cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dllAdditional information: System error.但如下代碼在查詢分析器中可以運行:
delete from cst
delete from sfc
delete from itminsert into cst select T$PDNO,T$SITM from baan..BAAN.TTICST001110
insert into sfc select T$PDNO,T$MITM from baan..BAAN.TTISFC001110
insert into itm select T$ITEM,T$DSCA from baan..BAAN.TTIITM001110
ASbegin transaction
delete from cst
delete from sfc
delete from itminsert into cst select [T$PDNO],[T$SITM] from baan..BAAN.TTICST001110
insert into sfc select [T$PDNO],[T$MITM] from baan..BAAN.TTISFC001110
insert into itm select [T$ITEM],[T$DSCA] from baan..BAAN.TTIITM001110
commit transactionGO
在查询分析器中调用存储过程沒問題