定义一个函数实现如下功能:对于一个给定的DepartmentID值,查询该值在Departments表中是否存在,若存在则返回0,不存在返回-1。并写一段T-SQL程序调用此函数。
(如果不在函数前加dbo. 会报错)
use YGGL_DC03
go
CREATE FUNCTION CHECK_ID(@departmentid char(3)) RETURNS integer AS BEGIN
DECLARE @num int
IF EXISTS(SELECT DepartmentID FROM Departments_DC03 WHERE DepartmentID=departmentID) SELECT @num=0 ELSE
SELECT @num=-1 RETURN @num END
USE YGGL_DC03
GO
DECLARE @num int
SELECT @num=dbo.CHECK_ID(‘2’)IF @num=0
print ‘该员工信息存在的’
else
print ‘该员工信息存在’