proceduredemo22.sql

T-SQL示例大全

/* 文件名称: ProcedureDemo22.sql */
DECLARE @RC int
DECLARE @EmployeeName nvarchar(10)
SELECT @EmployeeName = N'章立民'
EXEC @RC = 北风贸易.dbo.CheckName @EmployeeName
IF @RC = 1
    PRINT '存在'
ELSE
    PRINT '不存在'