shaneis

DECLARE
	@job_sql AS nvarchar(max),
	@job_name AS nvarchar(128) = N'syspolicy_purge_history', -- = N'No existy',
	@debug_mode_on AS bit = 1; -- 0;

DECLARE
	@nl AS nchar(2),
	@actual_job_name AS nvarchar(128);

/* Newline for formatting */

shaneis

package main

import (
	"database/sql"
	"fmt"
	"log"

	// this is the driver & yes, even though we're throwing 
	// it away to `_`, it's still needed
	_ "github.com/denisenkom/go-mssqldb"

shaneis

USE tempdb;
GO
IF OBJECT_ID(N'dbo.LollerCoaster', N'U') IS NOT NULL BEGIN
	DROP TABLE dbo.LollerCoaster;
END;
GO
CREATE TABLE dbo.LollerCoaster (
	loller_coaster_id tinyint IDENTITY(1, 1) NOT NULL,
	loller_coaster_stage varchar(4000) NOT NULL
);

shaneis

describe 'testing our function with scriptroot' {
     # Get our self contained script info.
     . .\Get-FunctionInfo.ps1
     $fInfo = Get-FunctionInfo -Path .\Get-NameScriptBlock.ps1

     # Create something we can dot-source.
     $Fake = "function $($fInfo.Name) { $($fInfo.Definition) }"
     $FakeFunc = [scriptblock]::Create($Fake)
     . $FakeFunc

shaneis

function Get-Name {
    [CmdletBinding()]
    param(
        [String]$Name = 'you'
    )

    'Hello, {0}. Script root is {1}' -f $Name, $PSScriptRoot
}

Get-Name -Name Shane

shaneis

DECLARE @XmlStoredAsNvarchar nvarchar(4000) = '
<EventContext>
  <eventType>Save Test Data</eventType>
  <discipline>Operations</discipline>
  <documentNumber>1.2.3.4</documentNumber>
  <documentVersion>1.0</documentVersion>
  <sectionNumber>1.2.1.1</sectionNumber>
  <sectionName>Test section: XML Test</sectionName>
  <tableIdentifier>1</tableIdentifier>
  <objectType>Object</objectType>

shaneis

DECLARE @XmlStoredAsNvarchar nvarchar(4000) = '
<EventContext>
  <eventType>Save Test Data</eventType>
  <discipline>Operations</discipline>
  <documentNumber>1.2.3.4</documentNumber>
  <documentVersion>1.0</documentVersion>
  <sectionNumber>1.2.1.1</sectionNumber>
  <sectionName>Test section: XML Test</sectionName>
  <tableIdentifier>1</tableIdentifier>
  <objectType>Object</objectType>

shaneis

DECLARE @XmlStoredAsNvarchar nvarchar(4000) = '
<EventContext>
  <eventType>Save Test Data</eventType>
  <discipline>Operations</discipline>
  <documentNumber>1.2.3.4</documentNumber>
  <documentVersion>1.0</documentVersion>
  <sectionNumber>1.2.1.1</sectionNumber>
  <sectionName>Test section: XML Test</sectionName>
  <tableIdentifier>1</tableIdentifier>
  <objectType>Object</objectType>

shaneis

DECLARE @XmlStoredAsNvarchar nvarchar(4000) = '
<EventContext>
  <eventType>Save Test Data</eventType>
  <discipline>Operations</discipline>
  <documentNumber>1.2.3.4</documentNumber>
  <documentVersion>1.0</documentVersion>
  <sectionNumber>1.2.1.1</sectionNumber>
  <sectionName>Test section: XML Test</sectionName>
  <tableIdentifier>1</tableIdentifier>
  <objectType>Object</objectType>

shaneis

function Update-JamesStatus {
    [CmdletBinding()]
    param(
        [Parameter(Position = 1)]
        [ValidateNotNullOrEmpty()]
        [String]
        $SlackTitle = 'James is locked out again...',
        
        [Parameter(Position = 2)]
        [ValidateNotNullOrEmpty()]