请大家给我解释一下这个sql语句:
CREATE PROCEDURE test_selectAsCourse
@testCourse varchar(20)
AS
BEGIN
select testContent,testId,testAns1,testAns2,testAns3,testAns4,rightAns,
pub=case pub when '0' then '否' else '是' end
from test where testCourse=@testCourse
END
GO尤其是这句 select testContent,testId,testAns1,testAns2,testAns3,testAns4,rightAns,
pub=case pub when '0' then '否' else '是' end 谢谢!
CREATE PROCEDURE test_selectAsCourse
@testCourse varchar(20)
AS
BEGIN
select testContent,testId,testAns1,testAns2,testAns3,testAns4,rightAns,
pub=case pub when '0' then '否' else '是' end
from test where testCourse=@testCourse
END
GO尤其是这句 select testContent,testId,testAns1,testAns2,testAns3,testAns4,rightAns,
pub=case pub when '0' then '否' else '是' end 谢谢!
好处是,省得写:
if ...
select ...
else
select ...
case pub when '0' then '否' else '是' end AS pub