alter table filial add inscMunicip char(20)
go
alter table filial add deposito char(1)
go
alter table filial add crt char(1)
go
update filial set crt='3', deposito='0'
go
drop table empresa
go
ALTER Procedure [dbo].[SP_MANIPULA_ID_DEV_VENDA](@ID Int OUTPUT)as begin	
IF not EXISTS (SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U' AND NAME = 'DEV_VENDA_ID')	
BEGIN        
CREATE TABLE DEV_VENDA_ID (NEW_ID int NOT NULL PRIMARY KEY, NEW_ID_DEV_VENDA int NULL)	   
 Insert into DEV_VENDA_ID (NEW_ID) values(0)	   
 Update DEV_VENDA_ID Set NEW_ID = (Select COALESCE(max(idDevolucao),0) + 1 from devolucao)	
 END	
 BEGIN TRANSACTION; Select @ID = NEW_ID From DEV_VENDA_ID With (UPDLOCK, HOLDLOCK) WAITFOR DELAY '00:00:01.0';	
 Update DEV_VENDA_ID Set NEW_ID = NEW_ID + 1;COMMIT;end
go
 Update DEV_VENDA_ID Set NEW_ID = (Select COALESCE(max(idDevolucao),0) + 1 from devolucao)
 go
 ALTER Procedure [dbo].[SP_MANIPULA_ID_VENDA](@ID Int OUTPUT)as 
begin	
IF not EXISTS (SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U' AND NAME = 'PEDIDO_VENDA_ID')	BEGIN        
CREATE TABLE PEDIDO_VENDA_ID (NEW_ID int NOT NULL PRIMARY KEY, NEW_ID_PRE_VENDA int NULL)	    
Insert into PEDIDO_VENDA_ID (NEW_ID) values(0)	    
Update PEDIDO_VENDA_ID Set NEW_ID = (Select COALESCE(max(idvenda),0) + 1 from venda)	    
Insert into PEDIDO_VENDA_ID (NEW_ID_PRE_VENDA) values(0)	    
Update PEDIDO_VENDA_ID Set NEW_ID_PRE_VENDA = (Select COALESCE(max(numeropv),0) + 1 from venda)	
END	
Select @ID = NEW_ID From PEDIDO_VENDA_ID With (UPDLOCK, HOLDLOCK) WAITFOR DELAY '00:00:00.100';	Update PEDIDO_VENDA_ID Set NEW_ID = NEW_ID + 1;
end
go
Update PEDIDO_VENDA_ID Set NEW_ID = (Select COALESCE(max(idvenda),0) + 1 from venda)
go
Update PEDIDO_VENDA_ID Set NEW_ID_PRE_VENDA = (Select COALESCE(max(numeropv),0) + 1 from venda)