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

  1. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Airplane mode ms-settings:network-airplanemode ms-settings:proximity Cellular & SIM ms-settings:network-cellular Data usage ms-settings:datausage Dial-up ms-settings:network-dialup DirectAccess ms-settings:network-directaccess Ethernet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  2. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all...

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

  3. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    v1.2 ** ** Description: Script to create a SQL query which searches a database with SOUNDEX (detects typos). ** ** ** ** Usage: ** ** Step #1: EXEC [usp_GenerateSearchbySoundexQuery] 'mySearchString', 'tableSchemaToSearch'; ** ** Step #2: Run the query...

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

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

    to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC [usp_CountRecordsPerTablePerColumn] '3', 'Customer_ID'; ** ** ** ** Parameters : ** ** - Value: the value you want...

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

  5. Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    ALTER TABLE #myScrambledTable DROP COLUMN dummyIndex; -- Show me the results SELECT * FROM #myScrambledTable; END GO -- Usage: -- EXECUTE dbo.usp_MakeTableTemp 'mySchema.myTable'; Post-Notes Added a dummy index to track row numbers. Copies structure...

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

  6. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    ** ** Description: Stored Procedure to list distinct values and counts (defaults to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts] 'myDB.dbo.myTable', 'myColumn1,myColumn2', 'Latin1_General_CS_AS'; ** ** **...

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

  7. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples: ** ** EXEC usp_ScrambleMultivalue 'dbo.TableA', 'ColumnNameA'; ** ** ** ** EXEC usp_ScrambleMultivalue...

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

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

    "FAIRLANDS" "Fairlands" C/O DAD'S (JIMMY) C/O Dad's (Jimmy) SampleText SampleText lowercase.text lowercase.text Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically...

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

  9. Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    THEN RETURN ('Error in submitted value'); WHEN others THEN RETURN ('Unable to generate random value'); END UFN_DATASCRAMBLE; Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing inputted column...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  10. Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    := Needle2 ThisValue := SubStr( Haystack, Needle1, NeedleLen ) ThisValue=%ThisValue% Return [ThisValue, NeedleMarker] } ; Usage ; get table HTML ReturnedValues := ExtractText( Haystack, Needle1a, Needle1b, Needle2a, NeedleMarker ) TheHTMLTable :=...

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

  11. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    take first item of array (round up to largest unit) $v_ReturnStr = $a_UnitPairs[0].' ago'; // return return $v_ReturnStr; } Usage $v_Str = getTimeAgo('2019-05-16 19:30:00'); // If (at time of print) this date is 17 minutes and 5 seconds ago // then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  12. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    y = b.my_col2_val.toLowerCase(); return x < y ? -1 : x > y ? 1 : 0; }); // return the array of objects return obj_temp; } // usage: // where "this_file_url" is the target CSV to read (relative URL from the HTML file launching this function (not from the...

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

  13. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Artist Styles I've tried to list artists here who have styles that I could not generate using the above keywords/tokens. Usage:...in the style of... Note that some of these may verge on Copyright Infringement so be careful if posting commercially (ie....

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *

  14. Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    per minute | not for commercial use]: v_Url = "http://ip-api.com/json/"+ zoho.ipaddress; v_Response = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success",...

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

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

    L (for Lowercase) A (for AlphaNumeric) X (for Alphanumeric with upper case alphabets) P (for Printable characters only) Usage select dbms_random.random from dual; -- yields random number, eg. 68489408 select dbms_random.value from dual; -- yields values...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
Results 21 - 35 of 35