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)
 Specify a row has value when dont know data field

Author  Topic 

cijam
Starting Member

1 Post

Posted - 2009-12-23 : 01:13:52
I'm in a situation, i have to specify a row which has a data field is equal ( or like ) a specified value. Simply, I want to find a cell in a data table , and i just know the value of that cell.

Another situation is i have a database which contains many table, i just know about of a data field of a row in a table ( i don't know which table, row or field is exactly) , i just know the value. How can i specify which table, row, field that contains that value.

Any suggestion, please help me !
I'm new in this forum and i hope you can know what i mean exactly.
Thanks!

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-12-23 : 11:36:06
try this

http://it.toolbox.com/wiki/index.php/Get_Records_from_ANY_table_in_a_Database_Matching_Specified_Value

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -