27,579
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('dbo.Fun_Test') IS NOT NULL DROP FUNCTION dbo.Fun_Test
GO
-- =============================================
-- Author: ye
-- Create date: 2018-09-28
-- Description:
-- =============================================
CREATE FUNCTION dbo.Fun_Test
(
@orderNo VARCHAR(50)
)
RETURNS TABLE
AS
RETURN
(
SELECT * FROM 表 AS a WHERE a.c NOT IN (
SELECT b.c FROM 表 AS b WHERE b.orderNo=@orderNo
)
)
GO
select * from 表 where c=322