Skip to content

Instantly share code, notes, and snippets.

@NrI3
NrI3 / SPExample.sql
Created June 26, 2015 03:48
Procedimiento y cursor
create procedure SPPAcientesXMedico
@NombreMedico varchar(30)
as
declare
@nro int,
@nombrePaciente varchar(15),
@fechaNacimiento date,
@edad int,
@enfermedad varchar(15),
@diasTratamiento int,
@NrI3
NrI3 / Basic.sql
Last active August 29, 2015 14:23
[ MSSQL ] Basico
-- Agregar una nueva columna
alter table [table-name]
add [name-column] [data-type]
-- Agregar una columna con llave foranea
alter table [table-name]
add [name-column] [type]
constraint [name-of-fk]
foreign key([column-id]) references [table-name]([column-id])
/*
* by Jsn
* jason.scz@gmail.com
*/
/* app.js - angularjs */
var app = angular.module('Aplication',[]);
app.controller('MyController',function($scope){
@NrI3
NrI3 / dbConector.php
Last active August 29, 2015 14:27
Php mysql connector
<?php
class MYDB {
var $user;
var $pass;
var $data;
var $port;
var $host;
var $conx;
@NrI3
NrI3 / abs.js
Last active April 5, 2017 18:21
/*
* AbstractorJs
**/
var
// Author
AbstractorJs = "Create by Freddy J. Fernandez C. on Thu Nov 19 2015 04:19:20 GMT-04",
// document as doc
@NrI3
NrI3 / backup.sql
Created June 5, 2016 19:24
Full,Diferencial, Backup MSQL
use [master]
go
if (DB_ID('DBENTIDAD') is not null)
drop database [DBENTIDAD]
go
create database [DBENTIDAD]
go
/*
Create by Jsn jason.scz@gmail.com
*/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace Acceso_a_datos
@NrI3
NrI3 / Consola.cs
Created June 10, 2016 22:10
Colorea tu consola :p
public static class Consola
{
public static void WriteLine(string msg, params string[] arg)
{
string temp = "";
bool x = false;
int p = 0;
foreach (char c in msg)
{
if (c == '}' && x)
@NrI3
NrI3 / Random.sql
Created June 10, 2016 22:12
Crea numeros aleatorios MSqlServer
------------------------
-- by Jsn
-- jason.scz@gmail.com
------------------------
go
create view vwRANB
as
select CAST(ROUND(RAND(),0) AS BIT) as Bln
@NrI3
NrI3 / Client.php
Last active June 11, 2016 12:36
Laravel ejemplo inner join, where, select
<?php
namespace App;
use DB;
use App\Empresa;
use App\Persona;
use Illuminate\Database\Eloquent\Model;
class Cliente extends Model