Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @servicio | varchar | 128 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- [PEP_obtener_datos_login] 'svrlistas1'
CREATE OR ALTER PROCEDURE dbo.PEP_obtener_datos_login
@servicio varchar(128)
AS
BEGIN
SET NOCOUNT ON;
select top 1 * from PEP_login where servicio = @servicio and fecha_expiracion >= getdate() order by created desc
END
/*
select * from PEP_login order by created desc
select top 1 * from PEP_login where fecha_expiracion >= getdate() order by created desc
*/
GO
GO
-- [PEP_obtener_datos_login] 'svrlistas1'
CREATE OR ALTER PROCEDURE dbo.PEP_obtener_datos_login
@servicio varchar(128)
AS
BEGIN
SET NOCOUNT ON;
select top 1 * from PEP_login where servicio = @servicio and fecha_expiracion >= getdate() order by created desc
END
/*
select * from PEP_login order by created desc
select top 1 * from PEP_login where fecha_expiracion >= getdate() order by created desc
*/
GO
Depends On
1Used By
No items found