Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @token | varchar | 1024 | |
| @sign | varchar | 512 | |
| @expiracion | datetime | 8 | |
| @servicio | varchar | 128 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
exec afip_guardar_autenticacion 'PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/Pgo8c3NvIHZlcnNpb249IjIuMCI+CiAgICA8aWQgc3JjPSJDTj13c2FhLCBPPUFGSVAsIEM9QVIsIFNFUklBTE5VTUJFUj1DVUlUIDMzNjkzNDUwMjM5IiB1bmlxdWVfaWQ9Ijc3NjM3MjYyMSIgZ2VuX3RpbWU9IjE3MzI4MTIzMzgiIGV4cF90aW1lPSIxNzMyODU1NTk4Ii8+CiAgICA8b3BlcmF0aW9uIHR5cGU9ImxvZ2luIiB2YWx1ZT0iZ3JhbnRlZCI+CiAgICAgICAgPGxvZ2luIGVudGl0eT0iMzM2OTM0NTAyMzkiIHNlcnZpY2U9IndzX3NyX3BhZHJvbl9hMTMiIHVpZD0iU0VSSUFMTlVNQkVSPUNVSVQgMzA2NDEzNjg5NzcsIENOPWFwaTIwMjMiIGF1dGhtZXRob2Q9ImNtcyIgcmVnbWV0aG9kPSIyMiI+CiAgICAgICAgICAgIDxyZWxhdGlvbnM+CiAgICAgICAgICAgICAgICA8cmVsYXRpb24ga2V5PSIzMDY0MTM2ODk3NyIgcmVsdHlwZT0iNCIvPgogICAgICAgICAgICA8L3JlbGF0aW9ucz4KICAgICAgICA8L2xvZ2luPgogICAgPC9vcGVyYXRpb24+Cjwvc3NvPgo='
,
'KZ/Uk97hMhCiABE+/P/d/7IleAenYHlr9J14DltPrxc6TLgus2nFLvAWG/ZvqL4Ylo4VhxhWjm4bDr+E5DF5xWoNwMyuB8/z3o5N1MHDPcezheUJHMvFCX+IpIIOE9By6XIW0kcifkSqEzvfU1KDnhxqRs+QfslGM6HoOeF22w8='
,
'2024-11-29 01:46:38'
,
'ws_sr_padron_a13'
*/
CREATE OR ALTER PROCEDURE dbo.afip_guardar_autenticacion
@token varchar(1024),
@sign varchar(512),
@expiracion datetime,
@servicio varchar(128)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO afip_login
(
token,
sign,
fecha_expiracion,
servicio
)
VALUES
(
@token,
@sign,
@expiracion,
@servicio
)
END
GO
GO
/*
exec afip_guardar_autenticacion 'PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/Pgo8c3NvIHZlcnNpb249IjIuMCI+CiAgICA8aWQgc3JjPSJDTj13c2FhLCBPPUFGSVAsIEM9QVIsIFNFUklBTE5VTUJFUj1DVUlUIDMzNjkzNDUwMjM5IiB1bmlxdWVfaWQ9Ijc3NjM3MjYyMSIgZ2VuX3RpbWU9IjE3MzI4MTIzMzgiIGV4cF90aW1lPSIxNzMyODU1NTk4Ii8+CiAgICA8b3BlcmF0aW9uIHR5cGU9ImxvZ2luIiB2YWx1ZT0iZ3JhbnRlZCI+CiAgICAgICAgPGxvZ2luIGVudGl0eT0iMzM2OTM0NTAyMzkiIHNlcnZpY2U9IndzX3NyX3BhZHJvbl9hMTMiIHVpZD0iU0VSSUFMTlVNQkVSPUNVSVQgMzA2NDEzNjg5NzcsIENOPWFwaTIwMjMiIGF1dGhtZXRob2Q9ImNtcyIgcmVnbWV0aG9kPSIyMiI+CiAgICAgICAgICAgIDxyZWxhdGlvbnM+CiAgICAgICAgICAgICAgICA8cmVsYXRpb24ga2V5PSIzMDY0MTM2ODk3NyIgcmVsdHlwZT0iNCIvPgogICAgICAgICAgICA8L3JlbGF0aW9ucz4KICAgICAgICA8L2xvZ2luPgogICAgPC9vcGVyYXRpb24+Cjwvc3NvPgo='
,
'KZ/Uk97hMhCiABE+/P/d/7IleAenYHlr9J14DltPrxc6TLgus2nFLvAWG/ZvqL4Ylo4VhxhWjm4bDr+E5DF5xWoNwMyuB8/z3o5N1MHDPcezheUJHMvFCX+IpIIOE9By6XIW0kcifkSqEzvfU1KDnhxqRs+QfslGM6HoOeF22w8='
,
'2024-11-29 01:46:38'
,
'ws_sr_padron_a13'
*/
CREATE OR ALTER PROCEDURE dbo.afip_guardar_autenticacion
@token varchar(1024),
@sign varchar(512),
@expiracion datetime,
@servicio varchar(128)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO afip_login
(
token,
sign,
fecha_expiracion,
servicio
)
VALUES
(
@token,
@sign,
@expiracion,
@servicio
)
END
GO
Depends On
1Used By
No items found