Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @cuit | varchar | 20 | |
| @nombre | varchar | 500 | |
| @pais | varchar | 2 | |
| @respuesta | varchar | -1 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
-- drop PROCEDURE [dbo].[Consultas_worldsys_]
exec [Consultas_worldsys_]
'27386010841','ROQUE MARIA BELEN','AR',
'{"evaluationId":47598138,"matchCount":0,"maxScore":0,"minScore":0,"hasDocumentHits":false,"includesOwnSources":false,"isMarkedNegative":false,"systemResult":6,"hits":[]}'
select * from Consultas_worldsys where id = 280501
*/
CREATE OR ALTER PROCEDURE dbo.Consultas_worldsys_
@cuit varchar(20),
@nombre varchar(500),
@pais varchar(2),
@respuesta varchar(max)
AS
BEGIN
SET NOCOUNT ON;
insert into Consultas_worldsys(cuit,nombre,pais,response) values (@cuit,@nombre,@pais,@respuesta)
select 'ok'
END
GO
GO
/*
-- drop PROCEDURE [dbo].[Consultas_worldsys_]
exec [Consultas_worldsys_]
'27386010841','ROQUE MARIA BELEN','AR',
'{"evaluationId":47598138,"matchCount":0,"maxScore":0,"minScore":0,"hasDocumentHits":false,"includesOwnSources":false,"isMarkedNegative":false,"systemResult":6,"hits":[]}'
select * from Consultas_worldsys where id = 280501
*/
CREATE OR ALTER PROCEDURE dbo.Consultas_worldsys_
@cuit varchar(20),
@nombre varchar(500),
@pais varchar(2),
@respuesta varchar(max)
AS
BEGIN
SET NOCOUNT ON;
insert into Consultas_worldsys(cuit,nombre,pais,response) values (@cuit,@nombre,@pais,@respuesta)
select 'ok'
END
GO
Depends On
1Used By
No items found