sql_find_data
Search a table for any value across all or selected columns when you know data exists but not where. Specify a table and value to locate matching records across varchar, nvarchar, and int columns.
Instructions
Search for a value across all (or specific) columns in a table. Useful when you know a value exists but don't know which column it's in.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table to search in (e.g. 'Orders' or 'dbo.Orders') | |
| value | Yes | Value to search for (will search as text across all varchar/nvarchar/int columns) |