Trigger-SQL Server 7 - SQL Server Forums

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 2000 Forums

SQL Server Development (2000)

Trigger-SQL Server 7

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-22 : 09:38:29

kim writes "I have imported new data into Table1, using a insert sql command

Table1 has a trigger attached to it that looks like this:

CREATE TRIGGER tr_table2Upd ON dbo.table1

FOR UPDATE AS

declare @clientname varchar(50)
declare @clientname2 varchar(50)
declare @ClientNameDBA varchar(50)
declare @ShortName varchar(15)
declare @ClientLastName varchar(30)
declare @ClientFirstName varchar(30)
declare @ClientTitle varchar(15)
declare @ClientSalutation varchar(8)
declare @ClientDegree varchar(10)
declare @ClientStreetNo varchar(10)
declare @ClientStreetType varchar(10)
declare @ClientStreetApt varchar(10)
declare @ClientAddress varchar(35)
declare @ClientCity int
declare @ClientState varchar(2)
declare @ClientZip varchar(10)
declare @ClientSalesRep int
declare @ClientHomeAddress varchar(35)
declare @ClientHomeStreetNo varchar(10)
declare @ClientHomeStreetType varchar(10)
declare @ClientHomeStreetApt varchar(10)
declare @ClientHomeCity varchar(25)
declare @ClientHomeState varchar(2)
declare @ClientHomeZip varchar(10)
declare @ClientPhone varchar(10)
declare @ClientFax varchar(10)
declare @ClientHome varchar(10)
declare @ClientPager varchar(10)
declare @DBDuns varchar(12)
declare @ClientFTPSite varchar(255)
declare @ClientMailBox varchar(255)
declare @SicCode varchar(10)
declare @leadid int

select @leadid=LeadID, @ClientName = clientName,@ClientName2=ClientName2, @ClientNameDBA=ClientNameDBA,
@ShortName=ShortName, @ClientLastName=ClientLastName, @ClientFirstName=ClientfirstName, @ClientTitle=ClientTitle,
@ClientSalutation=ClientSalutation, @ClientDegree=ClientDegree, @ClientAddress=ClientAddress, @ClientStreetNo=ClientStreetNo,
@ClientStreetType=ClientStreetType, @ClientStreetApt=ClientStreetApt, @ClientCity=ClientCity, @ClientState=ClientState,
@ClientZip=ClientZip, @ClientHomeAddress=ClientHomeAddress, @ClientHomeStreetNo=ClientHomeStreetNo,
@ClientHomeStreetType=ClientHomeStreetType, @ClientHomeStreetApt=ClientHomeStreetApt,
@ClientHomeCity=ClientHomeCity, @ClientHomeState=ClientHomeState, @ClientHomeZip=ClientHomeZip,
@ClientPhone=ClientPhone, @ClientFax=ClientFax, @ClientHome=ClientHome, @ClientSalesRep=ClientSalesRep,
@ClientPager=ClientPager, @DBDuns=DBDuns, @ClientFTPSite=ClientFTPSite, @ClientMailBox=ClientMailBox, @SicCode=SicNo
from inserted

/* Updating table2 */

update table2
set ClientName = @clientName,ClientName2=@ClientName2, ClientNameDBA=@ClientNameDBA,
ShortName=@ShortName, ClientLastName=@ClientLastName, ClientFirstName=@ClientfirstName, ClientTitle=@ClientTitle,
ClientSalutation=@ClientSalutation, ClientDegree=@ClientDegree, ClientAddress=@ClientAddress, ClientStreetNo=@ClientStreetNo,
ClientStreetType=@ClientStreetType, ClientStreetApt=@ClientStreetApt, ClientCity=@ClientCity, ClientState=@ClientState,
ClientZip=@ClientZip, ClientHomeAddress=@ClientHomeAddress, ClientHomeStreetNo=@ClientHomeStreetNo,
ClientHomeStreetType=@ClientHomeStreetType, ClientHomeStreetApt=@ClientHomeStreetApt,
ClientHomeCity=@ClientHomeCity,ClientHomeState=@ClientHomeState, ClientHomeZip=@ClientHomeZip,
ClientPhone=@ClientPhone, ClientFax=@ClientFax, ClientHome=@ClientHome, ClientSalesRep=@ClientSalesRep,
ClientPager=@ClientPager, DBDuns=@DBDuns, ClientFTPSite=@ClientFTPSite, ClientMailBox=@ClientMailBox, SicCode=@SicCode

where LeadId=@LeadID

But after I import the data into table1, the trigger does not fire the new data into table2....how come ?

Extremely frustrated, and would be very thankful for a response

Thank you"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources