Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @apikey | varchar | 20 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- =============================================
-- Author: <Leonel,Turchetto>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.api_obtener_configuracion_secciones
@apikey varchar(20)
AS
BEGIN
SET NOCOUNT ON;
select * from api_configuracion where apikey = @apikey
END
/*
insert into api_configuracion
(apikey,bancos_y_cheques,comerciales,comex,contables,fiscales,formales,legales,legales_homonimos,relaciones,relaciones_homonimos,score_ic,created)
values
('BHSXRGC4CVB3D6CX',1,1,1,1,1,1,1,1,1,1,1,getdate())*/
GO
GO
-- =============================================
-- Author: <Leonel,Turchetto>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.api_obtener_configuracion_secciones
@apikey varchar(20)
AS
BEGIN
SET NOCOUNT ON;
select * from api_configuracion where apikey = @apikey
END
/*
insert into api_configuracion
(apikey,bancos_y_cheques,comerciales,comex,contables,fiscales,formales,legales,legales_homonimos,relaciones,relaciones_homonimos,score_ic,created)
values
('BHSXRGC4CVB3D6CX',1,1,1,1,1,1,1,1,1,1,1,getdate())*/
GO
Depends On
1Used By
No items found