RickyLin

ALTER FUNCTION [dbo].[fnGetCSharpTypeNameFromSQLTypeName]
(
    @SQLTypeName NVARCHAR(64)
    , @IsNullable BIT
)
RETURNS NVARCHAR(64)
AS
-- TEST: SELECT dbo.fnGetCSharpTypeNameFromSQLTypeName('MONEY', 1)
BEGIN
    DECLARE @Result NVARCHAR(64)

RickyLin

git fetch origin -np

$BranchesToDelete = New-Object -TypeName System.Collections.Generic.List[string]
$BranchList = (git branch -vv)
foreach ($Branch in $BranchList) {
    if ($Branch.ToString().Contains(": gone]")) {
        $BranchesToDelete.Add($Branch.ToString().TrimStart().Split(' ')[0])
    }
}

RickyLin

# usage: StopAppPool.ps1 -AppPoolName DefaultAppPool
# set-executionpolicy remotesigned
# Document of WebAdministration:
#     https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ee790599(v%3dtechnet.10)
# multiple parameters sample: param([string]$paramA,[string]$paramB)

param([string]$AppPoolName)

if ([string]::IsNullOrEmpty($AppPoolName))
{

RickyLin

# usage: StartAppPool.ps1 -AppPoolName DefaultAppPool
# set-executionpolicy remotesigned
# Document of WebAdministration:
#     https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/ee790599(v%3dtechnet.10)
# multiple parameters sample: param([string]$paramA,[string]$paramB)

param([string]$AppPoolName)

if ([string]::IsNullOrEmpty($AppPoolName))
{

RickyLin

IF EXISTS ( SELECT 1 FROM sys.procedures WHERE name = 'spGenerateSqlStatement' )
    DROP PROCEDURE spGenerateSqlStatement
GO
CREATE PROCEDURE spGenerateSqlStatement
    @TableName VARCHAR(256)
AS
-- TEST: spGenerateSqlStatement 'Message'
DECLARE @SqlStmt VARCHAR(MAX)
DECLARE @Fields VARCHAR(MAX)
DECLARE @Params VARCHAR(MAX)

RickyLin

-- it comes from this great post: http://sqlperformance.com/2012/07/t-sql-queries/split-strings
-- this way turns out not to be very efficient
CREATE FUNCTION dbo.SplitStrings_XML
(
   @List       NVARCHAR(MAX),
   @Delimiter  NVARCHAR(255)
)
RETURNS TABLE
WITH SCHEMABINDING
AS

RickyLin

REM stop the IIS App Pool
%windir%\system32\inetsrv\appcmd stop apppool /apppool.name:DefaultAppPool

REM start the IIS App Pool
%windir%\system32\inetsrv\appcmd start apppool /apppool.name:DefaultAppPool