Shulou(Shulou.com)06/01 Report--

Declare @ cloumns varchar (40) declare @ tablename varchar (40) declare @ str varchar (40) declare @ counts intdeclare @ sql nvarchar (2000) declare MyCursor Cursor For Select a.name as Columns, b.name as TableName from syscolumns a dagger sysObjects bMagna c where a.id = b.idand b.type = 'U'and a.xtype=c.xtypeand c.name like'% char%'set @ str=' Zhang San 'Open MyCursorFetch next From MyCursor Into @ cloumns @ tablenameWhile (@ @ Fetch_Status = 0) Begin set @ sql='select @ tmp_counts=count (*) from'+ @ tablename+' where'+ @ cloumns+' =''+ @ str+ 'execute sp_executesql @ sql,N'@tmp_counts int out',@counts out if @ counts > 0 begin print' table name:'+ @ tablename+', field name is'+ @ cloumns endFetch next From MyCursor Into @ cloumns,@tablenameEndClose MyCursorDeallocate MyCursor

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.