SQL_创建表值函数
时间:2022-03-14 00:36
--创建表值函数 create function GetClassMember(@className nvarchar(50)) returns table as return(select * from Students where ClassName=@className) go --调用表值函数 select * from GetClassMember(‘高三一班‘)
时间:2022-03-14 00:36
--创建表值函数 create function GetClassMember(@className nvarchar(50)) returns table as return(select * from Students where ClassName=@className) go --调用表值函数 select * from GetClassMember(‘高三一班‘)