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.
- 2011-10-25
Programming
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...
- 2011-05-16
Goal: Reduce long string to specified length for end-user preview. Reveal entire string when clicked. Go back to preview when clicked again. Check out the php and jQuery code: https://gitea.rnsworth.com/ben/PublicPosts/src/commit/b4f180878df7edc1b7ab71918d566736d619c87b/PHP%20and%20jQuery%20-%20Reduce%20Long%20String%20to%20Preview%20Length%20and%20Reveal%20Full%20Text%20OnClick.md YHTSZWNS7R6V
- 2011-05-14
- 1
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
- 2010-07-08
Create connection string:SqlConnection conn = new SqlConnection(“Data Source=DATASOURCE\\\\SQLEXPRESS;Initial Catalog=DATABASE_NAME;Integrated Security=True”); try { conn.Open(); SqlCommand sql = new SqlCommand(“SELECT * FROM tableName”, conn); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { this.TARGET_ID.InnerHtml += reader[“column”] ; } } catch (SqlException sqle) { sqle.Message.ToString(); }
- 2010-07-06
Connect Bot I probably don’t need to sell any develpers on the advantages of being able to access your server while on the go. Once in a while you just have to. Programs like Astro, AndroZip, and ES File Explorer are ok for some things but what if you have...
- 2010-06-24
A ternary operator is a quick shortcut to bypass the multi-line if-else statement. It is sufficient when simple setting a value of a variable based on a condition. It looks like this: That is saying “if $variable equals 10 then set $x equal to true, otherwise set $x equal to...
- 2010-06-22
Sometimes you have to add slashes to javascript text. PHP has it built in, javascript does not. Here is the code to put into your javascript to get the same functionality: function addslashes(str) { str=str.replace(/\\\\/g,’\\\\\\\\’); str=str.replace(/\\’/g,’\\\\\\”); str=str.replace(/\\”/g,’\\\\”‘); str=str.replace(/\\0/g,’\\\\0’); return str; } function stripslashes(str) { ...
- 2010-06-19