ALTER PROCEDURE dbo.spFormDocTovar
AS 
SET NOCOUNT ON 
SELECT     dbo.tabDocTovar.*, dbo.tabTovarCard.colIntKT AS Tovar
FROM         dbo.tabDocTovar INNER JOIN
                      dbo.tabTovarCard ON dbo.tabDocTovar.colIntCard = dbo.tabTovarCard.colIntCode AND 
                      dbo.tabDocTovar.colTIntDiv = dbo.tabTovarCard.colTIntDiv
WHERE     (dbo.tabDocTovar.colTIntDiv =  1 ) AND (dbo.tabDocTovar.colIntDoc =  30610 )

tabDocTovar

SELECT     dbo.tabDocTovar.*, dbo.tabTovarCard.colIntKT AS Tovar
FROM         dbo.tabDocTovar INNER JOIN
                      dbo.tabTovarCard ON dbo.tabDocTovar.colIntCard = dbo.tabTovarCard.colIntCode AND 
                      dbo.tabDocTovar.colTIntDiv = dbo.tabTovarCard.colTIntDiv
WHERE     (dbo.tabDocTovar.colTIntDiv = ?) AND (dbo.tabDocTovar.colIntDoc = ?)

SET NO_BROWSETABLE OFF
go
EXEC sp_MShelpcolumns N'dbo.tabDocTovar' , NULL, 'id',  1 
go
EXEC sp_MShelpcolumns N'dbo.tabTovarCard' , NULL, 'id',  1 
go
SELECT IDENT_SEED('tabDocTovar')
go
SELECT IDENT_INCR('tabDocTovar')
go
SET FMTONLY ON select  "colIntDoc" , "colIntCard" , "colNumKorPlan" , "colNumEd" , "colNumKor" , "colMonCena" , "colVchGTD" , "colTIntDiv" , "colMonCenaIn" , "colBitVal"  from dbCyros.dbo. "tabDocTovar"  SET FMTONLY OFF
go
SET NO_BROWSETABLE ON
go
declare @P1 int
set @P1= 63 
exec sp_prepare @P1 output, N'@P1 int,@P2 int,@P3 numeric(14,6),@P4 numeric(10,3),@P5 numeric(14,6),@P6 money,@P7 varchar(30),@P8 tinyint,@P9 money,@P10 bit', N'INSERT INTO dbCyros.dbo."tabDocTovar"("colIntDoc", "colIntCard", "colNumKorPlan", "colNumEd", "colNumKor", "colMonCena", "colVchGTD", "colTIntDiv", "colMonCenaIn", "colBitVal")  VALUES(@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10)',  1 
select @P1
go
exec sp_execute  63 ,  30610 ,  3088 , NULL, NULL, NULL, NULL, NULL,  1 , NULL, NULL
go
SET NO_BROWSETABLE OFF
go
select @@identity
go
SET NO_BROWSETABLE ON
go
exec sp_executesql N'UPDATE "dbCyros"."dbo"."tabTovarCard" SET "colIntKT"=@P1 WHERE "colIntKT" IS NULL AND "colIntCode"=@P2 AND "colTIntDiv"=@P3', N'@P1 int,@P2 int,@P3 tinyint',  1 ,  0 ,  0 
go
exec sp_executesql N'SELECT * FROM         dbo.tabDocTovar  WHERE     (dbo.tabDocTovar.colIntCode = @P1) and  (dbo.tabDocTovar.colTIntDiv = @P2)', N'@P1 int,@P2 tinyint',  208784 ,  1 
go
exec sp_executesql N'SELECT * FROM         dbo.tabDocTovar  WHERE     (dbo.tabDocTovar.colIntCode = @P1) and  (dbo.tabDocTovar.colTIntDiv = @P2)', N'@P1 int,@P2 tinyint',  208784 ,  1 
go