create function fn_GetTypeid(@GID int)
returns varchar(500)
as
begin
declare @temp varchar(200)
set @temp=''
select @temp=@temp+cast(typeid as varchar(20))+',' from t_game_Type where GID=@GID
@tempif(@temp<>'')
begin
set @temp=left(@temp,len(@temp)-1)--截掉最末尾的","
end
return @temp
end
returns varchar(500)
as
begin
declare @temp varchar(200)
set @temp=''
select @temp=@temp+cast(typeid as varchar(20))+',' from t_game_Type where GID=@GID
@tempif(@temp<>'')
begin
set @temp=left(@temp,len(@temp)-1)--截掉最末尾的","
end
return @temp
end