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 source is required, the following 192 results were found.

  1. Transact-SQL Date Format Conversionshttps://www.joellipman.com/articles/else/database/t-sql/transact-sql-date-format-conversions.html

    Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx

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

  2. DBMS Random Referencehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/dbms-random-reference.html

    dbms_random.string('P', 10) myAlias from dual; -- yields string of 10 printable characters (includes symbols/punctuation) Source: derived from:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  3. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html

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

  4. Trim values along with the tabhttps://www.joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

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

  5. Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

    sure I don't spend so long anymore on debugging code. The aim of this article is to quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able...

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

  6. A picture of the Internethttps://www.joellipman.com/articles/cms/website-development/a-picture-of-the-internet.html

    Just a pretty picture on how hackers have created an infographic of the internet: Source: BitBucket.Org - Internet Census 2012

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

  7. Change div height to fit contenthttps://www.joellipman.com/articles/cms/website-development/css/change-div-height-to-fit-content.html

    this to happen: The code of this is the addedn overflow:hidden;height:1%;: A long heading that wraps over several lines Source(s): Stack Overflow - make div's height expand with its content

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  8. Peanut Butter Milkshake Recipehttps://www.joellipman.com/component/content/article/peanut-butter-milkshake-recipe.html?catid=96&Itemid=165

    and add the vanilla and peanut butter. Whirl for 1 minute; add 2 scoops ice cream, then whirl 1 minute more. Servings: 1 Source: http://www.recipes-4u.co.uk/drink/Peanut-Butter-Milkshake.html

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

  9. Phonetic and Morse alphabethttps://www.joellipman.com/component/content/article/phonetic-and-morse-alphabet.html?catid=96&Itemid=165

    was using this for a password security-level checker: Source: www.wikipedia.org

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

  10. Added a Launcher and Unduplicaterhttps://www.joellipman.com/component/content/article/added-a-launcher-and-unduplicater.html?catid=100&Itemid=165

    which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you can run the AHK files and modify these to suit your...

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

  11. MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/component/content/article/ms-excel-open-csv-with-long-numbers.html?catid=110&Itemid=165

    file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2....

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

  12. The greatest invention in IThttps://www.joellipman.com/component/content/article/the-greatest-invention-in-it.html?catid=116&Itemid=165

    useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)." Source: Behavioral Issues in the Use of Interactive Systems. If you've guessed it, my vote goes for whoever invented the "Undo"...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 181 - 192 of 192