Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 updating all cols in all tables ...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-13 : 08:50:55
Paul writes "how can i search all cols in all tbls and then update that col to a specific value? thanks so much"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-13 : 08:58:10
See if this helps
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-13 : 09:00:43
R u refering to Column Names or Column Data ?
Madhi's suggestion is to search for some data in all columns.
If u want to find the column names, then the way is different.
Give some more info.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-01-13 : 09:41:37
Paul, Please elaborate what you need. Post some sample data if possible.

-----------------
'KH'

if you can't beat them, have someone else to beat them
Go to Top of Page
   

- Advertisement -