存储过程多条件查询
程序员文章站
2023-01-28 20:18:49
当点击查询后兼容所有条件 在进行多条件查询时可以 CREATE PROC Getcourse AS @Condition SELECT * FROM course WHERE (c# LIKE'%'+@Condition+'%' OR cname LIKE'%'+@Condition+'%' OR ......
当点击查询后兼容所有条件
在进行多条件查询时可以
CREATE PROC Getcourse
AS
@Condition
SELECT * FROM course
WHERE (c# LIKE'%'+@Condition+'%' OR cname LIKE'%'+@Condition+'%' OR t# LIKE'%'+@Condition+'%')