DeptName like '%'+@DeptName+'% 为什么要加 like 和% 以及+if @DeptID='' and @DeptName'' --01beginselect * from Department where DeptName like '%'+@DeptName+'%
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/19 23:40:44
![DeptName like '%'+@DeptName+'% 为什么要加 like 和% 以及+if @DeptID='' and @DeptName'' --01beginselect * from Department where DeptName like '%'+@DeptName+'%](/uploads/image/z/12809109-21-9.jpg?t=DeptName+like+%27%25%27%2B%40DeptName%2B%27%25+%E4%B8%BA%E4%BB%80%E4%B9%88%E8%A6%81%E5%8A%A0+like+%E5%92%8C%25+%E4%BB%A5%E5%8F%8A%2Bif+%40DeptID%3D%27%27+and+%40DeptName%27%27+--01beginselect+%2A+from+Department+where+DeptName+like+%27%25%27%2B%40DeptName%2B%27%25)
xՔn@_e/BB!=C.ന@) D8BԠv I!JƀaWUSo?DhCI_J1E#o$
#
[=Wq7$wȇ<|H1l!bc]y<^YyꗕWxJ*im%(d:k%SѠߴ\ƑqܾD(
?c;IN5Tjñ]*.q`b)ڃpGkw?34)M~
LNa~\C3$Heci6RJ+5ףf;ӹ86wGZa
YqaGU2yXtlg'[мQMZc[L&(SR@SU[9vlb4IoVA Lyq)CX*w+