SQL Server – Email Results of Stored Procedure Conditionally Writer #1, 2012-12-10 Within a Stored Procedure, you may want the results of a particular query emailed to… Continue Reading
SSMS MDI Trick Writer #1, 2012-12-07 This trick is for SSMS users who like the MDI (window) environment. If you’ve noticed… Continue Reading
SQL SQL Server – Find Stored Procedures User Can Access Writer #1, 2011-10-25 http://msdn.microsoft.com/en-us/library/ms190310.aspx Returns a report that has information about user permissions for an object, or statement… Continue Reading
HTML Checkboxes Writer #1, 2011-05-16 Occasionally, you discover something that you have been doing wrong for a long time. Sometimes… Continue Reading
Finding Duplicate Records In Database Writer #1, 2010-07-082024-06-12 SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM table1 GROUP BY COL_TO_CHECK HAVING COUNT(*) > 1 ORDER BY COUNT(*)… Continue Reading
MySQL mysqli Writer #1, 2010-06-15 mysqli is a built in part of mysql 4.1. It incorporates all functionality required to… Continue Reading