通过插入查询在存储过程中添加计数. [英] adding count in stored procedure with the insert query.
问题描述
我想修改以下存储过程以在其中添加计数查询..
我想添加计数查询.检查是否退出用户...
这是查询..
i want to amend the following stored procedure to add the count query in it..
i want to add count query . to check wheather the user exits or not...
here is the query..
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[insertUser]
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(150),
@Mobile varchar(50)
AS
BEGIN
INSERT INTO users(UserName,Password,FirstName,LastName,Email,MobileNo)VALUES (@UserName,@Password,@FirstName,@LastName,@Email,@Mobile)
END
我想添加计数查询likne belo ..如何修改以上查询以在其中添加休假查询...
i want to add count query likne belo.. how can i amend the above query to add the fallowing query in it...
string querycount= "Select Count(*) FROM users where username=@username
的用户
如果count为零,则执行插入查询.
以及如果用户退出,我想显示用户已经在我的asp应用标签控件中的记录上退出.
if count is zero than executing the insert query.
and also if user exits i want to show that user already exits on the record in my asp applcation label control.
推荐答案
尝试以下操作:
Try this one:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[insertUser]
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(150),
@Mobile varchar(50),
@Result varchar(100) output
AS
BEGIN
IF((SELECT COUNT(*) FROM users WHERE UserName = @UserName) > 0)
SET @Result = ''User already exists''
ELSE
BEGIN
INSERT INTO users(UserName,Password,FirstName,LastName,Email,MobileNo)VALUES (@UserName,@Password,@FirstName,@LastName,@Email,@Mobile)
SET @Result = ''User successfully added.
END
END
如果您还有其他问题,请告诉我.
如果这解决了您的问题,请标记为答案
最好的问候,
爱德华(Eduard)
Let me know if you have other concerns.
Please mark as answer if this solved your problem
Best regards,
Eduard
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[insertUser]
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(150),
@Mobile varchar(50),
@Result varchar(100) output
AS
BEGIN
Declare @Count int
SELECT @Count = COUNT(UserName) FROM users WHERE UserName = @UserName
if (@Count = 0)
begin
INSERT INTO users(UserName,Password,FirstName,LastName,Email,MobileNo)VALUES (@UserName,@Password,@FirstName,@LastName,@Email,@Mobile)
set @Result ='User Added successfully'
end
else
set @Result = 'User Already Exists'
END
如果这解决了您的问题,请标记为答案
Please mark as answer if this solved your problem
这篇关于通过插入查询在存储过程中添加计数.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!