Within a Stored Procedure, you may want the results of a particular query emailed to you, but only if there is a result. In other words, I don’t want to be notified when the result set size is 0.
This trick is for SSMS users who like the MDI (window) environment. If you’ve noticed that new windows open with the instance connection hidden, then read on. I have your fix! Just open a query window, minimize it, and leave it there. After that, new windows will open at the correct level so you can… Read More »
http://msdn.microsoft.com/en-us/library/ms190310.aspx Returns a report that has information about user permissions for an object, or statement permissions, in the current database. See Microsoft link above for complete capabilities.
Occasionally, you discover something that you have been doing wrong for a long time. Sometimes it wasn’t something outright wrong but was just stupid. That is what happened to me. When using an HTML checkbox, it “POSTS” to the form submit page with the value of “on”. I have always converted that on the page… Read More »
SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM table1 GROUP BY COL_TO_CHECK HAVING COUNT(*) > 1 ORDER BY COUNT(*) If there is more than 1 column with that value it will show up like: COL_TO_CHECK COUNT(COL_TO_CHECK) ————————————————————- Value 3 Value2 2 Value99 4
mysqli is a built in part of mysql 4.1. It incorporates all functionality required to interact with a database from your PHP file. It has basics like querying the database, which includes SELECTing data as well as INSERTing data. It also give the ability to use prepared statements, transactions which can be committed or rolled… Read More »