简单的问题 IF( @@rowcount = 0 ) 代表什么意思?? SET NOCOUNT ON 代表什么意思。。
代码如下。。
CREATE proc forums_Censorship_CreateUpdateDelete
(
@Word nvarchar(40)
, @DeleteWord bit = 0
, @Replacement nvarchar(40)
)
as
SET NOCOUNT ON
if( @DeleteWord > 0 )
BEGIN
DELETE FROM
forums_Censorship
WHERE
Word = @Word
RETURN
END
ELSE
BEGIN
UPDATE forums_Censorship SET
Replacement = @Replacement
WHERE
Word = @Word
IF( @@rowcount = 0 )
BEGIN
INSERT INTO forums_Censorship (
Word, Replacement
) VALUES (
@Word, @Replacement
)
END
END
GO