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 |
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 |
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
|
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 |
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|