游標(biāo)的使用 sqlserver數(shù)據(jù)庫(kù)查詢語(yǔ)句like語(yǔ)法怎么用？
sqlserver數(shù)據(jù)庫(kù)查詢語(yǔ)句like語(yǔ)法怎么用？/*created by SinooSoft.com at 2014-4-18*//*準(zhǔn)備測(cè)試數(shù)據(jù)*/SELECT "aaddbbcc" a int
sqlserver數(shù)據(jù)庫(kù)查詢語(yǔ)句like語(yǔ)法怎么用？
/*created by SinooSoft.com at 2014-4-18*//*準(zhǔn)備測(cè)試數(shù)據(jù)*/SELECT "aaddbbcc" a into #tUNION ALL SELECT "bbsss" /*使用變量進(jìn)行l(wèi)ike查詢*/DECLARE @strLike varchar(10)="aa"SELECT * from #t where a LIKE "%" @strLike "%"