Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming words is required, the following 52 results were found.

  1. Search a database for a value and count matching rowshttps://joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create a stored procedure and saving it on a database): IF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  2. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    is how your report should look now. Result: You can even run/preview it and you should get the below: Formatting In other words, making it look pretty. I'm doing this now because you may not need parameters or events. The above should create your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  3. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    the first part capitalizes any letter after a non-alpha letter. The remainder of it is to deal with exceptions to the rule, words that you want in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  4. MySQL Data Type Reference Tablehttps://joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

    My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  5. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    testing, about changing a production environment and doesn't need a hierarchical authorization workflow process (in other words, you don't have a boss): Method #1 (cowboy fix - not recommended): I would not recommend the following but I found this on...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  6. Some milestones for a website projecthttps://joellipman.com/articles/cms/website-development/some-milestones-for-a-website-project.html

    The concept - typically drawings, words, models, code and basic prototypes that describe the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  7. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    Instead I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  8. MS Excel: Convert a text to a numberhttps://joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    confused and reports an error?!?!?!? The answer on the Microsoft website is as helpful as the Microsoft paperclip, in other words, not worth the time or effort to try (didn't work anyway). The TRIM() function will not work for you either, nor with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  9. Passwords: Did-you-knowhttps://joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300. Additionally, it claims that it can crack 18% of the passwords in under 10 minutes...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  10. Joomla CMS: Register to Read Morehttps://joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    the article can still be indexed in global search engines such as Google. How? It's been difficult to search for the right words but heres the method to restrict the introtext to the public and fulltext (read more) to the registered users: Login to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  11. MediaWiki: MySQL to extract path to imageshttps://joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB

  12. Convert Decimal (Person Days) to Time in Excelhttps://joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    Task 2 0.07 0:30:00 Task 3 4.80 34:15:00 Excel needs the decimal number to be representative of a 24 hour slot. In other words, 1.0 in decimal, formatted to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 41 - 52 of 52