|
jimf
Flowing Fount of Yak Knowledge
USA
2865 Posts |
 Posted - 12/27/2012 : 07:18:56
|
You can do something like this
select
'IF EXISTS (SELECT *
FROM T_SS_BSYRRVP
WHERE [' + COLUMN_NAME + '] = 2027171
)
SELECT ''' + REPLACE('[!]','!',COLUMN_NAME) +'''' +char(10)
from information_schema.columns dbs
where data_type like '%int%'
It will generate the code that you can then run in a query window.
Jim
Everyday I learn something that somebody else already knew |
 |
|
How to check in any field within this table this v
