Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
8| Name | Data Type | Length | Description |
|---|---|---|---|
| @fecha_causa | date | 3 | |
| @actor | varchar | 150 | |
| @demandado | varchar | 150 | |
| @expediente | varchar | 50 | |
| @juzgado | varchar | 100 | |
| @secretaria | varchar | 100 | |
| @anio | smallint | 2 | |
| @objeto | varchar | 150 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.Fuentes_juicios
@fecha_causa date = NULL,
@actor varchar(150) = NULL,
@demandado varchar(150) = NULL,
@expediente varchar(50) = NULL,
@juzgado varchar(100) = NULL,
@secretaria varchar(100) = NULL,
@anio smallint = NULL,
@objeto varchar(150) = NULL
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO juicios(fecha_causa, actor, expediente, juzgado, secretaria, anio, demandado, objeto)
VALUES (
@fecha_causa,
@actor,
@expediente,
@juzgado,
@secretaria,
@anio,
@demandado,
@objeto
)
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.Fuentes_juicios
@fecha_causa date = NULL,
@actor varchar(150) = NULL,
@demandado varchar(150) = NULL,
@expediente varchar(50) = NULL,
@juzgado varchar(100) = NULL,
@secretaria varchar(100) = NULL,
@anio smallint = NULL,
@objeto varchar(150) = NULL
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO juicios(fecha_causa, actor, expediente, juzgado, secretaria, anio, demandado, objeto)
VALUES (
@fecha_causa,
@actor,
@expediente,
@juzgado,
@secretaria,
@anio,
@demandado,
@objeto
)
END
GO
Depends On
1Used By
No items found