DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

07 December 2012 ** Author: - ** ** Created On: 28 August 2009 ** ** Revision: V 0.01 ** ** Description: Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

15 February 2010 example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte Unsigned values from 0 to 255 Numeric SmallInt Signed...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 PageID PageTitle PageContent ---------------- ------------------ --------------------- 1144 7911_and_7912_t... ==Description==... -- to get a row from my custom audit table SELECT ApprovalID, ArticleID, DateSigned FROM Audit_Publishing WHERE ArticleID...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/else/database/mysql/error-1065-query-was-empty.html

13 December 2012 all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in SQL for future use: Character Description \0 An ASCII NUL (0x00) character. \' A single quote (“'”) character. \" A double quote (“"”) character. \b A backspace...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

25 February 2010 documentation Issues and Errors List Issues List Create an excel spreadsheet that all involved can modify date entered description owner status (open, in progress, closed)? solution date resolved Errors List Clear error logs Refer to list of all pages...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/cms/website-development/display-feeds-to-major-social-networks.html

16 May 2016 page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right of the description. Click Embed From the box that appears, Copy & Paste the code into your blog or website HTML. YouTube Go to YouTube and...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

13 August 2014 that an element or an attribute value must be unique within the scope XSD Restrictions/Facets for Datatypes Constraint Description enumeration Defines a list of acceptable values fractionDigits Specifies the maximum number of decimal places allowed....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: en-GB