This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'fsutil file createnew <NOMBRE_ARCHIVO> <TAMAÑO EN BYTES> | |
'Para el cálculo de bytes https://es.calcuworld.com/informatica/calculadora-de-bytes/ | |
fsutil file createnew archivo_3_megas.pdf 3145728 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
dir /b /s /a-d >lista_archivos.txt |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Lista de tablas | |
SELECT * FROM INFORMATION_SCHEMA.TABLES | |
-- Lista de SP's | |
SELECT * FROM INFORMATION_SCHEMA.routines where routine_type = 'PROCEDURE' | |
-- Lista de tablas con las columnas y sus descripciones | |
SELECT sys.objects.name AS TableName, | |
sys.columns.name AS ColumnName, | |
ep.value AS Description |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE USER [USUARIO_OTRO_ESQUEMA] FOR LOGIN [USUARIO_OTRO_ESQUEMA]; | |
GRANT SELECT TO USUARIO_OTRO_ESQUEMA; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE #tabla_temporal ( | |
id_tabla BIGINT | |
,cd_columna_01 BIGINT | |
,gl_columna_02 | |
) | |
CREATE NONCLUSTERED INDEX idx_tabla_temporal ON #tabla_temporal ([id_tabla]) | |
-- Otras formas de definir indices |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$(document).ready(function(){ | |
/** | |
* Setea e inicializa la tabla con datos | |
*/ | |
$("#tbl_ajax").DataTable({ | |
"ajax" : URL_SERVICIO, | |
"columns" : [ | |
{"data" : "col1" }, | |
{"data" : "col2"}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Clase para el cálculo del valor Factoral (n!) | |
* de un número entero usando recursividad | |
*/ | |
class Factorial { | |
/** | |
* Cálculo el valor factorial (n!) | |
* llamada al método | |
* |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.util.concurrent.ThreadLocalRandom; | |
class Helper { | |
static int[] lista_generica_valores ( int largo_cadena ) { | |
int [] arreglo_base = new int[largo_cadena]; | |
for ( int n =0; n<largo_cadena;n++ ) { | |
arreglo_base[n] = ThreadLocalRandom.current().nextInt(0, 100000 + 1); | |
} | |
return arreglo_base; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import java.util.concurrent.ThreadLocalRandom; | |
class Helper { | |
static int[] lista_generica_valores ( int largo_cadena ) { | |
int [] arreglo_base = new int[largo_cadena]; | |
for ( int n =0; n<largo_cadena;n++ ) { | |
arreglo_base[n] = ThreadLocalRandom.current().nextInt(0, 100000 + 1); | |
} | |
return arreglo_base; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Basado en el motor SqlServer 2012 | |
SELECT FORMAT(getdate(), 'dd/MM/yyyy HH:mm') AS fecha_formateada | |