SELECt *FROM myTableWHERe URL = LEFt('mysyte.com/?id=2®ion=0&page=1', LEN(URL))或使用CHARINDEX http://msdn.microsoft.com/zh-
cn/library/aa258228(v=SQL.80).aspx

SELECt *FROM myTableWHERe URL = LEFt('mysyte.com/?id=2®ion=0&page=1', LEN(URL))或使用CHARINDEX http://msdn.microsoft.com/zh-
cn/library/aa258228(v=SQL.80).aspx