brunotdantas

:: Source: https://www.sqlservercentral.com/scripts/run-sqlt-sql-scripts-on-folder
:: A bat script to run all the sql/t-sql scripts in a specific folder.
:: 
:: Features:
:: 
:: - Using SQLCMD for running the scripts.
:: 
:: - Logging the results of your sql to a file per script.
:: 
:: - Input for scripts and log folders.

brunotdantas

var foco = "";
var msgstatus = "";
// fonte: http://www.receita.fazenda.gov.br/aplicacoes/atcta/cpf/funcoes.js
/*************************************************
	Função que permitir digitar numeros 
**************************************************/
function EntradaNumerico(evt) {

    var key_code = evt.keyCode  ? evt.keyCode  :
                   evt.charCode ? evt.charCode :

brunotdantas

DECLARE @XML XML
SET @XML = '<rows><row>
<transacao>
    <IdInvernadero>8</IdInvernadero>
    <IdProducto>3</IdProducto>
		<cars> 
			<id>z</id>
			<test> oi</test>
		</cars>
    <IdCaracteristica1>8</IdCaracteristica1>

brunotdantas

-- Orinal em Mysql : https://www.ricardoarrigoni.com.br/cidades-brasil-lista-de-cidades-brasileiras-em-sql/ 

--------------------------------------------
--> Scrip  abaixo cria estrutura de Pais > Estado > Cidade
--------------------------------------------

-- < Cria tabela de países > --
IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[paises]') ) 
DROP TABLE paises; -- < Dropa a tabela se já existir > -- 
CREATE TABLE paises (

brunotdantas

<?php

// requiring autoload with the pluguin
require __DIR__ . '/../../vendor/autoload.php';

// invoking needed classes 
use PhpOffice\PhpSpreadsheet\Spreadsheet; //class responsible to change the spreadsheet
use PhpOffice\PhpSpreadsheet\Writer\Xlsx; //class that write the table in .xlsx

$spreadsheet = new Spreadsheet(); //instanciando uma nova planilha

brunotdantas

<?php
/***********************************************************
			MYSQL VERSION 
************************************************************/

$username="root";		$password="";		$database="exam_codes";
$con = mysql_connect("localhost",$username,$password) or die( "Unable to Connect database");
mysql_select_db($database,$con) or die( "Unable to select database");
// Table Name that you want
// to export in csv