brnocesar

/* 1) enables insert of explicit values in the identity column */
SET IDENTITY_INSERT TABLE_NAME ON;

/* 2) inserts the value you want in the identity column */
INSERT TABLE_NAME (PK_COL, NAME, AGE) VALUES (987, 'Bruno', 22); 

/* 3) disables insert of explicit values in the identity column (DON'T FORGET!!!) */
SET IDENTITY_INSERT TABLE_NAME OFF;

brnocesar

DECLARE @tReturnedID TABLE (ID INT);
DECLARE @nReturnedID INT;

INSERT INTO TABELA (NOME, IDADE, DATA_REGISTRO) 
OUTPUT Inserted.ID INTO @tReturnedID
VALUES ('Bruno', '22', GETDATE());

SELECT TOP 1 @nReturnedID = ID FROM @tReturnedID; -- opção 1
SELECT @nReturnedID = SCOPE_IDENTITY(); -- opção 2

brnocesar

SELECT SUBSTRING('Jan Fev Mar Abr Mai Jun Jul Ago Set Out Nov Dez ', (mes * 4) - 3, 3) mes_abreviado 
FROM TB_MES_EM_NUMERO;

brnocesar

<?php

function verificaPeriodo(string $data) :string 
{
    $data = preg_replace("/^(0[1-9]|1[012])\/(20[12]\d)$/", "$2-$1-01", $data, -1, $cont);
    return $cont == 1 ? $data : "";
}

brnocesar

novo_formato => data_br.replace(/^([0123]\d)\/([01]\d)\/(20\d{2})$/, (padraoBr, dia, mes, ano) => `${mes}/${dia}/${ano}`)

brnocesar

# Show git branch name
force_color_prompt=yes
color_prompt=yes
parse_git_branch() {
 git branch 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/(\1)/'
}
if [ "$color_prompt" = yes ]; then
 PS1='${debian_chroot:+($debian_chroot)}\[\033[01;32m\]\u@\h\[\033[00m\]:\[\033[01;34m\]\w\[\033[01;31m\]$(parse_git_branch)\[\033[00m\]\$ '
else
 PS1='${debian_chroot:+($debian_chroot)}\u@\h:\w$(parse_git_branch)\$ '

brnocesar

{
    "python.pythonPath": "/usr/bin/python3",
    "indentRainbow.colors": [
        "rgba(235, 64, 52,0.01)",
        "rgba(235, 64, 52,0.04)",
        "rgba(235, 64, 52,0.02)",
        "rgba(235, 64, 52,0.06)",
        "rgba(235, 64, 52,0.03)"
    ],
    "bracket-pair-colorizer-2.colors": [