Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @codigo | varchar | 100 | |
| @mensaje | varchar | 250 | |
| @token | varchar | 1024 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.Renaper_guardar_autenticacion
@codigo varchar(100),
@mensaje varchar(250),
@token varchar(1024)
AS
BEGIN
SET NOCOUNT ON;
-- expiracion hoy a las 23:59
declare @expiracion datetime = convert(date, getdate())
set @expiracion = dateadd(day, +1, @expiracion)
set @expiracion = dateadd(second, -1, @expiracion)
select @expiracion
INSERT INTO Renaper_login
(codigo, mensaje, token, fecha_expiracion)
VALUES
(
@codigo,
@mensaje,
@token,
@expiracion
)
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.Renaper_guardar_autenticacion
@codigo varchar(100),
@mensaje varchar(250),
@token varchar(1024)
AS
BEGIN
SET NOCOUNT ON;
-- expiracion hoy a las 23:59
declare @expiracion datetime = convert(date, getdate())
set @expiracion = dateadd(day, +1, @expiracion)
set @expiracion = dateadd(second, -1, @expiracion)
select @expiracion
INSERT INTO Renaper_login
(codigo, mensaje, token, fecha_expiracion)
VALUES
(
@codigo,
@mensaje,
@token,
@expiracion
)
END
GO
Depends On
No items found
Used By
No items found