存储过程为
CREATE PROCEDURE dbo.gllr
@user varchar(50) ,
@name varchar(50),
@mima varchar(50),
@Dwb_dwm varchar(40),
@Dwxb_mc varchar(40),
@zhiwu varchar(40),
@jibie varchar(4),
@jinyong varchar(4)
as
set nocount on
begin
BEGIN TRANSACTION
if @user is null return
insert into Yhb (Yhb_user,Yhb_name,Yhb_pass,Yhb_dw,Yhb_dwmc,Yhb_zw,Yhb_jb,Yhb_sfdl) values (@user,@name,@mima,@Dwb_dwm,@Dwxb_mc,@zhiwu,@jibie,@jinyong)
IF @@error=0 begin
COMMIT TRANSACTION
return 1
end
ELSE
begin
ROLLBACK TRANSACTION
return 0
end
return
end
GO
asp调用时:
Set MyComm = Server.CreateObject("ADODB.Command")
'Set objRs = Server.CreateObject("ADODB.Recordset")
with MyComm
.ActiveConnection = conn
.CommandText = "denglu"
.CommandType = 4
.Prepared = true
.Parameters.append .CreateParameter("@user",200,1,50,user)
.Parameters.append .CreateParameter("@name",200,1,50,name)
.Parameters.append .CreateParameter("@mima",200,1,50,mima)
.Parameters.append .CreateParameter("@Dwb_dwm",200,1,40,Dwb_dwm)
.Parameters.append .CreateParameter("@Dwxb_mc",200,1,40,Dwxb_mc)
.Parameters.append .CreateParameter("@zhiwu",200,1,40,zhiwu)
.Parameters.append .CreateParameter("@jibie",16,1,4,jibie)
.Parameters.append .CreateParameter("@jinyong",16,1,4,jinyong)
.Parameters.Append .CreateParameter("return",2,4)
.Execute
end with
这里返回值怎么没有啊???其他的都对,但是MyComm(8)却始终为空??谢谢帮帮看看
CREATE PROCEDURE dbo.gllr
@user varchar(50) ,
@name varchar(50),
@mima varchar(50),
@Dwb_dwm varchar(40),
@Dwxb_mc varchar(40),
@zhiwu varchar(40),
@jibie varchar(4),
@jinyong varchar(4)
as
set nocount on
begin
BEGIN TRANSACTION
if @user is null return
insert into Yhb (Yhb_user,Yhb_name,Yhb_pass,Yhb_dw,Yhb_dwmc,Yhb_zw,Yhb_jb,Yhb_sfdl) values (@user,@name,@mima,@Dwb_dwm,@Dwxb_mc,@zhiwu,@jibie,@jinyong)
IF @@error=0 begin
COMMIT TRANSACTION
return 1
end
ELSE
begin
ROLLBACK TRANSACTION
return 0
end
return
end
GO
asp调用时:
Set MyComm = Server.CreateObject("ADODB.Command")
'Set objRs = Server.CreateObject("ADODB.Recordset")
with MyComm
.ActiveConnection = conn
.CommandText = "denglu"
.CommandType = 4
.Prepared = true
.Parameters.append .CreateParameter("@user",200,1,50,user)
.Parameters.append .CreateParameter("@name",200,1,50,name)
.Parameters.append .CreateParameter("@mima",200,1,50,mima)
.Parameters.append .CreateParameter("@Dwb_dwm",200,1,40,Dwb_dwm)
.Parameters.append .CreateParameter("@Dwxb_mc",200,1,40,Dwxb_mc)
.Parameters.append .CreateParameter("@zhiwu",200,1,40,zhiwu)
.Parameters.append .CreateParameter("@jibie",16,1,4,jibie)
.Parameters.append .CreateParameter("@jinyong",16,1,4,jinyong)
.Parameters.Append .CreateParameter("return",2,4)
.Execute
end with
这里返回值怎么没有啊???其他的都对,但是MyComm(8)却始终为空??谢谢帮帮看看
解决方案 »
- 求一SQL
- SQL新手查询问题
- 无法连接局域网内其它sqlserver服务器,总提示“找不到网络路径”
- 如何存储时间
- 在SQL2008R2上装了AdventureWorks2008R2_SR1,在数据库里还是找不到AdventureWorks2008R2,高人指点啊!!!
- 求查询表80%记录的sql语句
- 大家的數據庫都是怎麼自動被份的??
- 1 为什么存储过程安全?2 数据库放在外面买的空间里面,是不是对他们来说是透明的了
- 数据库存储过程中如何计算自定义表达式
- 请教一个很菜的问题回答后马上给分,在SQLSERVER表中插入图片字段使用那条语句,具体如何实现,是不要以前台应用程序实现(最好能用ASP举例)谢了
- 高手,在VF中有没有办法测到SQL有几个用户正在使用表?
- 如果读取存储过程和视图的代码?
.Parameters.append .CreateParameter("@name",200,1,50,name)
.Parameters.append .CreateParameter("@mima",200,1,50,mima)
.Parameters.append .CreateParameter("@Dwb_dwm",200,1,40,Dwb_dwm)
.Parameters.append .CreateParameter("@Dwxb_mc",200,1,40,Dwxb_mc)
.Parameters.append .CreateParameter("@zhiwu",200,1,40,zhiwu)
.Parameters.append .CreateParameter("@jibie",16,1,4,jibie)
.Parameters.append .CreateParameter("@jinyong",16,1,4,jinyong)
.CreateParameter("return",2,4)
4就代表您说的那个属性