放哨De老鼠

摘要： 简单点的直接返回查询的table对象CREATE FUNCTION Fun_GetReportNews(@type varchar(10)) RETURNS TABLE AS RETURN ( SELECT message,tablenames from tb_error WHERE tablenames = @type )调用：SELECT * FROM dbo.Fun_GetReportNews('')复杂点的 先创建一张临时表再返回表对象CREATE FUNCTION FUN_GetInfoList(@type varchar(10)) RETURNS @Table TA 阅读全文

摘要： declare @test table(id int,name varchar(100))insert into @test(id,name)select ID,LastName from tb_OrderUserInfo where DATEDIFF(M,InTime,GETDATE())<3select * from @test 阅读全文