Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
6| Name | Data Type | Length | Description |
|---|---|---|---|
| @apikey | varchar | 50 | |
| @cuit_consultado | varchar | 20 | |
| @user_id | int | 4 | |
| @pedido | datetime | 8 | |
| @ip | varchar | 16 | |
| @url | varchar | 100 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.insertar_api_log
@apikey varchar(50),
@cuit_consultado varchar(20),
@user_id int,
@pedido datetime,
@ip varchar(16),
@url varchar(100)
AS
BEGIN
SET NOCOUNT ON;
begin try
INSERT INTO api_log
(apikey,cuit_consultado,user_id,start_datetime,ip,url_consultada)
values
(@apikey,@cuit_consultado,@user_id,@pedido,@ip,@url)
end try
begin catch
select ERROR_MESSAGE() as error
end catch
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.insertar_api_log
@apikey varchar(50),
@cuit_consultado varchar(20),
@user_id int,
@pedido datetime,
@ip varchar(16),
@url varchar(100)
AS
BEGIN
SET NOCOUNT ON;
begin try
INSERT INTO api_log
(apikey,cuit_consultado,user_id,start_datetime,ip,url_consultada)
values
(@apikey,@cuit_consultado,@user_id,@pedido,@ip,@url)
end try
begin catch
select ERROR_MESSAGE() as error
end catch
END
GO
Depends On
2Used By
No items found