function返回table代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 function返回table

作者:kunkun0921 / 发布于2015/1/26/ 689


	use testimony
	GO
	drop function fun_Report
	GO
	create function fun_Report(
	@policestationId varchar(50)
	)
	returns @tab table(
	id int,
	name varchar(50),
	usertype varchar(50),
	policestationcode varchar(50),
	policestationname varchar(50),
	islocked varchar(50),
	isdeleted varchar(50)
	)
	as
	begin
	insert into @tab(id,name,usertype,policestationcode,policestationname,islocked,isdeleted)
	select row_number() over(order by u.id) id,u.name,ut.name usertype,p.code policestationcode,p.name policestationname,
	case u.stateCode when 0 then '正常' else '已锁定' end islocked,
	case u.is_deleted when 0 then '正常' else '已删除' end isdeleted
	from dbo.users u
	left join dbo.police_stations p on u.police_station_id=p.id
	left join dbo.dm_usertype ut on u.usertype=ut.code
	where 1=1 and p.code=@policestationId
	
	return;
	end
	Go

	
	--调用

	select * from dbo.fun_Report('330903050000')

试试其它关键字

　返回table　

同语言下

可能有用的

kunkun0921贡献的其它代码(40)