Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.0.2 | MSSQL - Ektron 8.7 | SQL
Ektron Content Folder Names
Related Queries: Ektron Alias With Folder Name
-
-
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 responsibility for anything that happens…
-
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.
-
Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.0.2 | SQL
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
-
-
-
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