SQL – Convert rows of single column data to one row of columns

\ by

Transform a single column of data to a single row of data one column per each original row. I needed to quote-comma delimit the columns too.


SELECT name
FROM sys.sysdatabases
WHERE name LIKE '%master%'
ORDER BY name

SELECT TOP 1
 STUFF((
 SELECT ', "' + name + '"'
 FROM sys.sysdatabases
 WHERE name LIKE '%master%'
 ORDER BY name
 FOR
 XML PATH('')
 ), 1, 1, '')
FROM sys.sysdatabases

/*
name
--------------------------------------------
master
master_admin
master_settings
--------------------------------------------
 "master", "master_admin", "master_settings"
*/
Posted in: SQL

PowerShell – Check if “-verbose” is passed on command line.

\ by

Create a test to see if the command line had “-verbose” on it. Then run something.

if ($PSBoundParameters.verbose)	{
    Get-Item -Path "$OutputFile"
}

Here’s another way (found at StackOverflow.)

function DoStuff {
    [CmdletBinding()]
    param()

    process {
        if ($PSBoundParameters['Verbose']) {
            # do verbose stuff
        }

        New-Item Test -Type Directory -Verbose:($PSBoundParameters['Verbose'] -eq $true)
    }
}
Posted in: PowerShell