https://blog.youkuaiyun.com/sumirryzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/sumirry/article/details/80432949https://blog.youkuaiyun.com/sumirry/article/details/80432949sumirryThu, 24 May 2018 13:05:09 +0800https://blog.youkuaiyun.com/sumirry/article/details/80421683https://blog.youkuaiyun.com/sumirry/article/details/80421683sumirryWed, 23 May 2018 16:19:52 +0800https://blog.youkuaiyun.com/sumirry/article/details/51460908https://blog.youkuaiyun.com/sumirry/article/details/51460908sumirryFri, 20 May 2016 13:09:12 +0800https://blog.youkuaiyun.com/sumirry/article/details/51217788https://blog.youkuaiyun.com/sumirry/article/details/51217788sumirryFri, 22 Apr 2016 10:16:40 +0800https://blog.youkuaiyun.com/sumirry/article/details/48492721https://blog.youkuaiyun.com/sumirry/article/details/48492721sumirryWed, 16 Sep 2015 13:33:38 +0800 '' BEGIN If IsNumeric(@PCode) = 1 Set @SQL =@SQL+' And p.PCode like '''+@PCode+'%''' Else If Ascii(@PCode) > 64 Or Ascii(@PCode) < 123 Set @SQL =@SQL+' And p.PName like ''%]]>https://blog.youkuaiyun.com/sumirry/article/details/48466627https://blog.youkuaiyun.com/sumirry/article/details/48466627sumirryTue, 15 Sep 2015 13:58:21 +0800https://blog.youkuaiyun.com/sumirry/article/details/48261829https://blog.youkuaiyun.com/sumirry/article/details/48261829sumirryMon, 07 Sep 2015 10:08:56 +0800https://blog.youkuaiyun.com/sumirry/article/details/48025817https://blog.youkuaiyun.com/sumirry/article/details/48025817sumirryThu, 27 Aug 2015 12:23:43 +0800https://blog.youkuaiyun.com/sumirry/article/details/47986117https://blog.youkuaiyun.com/sumirry/article/details/47986117sumirryTue, 25 Aug 2015 23:00:39 +0800https://blog.youkuaiyun.com/sumirry/article/details/47985107https://blog.youkuaiyun.com/sumirry/article/details/47985107sumirryTue, 25 Aug 2015 22:51:57 +0800https://blog.youkuaiyun.com/sumirry/article/details/47984517https://blog.youkuaiyun.com/sumirry/article/details/47984517sumirryTue, 25 Aug 2015 21:59:09 +0800https://blog.youkuaiyun.com/sumirry/article/details/47975455https://blog.youkuaiyun.com/sumirry/article/details/47975455sumirryTue, 25 Aug 2015 13:14:45 +0800https://blog.youkuaiyun.com/sumirry/article/details/46746331https://blog.youkuaiyun.com/sumirry/article/details/46746331sumirryFri, 03 Jul 2015 22:05:28 +0800https://blog.youkuaiyun.com/sumirry/article/details/42490697https://blog.youkuaiyun.com/sumirry/article/details/42490697sumirryWed, 07 Jan 2015 12:51:56 +0800https://blog.youkuaiyun.com/sumirry/article/details/42078483https://blog.youkuaiyun.com/sumirry/article/details/42078483sumirryMon, 22 Dec 2014 12:39:07 +0800https://blog.youkuaiyun.com/sumirry/article/details/42078353https://blog.youkuaiyun.com/sumirry/article/details/42078353sumirryMon, 22 Dec 2014 12:12:34 +0800https://blog.youkuaiyun.com/sumirry/article/details/41623391https://blog.youkuaiyun.com/sumirry/article/details/41623391sumirrySun, 30 Nov 2014 15:49:08 +0800https://blog.youkuaiyun.com/sumirry/article/details/41594479https://blog.youkuaiyun.com/sumirry/article/details/41594479sumirrySat, 29 Nov 2014 11:53:34 +0800https://blog.youkuaiyun.com/sumirry/article/details/41594255https://blog.youkuaiyun.com/sumirry/article/details/41594255sumirrySat, 29 Nov 2014 11:29:40 +0800https://blog.youkuaiyun.com/sumirry/article/details/41593055https://blog.youkuaiyun.com/sumirry/article/details/41593055sumirrySat, 29 Nov 2014 09:17:56 +0800 1) --例二： select * from testtable where ]]>