@DBName VarChar(100) , @ColumnName VarChar(100) ) As Declare
@SQL VarChar(8000) Select
@SQL = ' Select A.Name TableName, B.Name ColumnName From [' +
@DBName + ']..sysobjects A , [' + @DBName + ']..syscolumns B Where A.ID = B.ID And B.Name Like ''%' + @ColumnName + '%'' And A.XType = ''U'' Order By A.Name , B.Name ' Exec (@SQL)
转载于:https://my.oschina.net/xuyuchends/blog/852111