CREATE TRIGGER [dbo].[DealInsert]
ON [dbo].[AllDeals]
AFTER INSERT
AS 
BEGIN   
    SET NOCOUNT ON;
    -- update your table, using a set-based approach
    -- from the "Inserted" pseudo table which CAN and WILL
    -- contain multiple rows!
    UPDATE [dbo].[AllDeals] 
    SET  [DateTorg] = dateadd( dd, datediff(dd, '19000101', getdate()), i.TimeTorg ) 
    FROM Inserted i
    WHERE id = i.id
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[DealsInsert1]
ON [dbo].[AllDeals]
instead of insert
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

INSERT INTO AllDeals(Num, Security, Price, Quantity, Operation, DateTorg)
SELECT Num, Security,Price, Quantity, Operation, CAST(getdate() AS datetime) + CAST(TimeTorg AS datetime)
FROM INSERTED
END
GO