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

  1. Convert a delimited string to tablehttps://www.joellipman.com/articles/else/database/convert-a-delimited-string-to-table.html

    VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml = CONVERT(xml,'' + REPLACE(@myStringToParse,',','') +...

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

  2. 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

    BEGIN -- Declare some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 1 - 2 of 2