- 1. DataTumble - Randomize Data Rows
- / Transact-SQL /
- ... VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS /***************************************************************************************************************** ** ...
- Created on 07 December 2012
- 2. 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