<div>
The basic problem is: Triggers are called per statement. Thus the virtual tables. 
&nbsp; 
Currently you only work with arbitrary values. 
 
This should do it: 
 

<pre><code id="code-20-43102818-1">ALTER TRIGGER [dbo].[AfterUPDATETrigger] ON [dbo].[Datatable]
FOR UPDATE
AS

SET NOCOUNT ON;

INSERT INTO Datatableb(colz,colx)
SELECT I.ColB, I.ColA
FROM INSERTED I
WHERE I.ColB = 'd';</code></pre>
</div>

The basic problem is: Triggers are called per statement. Thus the virtual tables.
 
Currently you only work with arbitrary values.

This should do it:



ALTER TRIGGER [dbo].[AfterUPDATETrigger] ON [dbo].[Datatable]
FOR UPDATE
AS

SET NOCOUNT ON;

INSERT INTO Datatableb(colz,colx)
SELECT  I.ColB, I.ColA
FROM    INSERTED I
WHERE   I.ColB = 'd';

<div>
<div class="content wysiwyg-content">
Here is my code for SQL trigger 
 
 
ALTER TRIGGER [dbo].[AfterUPDATETrigger] on [dbo].[Datatable] 
FOR UPDATE 
AS DECLARE @cola int,@Colb nvarchar(10) 
 
SELECT @cola = ins.cola from inserted ins 
SELECT @Colb = ins.colb from inserted ins 
 
IF @colb ='d' 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BEGIN 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INSERT INTO Datatableb(colz,colx) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES(@colb,@cola) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;END 
 
This is the data in Datatable 
Cola &nbsp;colb &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;colc 
1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30 
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30 
3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30 
 
If I update colb = d where colc = 30 
I only insert 1 row into datatableB 
I want to get all 3 updates to be entered into datatableb
</div>
</div>

Here is my code for SQL trigger


ALTER TRIGGER [dbo].[AfterUPDATETrigger] on [dbo].[Datatable]
FOR UPDATE 
AS DECLARE @cola int,@Colb nvarchar(10)

SELECT @cola = ins.cola from inserted ins
SELECT @Colb = ins.colb from inserted ins

IF @colb ='d'
	BEGIN
		INSERT INTO Datatableb(colz,colx)
		VALUES(@colb,@cola)
	END

This is the data in Datatable
Cola  colb	colc
1	a         	30
2	a         	30
3	a         	30

If I update colb = d where colc = 30
I only insert 1 row into datatableB
I want to get all 3 updates to be entered into datatableb

SQL trigger update insert records

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.