sql語句語法規(guī)則 sqlserver數(shù)據(jù)庫查詢語句like語法怎么用？
sqlserver數(shù)據(jù)庫查詢語句like語法怎么用？/*created by SinooSoft.com at 2014-4-18*//*準(zhǔn)備測試數(shù)據(jù)*/SELECT "aaddbbcc" a int
sqlserver數(shù)據(jù)庫查詢語句like語法怎么用？
/*created by SinooSoft.com at 2014-4-18*//*準(zhǔn)備測試數(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 "%"