CREATE FUNCTION aa (@storeid int) RETURNS TABLE AS RETURN ( select * from 表 ) GO select * from aa(55)这样?
谢谢回复。 是希望把 UDF 存储到 某表中, 就像table a:id name text param 1 udf1 select * from 表 int然后查询出结果后, 执行此 udf1, 就象执行你写的那个似的
id name text param 1 udf1 select * from 表 int 动态语句可以使用exec,放到表里,可以使用游标declare cursor_insert cursor for select text from 表 declare @i varchar(8000) open cursor_insert fetch cursor_insert into @i while @@fetch_status=0 begin exec(i) fetch cursor_insert into @i end close cursor_insert deallocate cursor_insert
应该是------------------ id name text param 1 udf1 select * from 表 int 动态语句可以使用exec,放到表里,可以使用游标declare cursor_insert cursor for select text from 表 declare @i varchar(8000) open cursor_insert fetch cursor_insert into @i while @@fetch_status=0 begin exec(@i) fetch cursor_insert into @i end close cursor_insert deallocate cursor_insert------------------------------ exec('select 字符串')
RETURNS TABLE
AS
RETURN
(
select * from 表
)
GO
select * from aa(55)这样?
1 udf1 select * from 表 int然后查询出结果后, 执行此 udf1, 就象执行你写的那个似的
1 udf1 select * from 表 int
动态语句可以使用exec,放到表里,可以使用游标declare cursor_insert cursor for select text from 表
declare @i varchar(8000)
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec(i)
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
id name text param
1 udf1 select * from 表 int
动态语句可以使用exec,放到表里,可以使用游标declare cursor_insert cursor for select text from 表
declare @i varchar(8000)
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec(@i)
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert------------------------------
exec('select 字符串')