sql7里面怎么样创建自定义的函数

[aierong]

sql7里面怎么样创建自定义的函数

[zjcxc]

没办法.

不支持,只支持存储过程.

如果你一定要的话,升级到sql 2000

[txlicenhe]

-- =============================================
-- Create table function (TF)
-- =============================================
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'<table_function_name, sysname, test_function>')
DROP FUNCTION <table_function_name, sysname, test_function>
GO

CREATE FUNCTION <table_function_name, sysname, test_function>
(<@param1, sysname, @p1> <data_type_for_param1, , int>,
<@param2, sysname, @p2> <data_type_for_param2, , char>)
RETURNS <@table_variable_name, sysname, @table_var> TABLE
(<column_1, sysname, c1> <data_type_for_column1, , int>,
<column_2, sysname, c2> <data_type_for_column2, , int>)
AS
BEGIN
INSERT <@table_variable_name, sysname, @table_var>
SELECT 1, 2
RETURN
END
GO

-- =============================================
-- Example to execute function
-- =============================================
SELECT * FROM <owner, , dbo>.<table_function_name, sysname, test_function>
(<value_for_@param1, , 1>,
<value_for_@param2, , 2>)
GO


eg:
Create function test(@code char(10))
returns table
As
Return select * from 表 where 字段1 = @code

[aierong]

我说的是7。0数据库啦

Create function test(@code char(10))
returns table
As
Return select * from 表 where 字段1 = @code

你的这段代码在7。0里面有问题啦，不可以用啦

[TodayZ]

用户自定义函数是SQL Server 2000 新增的数据库对象.

[aierong]

明白啦