create procedure HX_TEST
@unit_id varchar(20)
as
delete from HXBase_DrugUnit where unit_id= '' + @unit_id + ''
select msgno='0000',msg='测试成功!'
go
@unit_id varchar(20)
as
delete from HXBase_DrugUnit where unit_id= '' + @unit_id + ''
select msgno='0000',msg='测试成功!'
go
exec huaxi_test '1'
只是在查询分析器中显示而已,并不会返回参数的.
必须在存储过程中设置: @msgNo int OUTPUT,@Msg nVarchar Output
并且调用时,须用Cmd加参数传送,Cmd.execute 后,再取Cmd的参数才行