Sql Server trigger insert values from new row into another table

by

try this for sql server

CREATE TRIGGER yourNewTrigger ON yourSourcetable
FOR INSERT
AS

INSERT INTO yourDestinationTable
        (col1, col2    , col3, user_id, user_name)
    SELECT
        'a'  , default , null, user_id, user_name
        FROM inserted

go

More Related Contents:

  1. Create Trigger to log SQL that affected table?
  2. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  3. Need to list all triggers in SQL Server database with table name and table’s schema
  4. How can I do a BEFORE UPDATED trigger with sql server?
  5. SQL Server Update Trigger, Get Only modified fields
  6. How do I prevent a database trigger from recursing?
  7. SQL update trigger only when column is modified
  8. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  9. How can I do an UPDATE statement with JOIN in SQL Server?
  10. Why does NULL = NULL evaluate to false in SQL server
  11. The multi-part identifier could not be bound
  12. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  13. SQL – How to store and navigate hierarchies?
  14. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  15. Fastest way to update 120 Million records
  16. how can I Update top 100 records in sql server
  17. Count Number of Consecutive Occurrence of values in Table
  18. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  19. How can I compare time in SQL Server?
  20. SQL – Difference between COALESCE and ISNULL? [duplicate]
  21. SQL: capitalize first letter only [duplicate]
  22. Getting the Id of a row I updated in Sql Server
  23. Backup a single table with its data from a database in sql server 2008
  24. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  25. COALESCE Function in TSQL
  26. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  27. Try_Convert for SQL Server 2008 R2
  28. SQL Server variable scope in a stored procedure
  29. SQL Sort Order with Null values last
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment