Skip to content

Instantly share code, notes, and snippets.

View pedroinfo's full-sized avatar

Pedro Xavier pedroinfo

  • São Paulo - BR - Solar System | Milky Way
View GitHub Profile
@pedroinfo
pedroinfo / CaseWhenVivi.sql
Last active January 19, 2024 17:24
Case When Example - Vivi
Use MyDb
GO
DROP TABLE IF EXISTS Tb_Funcionario
CREATE TABLE Tb_Funcionario
(
Id INT NOT NULL,
Nome VARCHAR(200),
DataNascimento DATE,
@pedroinfo
pedroinfo / CaseWhen.sql
Created July 28, 2023 17:59
Exemplo de CASE WHEN para Vivi
IF OBJECT_ID('tempdb..#Tb_Pessoa') IS NOT NULL
DROP TABLE #Tb_Pessoa
CREATE TABLE #Tb_Pessoa
(
Id INT,
Nome VARCHAR(100),
Estado VARCHAR(100)
)
@pedroinfo
pedroinfo / HappyInsert.sql
Created March 30, 2022 15:04
How to generate insert from select
IF OBJECT_ID('tempdb..#Personagens') IS NOT NULL DROP TABLE #Personagens
GO
CREATE TABLE #Personagens(
Id INT IDENTITY,
Nome VARCHAR(100),
Funcao VARCHAR(100)
)
@pedroinfo
pedroinfo / table.html
Created January 28, 2022 16:17
html table to JS array
<style type="text/css">
table, th, td {
border: 1px solid ;
width: 30%
}
</style>
<table id='table1'>
Ideias - Ajax
- Upload/Download de arquivos 1 ou N com barra de progresso.
- POST, GET, PUT, DELETE, PATCH - Enviar token, enviar cookie, autenticação, etc.
- Submit Form (FormData)
- jQuery [Uso do jQuery no Ajax / Ajax.Setup]
<div class="input-group date">
<input type="text" asp-for="DataPlanejada" class="form-control datepicker-button autocomplete="off">
<div class="input-group-append">
<label class="input-group-text" asp-for="DataPlanejada"><i class="fa fa-calendar"></i></label>
</div>
</div>
$('.datepkr_ano, .input-group.ano datepkr_ano').datepicker({
static string Between(this string source, string left, string right)
{
return Regex.Match(
source,
string.Format("{0}(.*){1}", left, right))
.Groups[1].Value;
}
private static List<string> ExtractFromString(string source, string start, string end)
using FileHelpers;
using System;
using System.Collections.Generic;
using System.IO;
//Nuget: Install-Package FileHelpers
namespace Bingo
{
USE myTestDB
GO
/****** Object: Table [HangFire].[AggregatedCounter] Script Date: 13/11/2020 14:16:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [HangFire].[AggregatedCounter](
[Key] [nvarchar](100) NOT NULL,
//https://stackoverflow.com/questions/8952003/how-does-hashset-compare-elements-for-equality
namespace HashSet
{
public class Employe
{
public Employe() {
}
public string Name { get; set; }