存储过程结果比较 [英] stored procedure result comparision
问题描述
我有以下SP:
CREATE PROCEDURE prSVUSERINFO
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@NAME VARCHAR(64),
@ ADDR VARCHAR(74),
@EML VARCHAR(64),
@ROLE VARCHAR(6),
@RCOUNT INT OUTPUT
AS
IF不存在(选择*来自BLEK.USERS A A.EREERNAME=@USRNAM或
A.USEREMAIL=@EML)
BEGIN
INSERT INTO
ESTATE.BLEK.USERS(用户名,UserPass,RealName,UserA ddr,UserEmail,UserRole)
VALUES(@ USRNAM,@ USRPSW,@ NAME,@ ADDR ,@ EML,@ ROLE)
END
ELSE
返回选择@RCOUNT = @@ ROWCOUNT
我可以在ASP.NET / C#中以某种方式使用@RCOUNT来查看用户名
是否已被使用?
谢谢!
---
外发邮件经过无病毒认证。
由AVG反病毒系统检查( http://www.grisoft.com)。
版本:6.0.721 /病毒库:477 - 发布日期:16.7.2004 a。
是的,你应该能够得到参数(@ Ident)。值
那是'不是确切的语法,但应该让你关闭。
-
Curt Christianson
所有者/首席开发人员,DF-软件
网站: http://www.Darkfalz.com
博客: http://blog.Darkfalz.com >
" Viktor Popov" < 6 **** @ yahoo.com>在消息中写道
新闻:eH ************* @ TK2MSFTNGP10.phx.gbl ...
我有以下SP:
CREATE PROCEDURE prSVUSERINFO
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@NAME VARCHAR(64),
@ADDR VARCHAR(74),
@EML VARCHAR(64),
@ROLE VARCHAR(6),
@RCOUNT INT OUTPUT
AS
如果不存在(选择*来自BLEK.USERS一个地方A.USERNAME=@USRNAM或
A.USEREMAIL=@EML)
开始
INSERT INTO
ESTATE.BLEK.USERS(用户名,UserPass ,RealName,UserA ddr,UserEmail,UserRole)
VALUES(@ USRNAM,@ USRPSW,@ NAME,@ ADDR,@ EML,@ ROLE)
END
ELSE
返回选择@RCOUNT = @@ ROWCOUNT
我可以在ASP.NET / C#中以某种方式使用@RCOUNT来查看
用户名是否已被使用?
>谢谢!
---
发送邮件经过无病毒认证。
由AVG反病毒系统检查( http://www.grisoft.com)。
版本:6.0.721 /病毒数据库:477 - 发布日期:16.7.2004 a。
感谢您的回复!
这是我的if语句
if(sqlAdapter) .SelectCommand.Parameters [" @ RCOUNT"]。值== 0),但是
是一个错误:
运算符''==' '不能应用于对象类型''对象''的操作数'
和''int''。
我知道我很接近但是.....
你能在这里帮忙吗?
谢谢!
---
外发邮件经过无病毒认证。
由AVG反病毒系统检查( http://www.grisoft.com)。
版本:6.0.721 /病毒库:477 - 发布日期:16.7.2004 a。
在SqlCommand(或其他数据库的类似类)中设置ap arameter
属性Direction设置为ReturnValue。
Eliyahu
" Viktor Popov" < 6 **** @ yahoo.com>在消息中写道
新闻:eH ************* @ TK2MSFTNGP10.phx.gbl ...
我有以下SP:
CREATE PROCEDURE prSVUSERINFO
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@NAME VARCHAR(64),
@ADDR VARCHAR(74),
@EML VARCHAR(64),
@ROLE VARCHAR(6),
@RCOUNT INT OUTPUT
AS
如果不存在(选择*来自BLEK.USERS一个地方A.USERNAME=@USRNAM或
A.USEREMAIL=@EML)
开始
INSERT INTO
ESTATE.BLEK.USERS(用户名,UserPass ,RealName,UserA ddr,UserEmail,UserRole)
VALUES(@ USRNAM,@ USRPSW,@ NAME,@ ADDR,@ EML,@ ROLE)
END
ELSE
返回选择@RCOUNT = @@ ROWCOUNT
我可以在ASP.NET / C#中以某种方式使用@RCOUNT来查看
用户名是否已被使用?
>谢谢!
---
发送邮件经过无病毒认证。
由AVG反病毒系统检查( http://www.grisoft.com)。
版本:6.0.721 /病毒数据库:477 - 发布日期:16.7.2004 a。
Hi ,
I have the following SP:
CREATE PROCEDURE prSVUSERINFO
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@NAME VARCHAR(64),
@ADDR VARCHAR(74),
@EML VARCHAR(64),
@ROLE VARCHAR(6),
@RCOUNT INT OUTPUT
AS
IF NOT EXISTS( SELECT * FROM BLEK.USERS A WHERE A.USERNAME=@USRNAM OR
A.USEREMAIL=@EML)
BEGIN
INSERT INTO
ESTATE.BLEK.USERS(Username,UserPass,RealName,UserA ddr,UserEmail,UserRole)
VALUES(@USRNAM,@USRPSW,@NAME,@ADDR,@EML,@ROLE)
END
ELSE
RETURN SELECT @RCOUNT=@@ROWCOUNT
Could I use somehow @RCOUNT in ASP.NET/C# to find out if the username
is already in use or not?
Thank you!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
yes, you should be able to get the paramaters("@Ident").value
that''s not exact syntax but should get you close.
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eH*************@TK2MSFTNGP10.phx.gbl...Hi ,
I have the following SP:
CREATE PROCEDURE prSVUSERINFO
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@NAME VARCHAR(64),
@ADDR VARCHAR(74),
@EML VARCHAR(64),
@ROLE VARCHAR(6),
@RCOUNT INT OUTPUT
AS
IF NOT EXISTS( SELECT * FROM BLEK.USERS A WHERE A.USERNAME=@USRNAM OR
A.USEREMAIL=@EML)
BEGIN
INSERT INTO
ESTATE.BLEK.USERS(Username,UserPass,RealName,UserA ddr,UserEmail,UserRole)
VALUES(@USRNAM,@USRPSW,@NAME,@ADDR,@EML,@ROLE)
END
ELSE
RETURN SELECT @RCOUNT=@@ROWCOUNT
Could I use somehow @RCOUNT in ASP.NET/C# to find out if the username is already in use or not?
Thank you!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
Thanks for the reply!
This is my if statement
if(sqlAdapter.SelectCommand.Parameters["@RCOUNT"].Value == 0) , but there
is an error:
Operator ''=='' cannot be applied to operands of type object type ''object''
and ''int''.
I know that I''m close but.....
Could you help here?
Thanks!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
In SqlCommand (or similar class for other databases) setup a parameter with
property Direction set to ReturnValue.
Eliyahu
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:eH*************@TK2MSFTNGP10.phx.gbl...Hi ,
I have the following SP:
CREATE PROCEDURE prSVUSERINFO
@USRNAM VARCHAR(20),
@USRPSW VARCHAR(20),
@NAME VARCHAR(64),
@ADDR VARCHAR(74),
@EML VARCHAR(64),
@ROLE VARCHAR(6),
@RCOUNT INT OUTPUT
AS
IF NOT EXISTS( SELECT * FROM BLEK.USERS A WHERE A.USERNAME=@USRNAM OR
A.USEREMAIL=@EML)
BEGIN
INSERT INTO
ESTATE.BLEK.USERS(Username,UserPass,RealName,UserA ddr,UserEmail,UserRole)
VALUES(@USRNAM,@USRPSW,@NAME,@ADDR,@EML,@ROLE)
END
ELSE
RETURN SELECT @RCOUNT=@@ROWCOUNT
Could I use somehow @RCOUNT in ASP.NET/C# to find out if the username is already in use or not?
Thank you!
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
这篇关于存储过程结果比较的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!