Michael McLaughlin
Rexburg, ID




Hear the Author!
Press to play



 
BLOG:

i-Blazon Prime
Wed, 25 Feb 2015 07:54:50 +0000
I replaced my OtterBox Defender with an i-Blazon Prime case when upgrading to the iPhone 6. It appeared a good option, and for 4 months it was fine. Yesterday, the latch broke and my iPhone fell to the ground as a walked. Fortunately, my iPhone landed flat, the i-Blazon plastic case absorbed the impact, and […]


SQL Server XQuery
Thu, 19 Feb 2015 08:54:45 +0000
I promised my students an example of writing xquery statements in Microsoft SQL Server. This post builds on two earlier posts. The first qualifies how to build a marvel table with source data, and the second qualifies how you can create an XML Schema Collection and insert relational data into an XML structure. You can […]


Insert into XML Column
Wed, 18 Feb 2015 09:22:55 +0000
Working through Chapter 7 of the Querying Microsoft SQL Server 2012 book for Microsoft’s Exam 70-461, I found the XML examples incomplete for my students. I decided to put together a post on how to create: An XML Schema Collection type. A table that uses an XML Schema Collection as a column’s data type. An […]


Functions disallow NDS
Sun, 15 Feb 2015 00:20:02 +0000
My students asked if you could embed an OFFSET x ROWS FETCH NEXT y ROWS ONLY clause in a SQL Server T-SQL user-defined function. The answer is no, it isn’t Oracle (yes, you can do that in Oracle Database 12c with an NDS statement). There’s an example in Chapter 2 of my Oracle Database 12c […]


Filtering String Dates
Mon, 02 Feb 2015 07:53:11 +0000
A question came up about how to verify dates from a string without throwing a casting error because of a non-conforming date. You can throw a number of exceptions, and I wrote a function to filter bad string formats like the DD-MON-RR or DD-MON-YYYY. The first one is for a day between 1 and the […]


A PL/pgSQL Function
Thu, 22 Jan 2015 08:03:00 +0000
Somebody wanted to know how to write a basic PostgreSQL PL/pgSQL function that returned a full name whether or not the middle name was provided. That’s pretty simple. There are principally two ways to write that type of concatenation function. One uses formal parameter names and the other uses positional values in lieu of the […]


 
Author Profile
Name: Michael McLaughlin
Location: Rexburg, ID
Subjects: Applications; Databases; Middleware; Servers;

Website: Oracle Press Books

Copyright © 2013 McGraw-Hill Global Education Holdings, LLC Any use is subject to the Terms of Use and Privacy Notice