udfdemo15.sql

来自「T-SQL示例大全」· SQL 代码 · 共 23 行

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

if exists (select * from dbo.sysobjects where id = object_id(N'TargetTable') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table TargetTable
GO

DECLARE @Today datetime
SET @Today = GETDATE()

-- 将用户自定义函数返回的数据表写入一个新的数据表中
SELECT * INTO TargetTable 
    FROM dbo.udf_EmployeeByDepartmentAge('资讯部',@Today,30,40)

-- 将用户自定义函数返回的数据表写入一个既存的数据表中
INSERT TargetTable 
    SELECT * FROM dbo.udf_EmployeeByDepartmentAge('生产制造部',@Today,40,50)
GO

SELECT * FROM TargetTable
GO