SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Search all collumns
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mike13
Posting Yak Master

Netherlands
214 Posts

Posted - 09/26/2007 :  09:48:46  Show Profile  Click to see mike13's MSN Messenger address  Reply with Quote
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

Sweden
30276 Posts

Posted - 09/26/2007 :  10:40:02  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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

Netherlands
214 Posts

Posted - 09/26/2007 :  10:58:56  Show Profile  Click to see mike13's MSN Messenger address  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000