Related Queries: Ektron Alias With Folder Name
Category: SQL
Android Contacts – [MUST HAVE ROOT]
If you have rooted your phone, there are various ways to run these queries but I choose two ways that work for me. These code snippets will assist you in cleaning up your Android contacts. DISCLAIMER: Backup your contacts before you run any of these queries as I take no…
Form Action Page
This page will walk you through how to build one action page to handle various forms. WORK IN PROCESS! Form HTML fields should start with “form_” for this to work.
Clean Up Database
CAUTION: This is a very powerful script, use at your own risk! This script will: Drop all non-system stored procs Drop all views Drop all functions Drop all Foreign Key constraints Drop all Primary Key constraints Drop all tables
SQL Connection Test
For more connection string assistance visit: http://www.connectionstrings.com/
Gregorian Date to Hijri Date
Recently I was asked to help convert Gregorian Date to Hijri Date and vice versa. One thing to note is that with Hijri date format you must keep it as a string.
Add Column If Does Not Exist
This code will assist in helping you create a column should it not already exist.
Format Zip Code Properly
Sometimes a zip code is presented in a database with all nine numbers in the same column that has only five numbers. This query below will assist in formatting the numbers properly. Source: http://forums.sqlmag.com/forums/aft/77318