Category: SQL

Alter Table Column Data Type

Posted on October 10, 2013October 26, 2015 By David Kittell

Example:

Delimiter Split

Posted on September 30, 2013October 26, 2015 By David Kittell

Source: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4126a010-6885-4eb0-b79c-c798c90edb85/how-to-split-comma-delimited-string

Create / Delete SQLite Database Indexes

Posted on September 27, 2013December 30, 2015 By David Kittell

Source: Billy047 @ http://www.basic4ppc.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/page-2

Create SQLite Database With Auto Increment

Posted on September 27, 2013December 30, 2015 By David Kittell

Source: Billy047 @ http://www.basic4ppc.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/page-2

Show Records Not In Another Table – Concatenated

Posted on September 24, 2013October 26, 2015 By David Kittell

Update Table With Inner Join

Posted on September 18, 2013October 26, 2015 By David Kittell

Provider Detail With Address

Posted on September 16, 2013October 26, 2015 By David Kittell

Ektron Metrics Script

Posted on September 10, 2013October 26, 2015 By David Kittell

This is a compilation of some of the scripts on this site to get numbers to report to management

Ektron Content Status Codes

Posted on September 10, 2013October 26, 2015 By David Kittell

This is a list of code definitions for the content_status column in the content table Letter Meaning Content state More Information A Approved Through the workflow and published on the Web site. Approved Content O Checked Out Currently being edited. Has not been checked in. Checked Out Content I Checked…

Data Metrics

Posted on September 9, 2013October 26, 2015 By David Kittell

In a plan to make metrics easier to record and show I have built my own database tables to record custom metrics. Metrics – Year View C# Metrics Admin Page C# Table Creation Metrics YEar View Page C# Metrics Admin Page C# Table Creation