Gerar coluna de transporte

SELECT
        '[DataColum(ColumnName = "' || COLUMN_NAME || '")]' || chr(13) ||
        'public ' ||
        CASE DATA_TYPE
            WHEN 'uuid' THEN 'Nullable<Guid>'
            WHEN 'character varying' THEN 'string'
            WHEN 'boolean' THEN 'Nullable<bool>'
            WHEN 'timestamp without time zone' THEN 'Nullable<DateTimeOffset>'
            WHEN 'timestamp' THEN 'Nullable<DateTime>'
            WHEN 'integer' THEN 'Nullable<int>'
            WHEN 'smallint' THEN 'Nullable<short>'
            WHEN 'date' THEN 'Nullable<DateTime>'
            WHEN 'money' THEN 'Nullable<decimal>'
            ELSE 'Nullable<>'
        END
        ||' ' || REPLACE(COLUMN_NAME,'_','') || ' { get; set; }' || chr(13) || chr(13)
FROM
        information_schema.columns
WHERE
        TABLE_NAME='Fluxo_Caixa'
ORDER BY
        ordinal_position;

 

Fechar conexões do SQL Server

USE master
GO
SET NOCOUNT ON
DECLARE @DBName varchar(50)
DECLARE @spidstr varchar(8000)
DECLARE @ConnKilled smallint
SET @ConnKilled=0
SET @spidstr = ''

Set @DBName = 'DATABASE'
IF db_id(@DBName) < 4
BEGIN
PRINT 'Connections to system databases cannot be killed'
RETURN
END
SELECT @spidstr=coalesce(@spidstr,',' )+'kill '+convert(varchar, spid)+ '; '
FROM master..sysprocesses WHERE dbid=db_id(@DBName)

IF LEN(@spidstr) > 0
BEGIN
EXEC(@spidstr)
SELECT @ConnKilled = COUNT(1)
FROM master..sysprocesses WHERE dbid=db_id(@DBName)
END

Script para gerar classe de transporte

SELECT
		'[DataMember, DataColumnAttribute(Label = "' + COLUMN_NAME +  '", ColumnName = "' + COLUMN_NAME +  '", ColumnType = DataColumnType.NormalColumn)]' + CHAR(13)
		+ 'public ' +
		CASE DATA_TYPE
			WHEN 'bigint' THEN ' Nullable<Int64> '
			WHEN 'binary' THEN ' Nullable<> '
			WHEN 'bit' THEN ' Nullable<> '
			WHEN 'char' THEN ' Nullable<Char> '
			WHEN 'date' THEN ' Nullable<DateTime> '
			WHEN 'datetime' THEN ' Nullable<DateTime> '
			WHEN 'datetime2' THEN ' Nullable<DateTime> '
			WHEN 'datetimeoffset' THEN ' Nullable<DateTime> '
			WHEN 'decimal' THEN ' Nullable<Decimal> '
			WHEN 'float' THEN ' Nullable<Decimal> '
			WHEN 'geography' THEN ' Nullable<> '
			WHEN 'geometry' THEN ' Nullable<> '
			WHEN 'hierarchyid' THEN ' Nullable<> '
			WHEN 'image' THEN ' Nullable<> '
			WHEN 'int' THEN ' Nullable<Int32> '
			WHEN 'money' THEN ' Nullable<Decimal> '
			WHEN 'nchar' THEN ' String '
			WHEN 'ntext' THEN ' String '
			WHEN 'numeric' THEN ' Nullable<Decimal> '
			WHEN 'nvarchar' THEN ' String '
			WHEN 'real' THEN ' Decimal '
			WHEN 'smalldatetime' THEN ' Nullable<DateTime> '
			WHEN 'smallint' THEN ' Nullable<Int16> '
			WHEN 'smallmoney' THEN ' Nullable<Decimal> '
			WHEN 'sql_variant' THEN ' Nullable<> '
			WHEN 'sysname' THEN ' Nullable<> '
			WHEN 'text' THEN ' String '
			WHEN 'time' THEN ' Nullable<DateTime> '
			WHEN 'timestamp' THEN ' Nullable<Byte> '
			WHEN 'tinyint' THEN ' Nullable<Int16> '
			WHEN 'uniqueidentifier' THEN ' Nullable<Guid> '
			WHEN 'varbinary' THEN ' Nullable<Byte> '
			WHEN 'varchar' THEN ' String '
			WHEN 'xml' THEN ' String '
		END
		+ REPLACE(COLUMN_NAME,'_','') + ' { get; set; }' + CHAR(13)
FROM
		INFORMATION_SCHEMA.COLUMNS
WHERE
		TABLE_NAME LIKE 'TB_EMAIL'

Corrigir versão do CSF

Procedure para atualização de revisão do CSF

DECLARE @RC int
DECLARE @pIdProcesso INT
DECLARE @pIdIncidente int
DECLARE @pVrs varchar(15)

SET @pIdIncidente=-1 --Numero do processo
SET @pVrs='1.5.0.0'--Versao
SET @pIdProcesso=(SELECT Id_Processo FROM dbo.TB_CSF_INCIDENT WHERE id_incidente=@pIdIncidente)

EXECUTE @RC=[db_CSF].[dbo].[prU_CSF_Vsr_Sistema] @pIdProcesso,@pVrs