CREATE PROCEDURE [dbo].[P_AddUserTask]
(
@award int,
@userId int,
@state int output
)
AS
declare @result int
set @result=(select count(1) from PwdProtection where userId=@userId)
if @result=1
then
set @state=@result
else
@result=0
end
SET NOCOUNT ON;
GO我这个应该怎么写哇?? 求教 求教
(
@award int,
@userId int,
@state int output
)
AS
declare @result int
set @result=(select count(1) from PwdProtection where userId=@userId)
if @result=1
then
set @state=@result
else
@result=0
end
SET NOCOUNT ON;
GO我这个应该怎么写哇?? 求教 求教
解决方案 »
- 在书上看到这么一段关于Oracle的Having子句的解释
- 请问string DateStr = "Data Source=mrwxk\\mrwxk;Database=master;User id=sa;PWD="数据源
- 有一句需要大家给予解释一下
- 简单SQL问题....下班结贴.速度~~~~~~~~~~~~
- 继续上午的结帖问题:“sql2000查询分析器里运行此条语句出错,到底是哪错的泥? ”
- 如何转换时间格式???急!!!
- 合并复制出现的问题
- ODBC 驱动程序不支持所需的属性???
- 请问这样的算法在sql里怎么实现?
- 请问数据库高手,这是那种类型的数据库文件?
- 关于SQL字符串创建临时表的问题
- 关于SQL Server2000安装问题,急求解决
(
@award int,
@userId int,
@state int output
)
AS
declare @result int
set @result=(select count(1) from PwdProtection where userId=@userId)
if @result=1
set @state=@result
else
set @result=0
GO?
CREATE PROCEDURE [dbo].[P_AddUserTask]
(
@award int,
@userId int,
@state int output
)
AS
SET NOCOUNT ON
declare @result int
select @result = count(1) from PwdProtection where userId=@userId
if @result=1
then
set @state=@result
else
@result=0
end
SET NOCOUNT OFF
GO