--好吧~~~我幫你寫一個:create proc proc_diaryAccount
@departmentid nvarchar(50),
@pro_subjectid nvarchar(50),
as SELECT * From table1 WHERE DepartmentID=
CASE WHEN @departmentid IS NULL THEN DepartmentID ELSE @departmentid END
AND
pro_ SubjectID=CASE WHEN @pro_subjectid IS NULL THEN pro_ SubjectID
ELSE @pro_subjectid END
--你先看一下是否有錯。
@departmentid nvarchar(50),
@pro_subjectid nvarchar(50),
as SELECT * From table1 WHERE DepartmentID=
CASE WHEN @departmentid IS NULL THEN DepartmentID ELSE @departmentid END
AND
pro_ SubjectID=CASE WHEN @pro_subjectid IS NULL THEN pro_ SubjectID
ELSE @pro_subjectid END
--你先看一下是否有錯。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货