Search - Joel Lipman .Com

1. XML Schema Diagram: / Category /; Created on 05 March 2020
2. XML Schema Reference: / Extensible Markup Language /; ... schema comments any Enables the author to extend the XML document with elements not specified by the schema anyAttribute Enables the author to extend the XML document with attributes not specified ...; Created on 13 August 2014
3. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; ... online 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 ...; Created on 27 April 2015
4. Android OS: Add GoogleMap as fragment: / AndroidOS /; Applies to: Android Studio (Beta) 0.8.9 Android Google Maps v2 What? A sequel to my article "Basic Android App using Google Maps and Current Location", this article suggests how to add Map as ...; Created on 25 November 2014
5. Android Java: Remove first two entries from Google News feed in SimpleRssReader: / AndroidOS /; What? A quick article on how to remove the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from ...; Created on 24 October 2014
6. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; What? An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- ...; Created on 18 August 2014
7. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
8. Compare two databases using T-SQL: / Transact-SQL /; ... here and then 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 ...; Created on 24 September 2013
9. 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
10. Search a database with SOUNDEX: / Databases /; ... PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max), @p_TableSchema VARCHAR(max) ) AS /***************************************************************************************************************** ** ...; Created on 11 October 2012
11. Search a database for a string (MySQL, T-SQL): / Databases /; ... @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) ...; Created on 08 October 2012
12. 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
13. Drop If Object Exists: / Transact-SQL /; ... 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 ...; Created on 03 August 2012
14. 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
15. T-SQL Record Separator: / Transact-SQL /; ... perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM [pretendDatabase].[pretendSchema].[pretendTable] t0 WHERE [pretendField]='elephantastic' -- ...; Created on 11 October 2011
16. Developer's Checklist: Taking over a projec: / Web-Development /; ... goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema ...; Created on 01 March 2011
17. MySQL Commands to display all columns: / MySQL /; ... The following is a 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 ...; Created on 28 October 2010
18. Header (Transparent): Created on 01 January 2018
19. Header (Flex): Created on 30 December 2017
20. Header (Centered): Created on 17 April 2017