proceduredemo21.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 19 行

/* 文件名称: ProcedureDemo21.sql */
USE 北风贸易
GO

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.CheckName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.CheckName
GO

CREATE PROCEDURE dbo.CheckName
 @EmployeeName nvarchar(10)
AS
IF (SELECT count(*) FROM 飞狐工作室 WHERE 姓名 = @EmployeeName) > 0
    RETURN 1
ELSE
    RETURN 2

GO