XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with elements not specified by the schema anyAttribute Enables...

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

Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+ @mySearchString +''')' + CHAR(10) FROM...

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

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema VARCHAR(max) ) AS...

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

MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns (displayed as...

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

Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 parameter 1 (matched in database to search) ** ** - myTable: table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number of records matching the value in this table. ** ** **...

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

Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 ) IS NOT NULL DROP PROCEDURE dbo.usp_MakeTableTemp; GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE...

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

XML Schema Diagramhttps://joellipman.com/articles/web-development/xml/xsd.html

• Type: Category
• Language: *

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema diagram, scheduled jobs) Examine content integrity (what is available front-end and back-end? can it be circumvented?)...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 that TravelPort provide you with but it didn't help. The error I'm going to address has to do with getting the latest schemas but as I couldn't find anything using Google regarding these errors or how to set up a basic ping request, I thought I'd write...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 client More Info: https://developer.ebay.com/marketplace-account-deletion metadata.topic topic of the notification metadata.schemaVersion schema version metadata.deprecated boolean to indicate deprecation notification.notificationId unique identifier of...

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

Drop If Object Existshttps://joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID (...

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