关于Function的创建问题

史前大暴龙发布于 2007-08-20 18:14， 630 次点击

create function GetDiveTripIDsByMemberName
(
@memberName nvarchar(50)='',
@TopNum int=-1
)
returns table
as
begin
if @TopNum =-1
select ID,Describe from T_SBSTrips where username=@memberName order by CreateDate
else
declare @sql nvarchar(4000)
set @sql='select top '+cast(@TopNum as nvarchar(8))+' ID,Describe from T_SBSTrips where username='
+@memberName+' order by CreateDate'
exec (@sql)
end
return
end
我这样子创建系统提示我的出问题了,谁知道这个要怎么改啊??谢谢了

3 回复

西风独自凉2007-08-21 09:29

出现什么问题。提示个什么样的错误。。说清楚点才好解决问题

Kendy1234562007-08-23 10:20

create function GetDiveTripIDsByMemberName
(
@memberName nvarchar(50)='',
@TopNum int=-1
)
returns @OutPut table
(
ID int ,
Describe varchar(100)
)

as

begin
if @TopNum =-1
insert into @Output
select ID,Describe from T_SBSTrips where username=@memberName order by CreateDate
else
insert into @Output
select top @TopNum ID,Describe from T_SBSTrips where username = @memberName order by CreateDate
end
return
end

gugu07922007-08-23 14:58

CreateDate' 觉得那个单引号不该用