摘要： --like ....% 表示以....开头-- %.... 表示以....结尾 --left (a,b); 最左边开始，返回b个长度字符串 WHERE 1=1 AND ( @DepartmentId IS NULL OR DepartmentId IN ( SELECT id FROM mdDep 阅读全文

摘要： SELECT [Projname],[version],[state] FROM [dbo].[Goods] WHERE [Projname] = CASE WHEN @Projname IS NULL THEN [Projname] ELSE @Projname END或者 SELECT [Pro 阅读全文