Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.Genera_ID_Archivo
AS
BEGIN
SET NOCOUNT ON;
DECLARE @nkey int
SET @nkey = 0
WHILE @nkey = 0 BEGIN
SET @nkey = convert(int,rand()*10000000)
IF EXISTS (SELECT archivo FROM archivos_informe
WHERE archivo = @nkey) BEGIN
SET @nkey = 0
END
END
/*
select @nkey as nkey
*/
return @nkey
/* SET @informe = @nkey*/
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.Genera_ID_Archivo
AS
BEGIN
SET NOCOUNT ON;
DECLARE @nkey int
SET @nkey = 0
WHILE @nkey = 0 BEGIN
SET @nkey = convert(int,rand()*10000000)
IF EXISTS (SELECT archivo FROM archivos_informe
WHERE archivo = @nkey) BEGIN
SET @nkey = 0
END
END
/*
select @nkey as nkey
*/
return @nkey
/* SET @informe = @nkey*/
END
GO