create function getDevice( @typeid int )
returns varchar(50)
begin
declare @device varchar(50),@aa varchar(10)
select @aa=isnull(@aa,'')+Device from Temp1 where TypeID=@typeid
set @device=@aa
return @device
end
returns varchar(50)
begin
declare @device varchar(50),@aa varchar(10)
select @aa=isnull(@aa,'')+Device from Temp1 where TypeID=@typeid
set @device=@aa
return @device
end
returns varchar(500)
begin
declare @sql varchar (1000)
set @sql = ''
select @sql = @sql + ',' + isnull(Device,'') from Temp1 where TypeID = @typeid
set @sql = stuff(@sql,1,1,'')
return @sql
end
returns varchar(50)
begin
declare @device varchar(50),@aa varchar(10)
set @device=''
select @device=@device+device+',' from temp1 where typeid=@typeid
return left(@device,len(@device)-1)
end