Search - Joel Lipman .Com

1. Search a database for a value and count matching rows: / Databases /; ... -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid ...; Created on 05 November 2012
2. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT ...; Created on 26 October 2012
3. Search a database with SOUNDEX: / Databases /; ... -- Declare some variables to use DECLARE @SqlToExecute nvarchar(max); DECLARE @FullSqlToExecute VARCHAR(max); DECLARE @myCounter int; DECLARE @minStrLen int; DECLARE @maxStrLen int; -- Set ...; Created on 11 October 2012
4. Search a database for a string (MySQL, T-SQL): / Databases /; ... You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE ...; Created on 08 October 2012
5. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default ...; Created on 03 August 2012
6. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012