sql中l(wèi)ike的用法并舉例說明 sqlserver數(shù)據(jù)庫查詢語句like語法怎么用？
sqlserver數(shù)據(jù)庫查詢語句like語法怎么用？/*created by SinooSoft.com at 2014-4-18*//*準備測試數(shù)據(jù)*/SELECT "aaddbbcc" a int
sqlserver數(shù)據(jù)庫查詢語句like語法怎么用？
/*created by SinooSoft.com at 2014-4-18*//*準備測試數(shù)據(jù)*/SELECT "aaddbbcc" a into #tUNION ALL SELECT "bbsss" /*使用變量進行l(wèi)ike查詢*/DECLARE @strLike varchar(10)="aa"SELECT * from #t where a LIKE "%" @strLike "%"