62,075
社区成员
发帖
与我相关
我的任务
分享
if ((@paramTrainclass IS NULL) AND (@paramClass IS NULL))
create procedure Search
@paramTrainclass nvarchar(20),@paramClass nvarchar(20)
as
if ((@paramTrainclass IS NULL) AND (@paramClass IS NULL))
begin
SELECT Subject.[开课编号], Subject.[开课状态], Subject.[班级编号], Class.[班级性质], Subject.[培训种类], Subject.[上课时间], Subject.[地点], Subject.[费用], Subject.[网上报名] FROM Subject INNER JOIN Class ON Subject.[班级编号] = Class.[班级编号]
end
if ((@paramTrainclass IS NOT NULL) AND (@paramClass IS NULL))
begin
SELECT Subject.[开课编号], Subject.[开课状态], Subject.[班级编号], Class.[班级性质], Subject.[培训种类], Subject.[上课时间], Subject.[地点], Subject.[费用], Subject.[网上报名] FROM Subject INNER JOIN Class ON Subject.[班级编号] = Class.[班级编号] WHERE Subject.[培训种类] =@paramTrainclass
end
if ((@paramTrainclass IS NULL) AND (@paramClass IS NOT NULL))
begin
SELECT Subject.[开课编号], Subject.[开课状态], Subject.[班级编号], Class.[班级性质], Subject.[培训种类], Subject.[上课时间], Subject.[地点], Subject.[费用], Subject.[网上报名] FROM Subject INNER JOIN Class ON Subject.[班级编号] = Class.[班级编号] WHERE Class.[班级性质] =@paramClass
end
if ((@paramTrainclass IS NOT NULL) AND (@paramClass IS NOT NULL))
begin
SELECT Subject.[开课编号], Subject.[开课状态], Subject.[班级编号], Class.[班级性质], Subject.[培训种类], Subject.[上课时间], Subject.[地点], Subject.[费用], Subject.[网上报名] FROM Subject INNER JOIN Class ON Subject.[班级编号] = Class.[班级编号] WHERE (Subject.[培训种类] =@paramTrainclass) AND (Class.[班级性质] =@paramClass)
end
Response.Redirect("classView.aspx?Trainclass=" + dwnTrainclass.SelectedValue + "&Class=" + dwnClass.SelectedValue + "&ClassNo=" + txtClassNo.Text);
if ((@paramTrainclass IS NULL) AND (@paramClass IS NULL))
create procedure Getxxx
@id int
as
if(@id=1)
begin
select field1,field2 from table
end
else
begin
select field1,field2 from table where id=@id
end