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
 General SQL Server Forums
 New to SQL Server Programming
 Find word in tables and return entire row?

Author  Topic 

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 2013-01-15 : 16:58:25
I have new requirement come in. it is little different. I have to search keyword (Which is either contains or exact) and search on tables and return entire row and store in a temp table.

I think need to build dynamic table which table has more columns in a row.

Gurus please help me out here.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-16 : 10:22:15
Red Gate has a search tool - which is free: http://www.red-gate.com/products/sql-development/sql-search/
Go to Top of Page

getur.srikanth@gmail.com
Yak Posting Veteran

77 Posts

Posted - 2013-01-16 : 11:07:17
quote:
Originally posted by James K

Red Gate has a search tool - which is free: http://www.red-gate.com/products/sql-development/sql-search/




How can I use this tool my code? I need to in my code and show on page.
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-16 : 11:47:50
You cannot; it is meant to be an interactive tool. If you want to do the searching in your script, you would need some other way. Found this blog, will that help you? http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-16 : 23:05:09
what do you mean by below?
I think need to build dynamic table which table has more columns in a row.

didnt get what you mean by more columns in a row?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -