Searching a String Value in all Columns of a Table This article expands on the solution from that original blog post and also examines several other interesting common scenarios. To search a string value in all columns in the table and in all tables in the database (unfortunately, this blog no longer works as the site domain not supported by the founder Jacob Sebastian anymore - this is a great pity as it was a site with a wealth Transact-SQL MSDN forum question Query Error - Schema Does Not Exist.Ī blog post existed for the first problem - searching all columns of a table for a string How The latter question was recently encountered in this One of the common questions in various SQL Server user forums is how to find information in all columns of the table or in all tables of the database for a particular column.
0 Comments
Leave a Reply. |