回答編集履歴
1
推敲
test
CHANGED
|
@@ -38,9 +38,11 @@
|
|
|
38
38
|
|
|
39
39
|
select * from user
|
|
40
40
|
|
|
41
|
-
where gender = case @gender when 0 then '女' when 1 then '男'
|
|
41
|
+
where gender = case @gender when 0 then '女' when 1 then '男' end
|
|
42
42
|
|
|
43
43
|
0r (gender is null and @gender=2)
|
|
44
|
+
|
|
45
|
+
0r @gender=99
|
|
44
46
|
|
|
45
47
|
;
|
|
46
48
|
|