异常处理汇总-数据库系列 http://www.cnblogs.com/dunitian/p/4522990.html
后期会在博客首发更新：http://dnt.dkill.net/Article/Detail/313
错误如图，怎么执行都没有自己想要的效果（return掉了，还有个啥？？？！！！）
处理后：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
if exists(
select
*
from
sysobjects
where
name
=
'usp_AllPmsTest'
)
drop
proc usp_AllPmsTest
go
create
proc usp_AllPmsTest
@cityName nvarchar(30),
@id
int
output
as
begin
insert
into
ShopModelBak
values
(@cityName,1,1)
set
@id=@@identity
select
CPName,CName,SName,MType,MName,Mprice
from
ShopMenu
inner
join
ShopModel
on
ShopMenu.MShopId=ShopModel.SId
inner
join
View_CityData
on
ShopMenu.MCityId=CId
where
CName=@cityName
return
(
select
count
(1)
from
ShopMenu)
end
go
declare
@total
int
,@id
int
exec
@total=usp_AllPmsTest
'滨湖区'
,@id
output
select
@id Id,@total total
|
ADO.Net
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
var
pms =
new
SqlParameter[]
{
new
SqlParameter(
"@cityName"
,
"滨湖区"
),
new
SqlParameter(
"@id"
, SqlDbType.Int),
new
SqlParameter(
"@total"
, SqlDbType.Int)
};
pms[1].Direction = ParameterDirection.Output;
pms[2].Direction = ParameterDirection.ReturnValue;
var
list = SQLHelper.ExecuteReader<ShopMenu>(
"usp_AllPmsTest"
, CommandType.StoredProcedure, pms);
foreach
(
var
item
in
list)
{
Console.WriteLine(item.MName +
" "
+ item.MPrice);
}
Console.WriteLine(
"刚才插入的ID是：{0},总共{1}条数据"
, pms[1].Value, pms[2].Value);
|
相关文章：http://www.cnblogs.com/dunitian/p/5362528.html
本文转自毒逆天博客园博客，原文链接：http://www.cnblogs.com/dunitian/p/5363895.html，如需转载请自行联系原作者
![[MySQL]存储过程](https://ucc.alicdn.com/3mfxe2r26qbaq/developer-article1632621/20241101/f9e47d1cdc9947d492b09f397a02c7b6.jpeg?x-oss-process=image/resize,h_160,m_lfit)
![2024Mysql And Redis基础与进阶操作系列（9）作者——LJS[含MySQL存储过程之局部、系统变量、参数传递、流程控制-判断/case具体详步骤；注意点及常见报错问题所对应的解决方法]](https://ucc.alicdn.com/pic/developer-ecology/56pfyutwi4tv4_c53df19098d2427391fe36eeb35f84c8.png?x-oss-process=image/resize,h_160,m_lfit)