How SQL SERVER 2008 queries a table that contains a keyword

Article from: Baidu know

/** Query whether all data in a database contains the specified string*/Declare @str varchar( -)Set @str='Dynamic Soft' --the string to search forDeclare @s varchar(8000)DeclareTbcursorLocal forSelectS='if exists (select 1 from ['+B.name+'] where convert (varchar,['+A.name+']) like"'%'+@str+'%"') Print"'Select Top 5 ['+A.name+'],* from ['+B.name+']" " fromSyscolumns AJoinSysobjects b ona.ID=b.idwhereB.xtype='U'  andA.status>=0--field type of the column being looked up  andA.xusertypeinch(175,239,231,167, About, -,108,106)OpenTBFetch Next  fromTb into @s while @ @fetch_status=0begin exec(@s) Fetch Next  fromTb into @sEndCloseTBdeallocateTb

How SQL SERVER 2008 queries a table that contains a keyword