Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how insert data using triggers

Author  Topic 

kallu
Starting Member

6 Posts

Posted - 2007-09-22 : 06:25:42

hi,
i never used triggers. My problem is:
1. i have 2 tables (tab1,tab2)(same no of columns)
2. in case if am going to insert data in tab1 then automatically reflects(insert) same data in tab2 .

for this scenario i am trying to write insert triggers for tab1.

if it good then
plz send trigger query for above scenario.
otherwise
give me suggestion.




Kristen
Test

22859 Posts

Posted - 2007-09-22 : 06:33:26
See code example via the FAQ in: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Triggers,Trigger,audit%20changes

Kristen
Go to Top of Page
   

- Advertisement -