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