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 2005 Forums
 Transact-SQL (2005)
 Search all collumns

Author  Topic 

mike13
Posting Yak Master

219 Posts

Posted - 2007-09-26 : 09:48:46
Hi all,

I found this example to search thru all collumns and tables.
But i want to search all cillumns of one table 'T_Customers'

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

how can i change this one to return the rows of that table?

thanks a lot,

Mike

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-26 : 10:40:02
By restricting the script to only get columns for table "t_customers".
I think what is very easy to do in the script above by putting a WHERE in the code.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

mike13
Posting Yak Master

219 Posts

Posted - 2007-09-26 : 10:58:56
hi,

Could you give me an example, i tried different thing but i didn't seem to get it to work.
Also this give as result collumn name and collumns content, i want to return the rows that have the searched word.

thanks,

Mike
Go to Top of Page
   

- Advertisement -