arshad115

Collection of Useful SQL queries

/* Count Number Of Tables In A Database */
SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
 
/* Count Number Of Views In A Database */
SELECT COUNT(*) AS VIEW_COUNT FROM INFORMATION_SCHEMA.VIEWS
 
/* Count Number Of Stored Procedures In A Database */

arshad115

How to bind data correctly with ng-model with angular uib-datepicker-popup

If you get a date from a database and you bind it to the Angular ui datepicker and it does not bind correctly, you just have to convert it into a date object on init like:

JS

data.bsc = new Date(data.bsc);

HTML

arshad115

    /***
     * Android L (lollipop, API 21) introduced a new problem when trying to invoke implicit intent,
     * "java.lang.IllegalArgumentException: Service Intent must be explicit"
     *
     * The function given here works for a single application package with the same intent filter. 
     * https://gist.github.com/SeanZoR/068f19545e51e4627749
     * 
     * I had a scenario in which there was a free version and a paid version of the same app installed, this function returns null in that case. 
     * So I decided to fix it and here is the working solution which matches the application package and then returns the correct intent.
     *