Skip to content

Instantly share code, notes, and snippets.

View ajace's full-sized avatar

Ace Atienza ajace

  • Cainkade
  • New York, NY
View GitHub Profile
function addOrdinalSuffix(number) {
return number+(['st','nd','rd'][( number +'').match(/1?\d\b/)-1]||'th');
}
@ajace
ajace / strings.xml
Created January 23, 2017 20:36
Use CDATA along with string formatting for hyperlinks (Android)
<string name="link"> <![CDATA[<a href="%1$s"><u>%2$s</u></a>]]> </string>
@ajace
ajace / SSMA
Created June 21, 2017 20:54
SSMA migration from MySql to SQL Server
SSMA
General Solutions for migration
1. Update Mysql DB
2. SSMA > Table > Refresh from DB
3. SSMA > Table > Convert Schema
4. SSMA > SQL Server Table > Synchronize with Database
5. SSMA > MySQL Table > Migrate Data
6. Apply previous MySQL logic in MSSQL equivalent (most should be possible) in separate query