Search - Joel Lipman .Com

1. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... respective database tables are prefixed with "v25_" and "v34_". So an example MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix of database you are READING ...; Created on 12 September 2015
2. DataTumble - Randomize Data Rows: / Transact-SQL /; ... and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName ...; Created on 07 December 2012
3. Search a database for a value and count matching rows: / Databases /; ... ** ** - myTable: table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number ...; Created on 05 November 2012
4. Search a database for a string (MySQL, T-SQL): / Databases /; ... - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly ...; Created on 08 October 2012
5. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN ...; 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
7. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName WHERE ItemDate BETWEEN '01/01/2010' ...; Created on 03 August 2011
8. MySQL Commands to display all columns: / MySQL /; ... The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value ...; Created on 28 October 2010