Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @action | varchar | 15 | |
| @dbid | bigint | 8 | |
| @listacuit | varchar | -1 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
exec Imperium_pdf_read 'UPDLISTACUIT',4968390035,'30707596321,20223756167,20326835219,27275516797,20376313280,27275501366,27383308491,20169079189,30707598321,30707696321,20356376006,27338279634,27958167062,20333118134,20361452896,30707596324,20378434301,307075963214,20221768796,23304695419,20146650024'
select cuit_found,* from led_docs where doc_id = '4972439458'
*/
CREATE OR ALTER PROCEDURE dbo.Imperium_pdf_read
@action varchar(15),
@dbid bigint,
@listacuit varchar(max)
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;
BEGIN
update led_docs set cuit_found=@listacuit where doc_id=@dbid
end
select 'OK' as error
END TRY
BEGIN CATCH
SELECT ERROR_MESSAGE() as error
END CATCH
END
GO
GO
/*
exec Imperium_pdf_read 'UPDLISTACUIT',4968390035,'30707596321,20223756167,20326835219,27275516797,20376313280,27275501366,27383308491,20169079189,30707598321,30707696321,20356376006,27338279634,27958167062,20333118134,20361452896,30707596324,20378434301,307075963214,20221768796,23304695419,20146650024'
select cuit_found,* from led_docs where doc_id = '4972439458'
*/
CREATE OR ALTER PROCEDURE dbo.Imperium_pdf_read
@action varchar(15),
@dbid bigint,
@listacuit varchar(max)
AS
BEGIN
BEGIN TRY
SET NOCOUNT ON;
BEGIN
update led_docs set cuit_found=@listacuit where doc_id=@dbid
end
select 'OK' as error
END TRY
BEGIN CATCH
SELECT ERROR_MESSAGE() as error
END CATCH
END
GO
Depends On
1Used By
No items found