类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
CREATE procedure p_public_Djcz
@_strJgbh as varchar(30),
@_strMxsjb as varchar(30),
@_strDjbhzd as varchar(30),
@_strMxbhzd as varchar(30),
@_strBcslzd as varchar(1000),
@_strMx as varchar(8000)
as
begin
DECLARE @hdoc as int
EXEC sp_xml_preparedocument @hdoc OUTPUT,@_strMx
exec(update +@_strMxsjb+ set +@_strBcslzd+ = bcsl where +@_strDjbhzd+=djbh and +@_strMxbhzd+ = mxbh select bcsl,djbh,mxbh
from openxml(+@hdoc+,/ROOT/ROW,1) with (bcsl varchar(50),djbh varchar(50),mxbh varchar(50)))
exec sp_xml_removedocument @hdoc
end
GO
错误提示：java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]第 2 行: 3 附近有语法错误。
网友回答：