當點擊查詢後相容所有條件 在進行多條件查詢時可以 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+'%')
