to 雨中风铃：寒，看清楚介绍，此语句是查询某关键词存在于此数据库的哪个表哪个列，所以用top 1 ，意思是只要存在就返回查询到了。

ALTER PROCEDURE searchname @sname varchar(10) As

BEGIN
CREATE TABLE #TableList(
tablename char(200),
colname char(200),
content char(200)
)
DECLARE @table varchar(200)
DECLARE @col varchar(200)

SET nocount on

DECLARE curTab scroll cursor for SELECT name FROM sysobjects WHERE xtype='u'

OPEN curTab

FETCH NEXT FROM curTab INTO @table

WHILE @@FETCH_STATUS=0
BEGIN
DECLARE curCol SCROLL CURSOR FOR SELECT name FROM syscolumns WHERE (xtype=175 or xtype=167 or xtype=231) and (id in (SELECT id FROM sysobjects WHERE name=@table))

OPEN curCol

FETCH NEXT FROM curCol INTO @col

WHILE @@FETCH_STATUS=0
BEGIN
EXECUTE('insert into #TableList select '''+@table+''','''+@col+''','+@col+' from '+@table+' where '+@col+' LIKE '''+@sname+'''')
FETCH NEXT FROM curCol INTO @col
END

CLOSE curCol

DEALLOCATE curCol

FETCH NEXT FROM curTab INTO @table

END

CLOSE curTab

DEALLOCATE curTab

SET NOCOUNT OFF

SELECT DISTINCT tablename as 表名,COLNAME AS 字段名 ,content as 内容 from #TableList

DROP TABLE #tablelist

END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO