Table temporary - extract

gistfile1.sql

USE sara_db
go
CREATE TABLE dbo.tab_tmp_doc_entrada_comp
(
    dent_com_id         int           NOT NULL,
    dent_id             char(30)      COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    cid_id              int           NULL,
    dent_com_ie         char(25)      COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    dent_com_total_ipi  numeric(18,4) NOT NULL,
    dent_com_total_icms numeric(18,4) NOT NULL,
    dent_com_total_vlr  numeric(18,4) NOT NULL,
    CONSTRAINT pk_tab_tmp_doc_entrada_comp
    PRIMARY KEY CLUSTERED (dent_com_id)
)
go
IF OBJECT_ID('dbo.tab_tmp_doc_entrada_comp') IS NOT NULL
    PRINT '<<< CREATED TABLE dbo.tab_tmp_doc_entrada_comp >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE dbo.tab_tmp_doc_entrada_comp >>>'
go
GRANT DELETE ON dbo.tab_tmp_doc_entrada_comp TO Usuarios
go
GRANT INSERT ON dbo.tab_tmp_doc_entrada_comp TO Usuarios
go
GRANT REFERENCES ON dbo.tab_tmp_doc_entrada_comp TO Usuarios
go
GRANT SELECT ON dbo.tab_tmp_doc_entrada_comp TO Usuarios
go
GRANT UPDATE ON dbo.tab_tmp_doc_entrada_comp TO Usuarios
go