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.
| Author |
Topic |
|
mahesh.vsp
Starting Member
5 Posts |
 Posted - 2006-09-11 : 03:20:49
|
| Hi pals, I need some help.i have some set of tables in my database called testdb and I have a srch data .I need to check in which table the data is contained. Can anybody help me how to do that. do i need to write a stored procedure for this whick loops all tables thru "select tname from tab" using a cursor or else is there any better way to do that. Can anyone plz suggest me.Thanks in advance, manu |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-11 : 03:28:14
|
| http://vyaskn.tripod.com/search_all_columns_in_all_tables.htmChirag |
 |
|
|
|
|
|
Advance Programming ..