- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FunName]') and xtype in (N'FN', N'IF', N'TF'))
- drop function [dbo].[FunName]
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_NULLS ON
- GO
- ----函数 : FunName
- ----主要功能:返回一个数据集(Table)。
- ----运行实例:select * from dbo.FunName(2)
- CREATE FUNCTION FunName ( 参数列表)
- RETURNS @表变量名table (字段列表 )
- AS
- BEGIN
- -------这里插入数据
- INSERT INTO @表变量名
- SELECT * from TableName
- ------返回
- RETURN
- END
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS ON
- GO
Sql函数返回一个数据集(Table)
最新推荐文章于 2021-04-02 22:44:14 发布