pedroinfo

Sub RequisicaoHTTPUsandoProxyAutomatico()
    Dim HTTP As Object
    Dim URL As String
    Dim Resultado As String

    ' URL para teste
    URL = "http://www.google.com"

    ' Criação do objeto ServerXMLHTTP
    Set HTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0")

pedroinfo

Sub MostrarConfiguracoesProxy()
    Dim WinHttpReq As Object
    Dim ProxyConfig As String

    ' Cria um objeto WinHTTP
    Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1")

    ' Recupera as configurações de proxy do sistema
    On Error Resume Next
    WinHttpReq.SetProxy 0

pedroinfo

Sub getPeople()
    Dim req As MSXML2.ServerXMLHTTP60
    Dim Parsed As Dictionary
    Dim i As Integer
    Dim Results As Collection
    Dim Value As Dictionary

    Set req = New MSXML2.ServerXMLHTTP60
    
    api_url = "https://swapi.dev/api/people/"

pedroinfo

Use MyDb
GO

DROP TABLE IF EXISTS Tb_Funcionario

CREATE TABLE Tb_Funcionario
(
	Id				INT NOT NULL, 
	Nome			VARCHAR(200), 
	DataNascimento  DATE, 

pedroinfo

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

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

<style type="text/css">
  
  table, th, td {
  border: 1px solid ;
  width: 30%
}
  
</style>

<table id='table1'>

pedroinfo

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]

pedroinfo

<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({

pedroinfo

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)