USE [ebiddingkazak]
GO
/****** Object:  Trigger [dbo].[tri_order_State]    Script Date: 08/10/2015 10:29:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Trigger [dbo].[tri_order_State]
  on [dbo].[ebidding_order]
  for insert,update
  as
  declare @oid int
  declare @customer int
  declare @customerName nvarchar(120)
  declare @handler int
  declare @business int
  declare @type smallint
  declare @state smallint
  declare @progress smallint
  declare @stime datetime
  declare @code varchar(30)
  declare @name nvarchar(20)
  declare @intro nvarchar(max)
  declare @notes nvarchar(max)
  declare @files nvarchar(max)
  declare @amount float
  declare @budget float
  declare @branch int
  declare @projectNo varchar(40)
  declare @projectOwner int
  declare @productLines varchar(100)
  declare @productLineOther nvarchar(100)
  declare @contact nvarchar(60)
  declare @startDate datetime
  declare @dueDate datetime
  declare @creator int
  declare @created datetime
  declare @sended datetime
  declare @finished datetime
  declare @remark nvarchar(max)
  declare @productionTeam nvarchar(max)
  declare @mode int
  declare @tax float
  declare @vendorGroup int
  declare @terminalReasons varchar(50)
  declare @approving datetime
  declare @vendorInviter int
  declare @biddingApplicant int
  declare @biddingApproval int
  declare @country int
  declare @getNewTime datetime
 
  --获取order 表中的数据
    if UPDATE([state])
    begin
       begin
          select @oid=oid,@customer=customer,@customerName=customerName,@handler=handler,
          @business=business,@type=[type],@state=[state],@progress=progress,@stime=stime,
          @code=code,@name=name,@intro=intro,@notes=notes,@files=files,@amount=amount,
          @budget=budget,@branch=branch,@projectNo=projectNo,@projectOwner=projectOwner,
          @productLines=productLines,@productLineOther=productLineOther,@contact=contact,
          @startDate=startDate,@dueDate=dueDate,@creator=creator,@created=created,
          @sended=sended,@finished=finished,@remark=remark,@productionTeam=productionTeam,
          @mode=mode,@tax=tax,@vendorGroup=vendorGroup,@terminalReasons=terminalReasons,
          @approving=approving,@vendorInviter=vendorInviter,@biddingApplicant=biddingApplicant,
          @biddingApproval=biddingApproval,@country=country,@getNewTime=dateadd(HOUR,0,CURRENT_TIMESTAMP) from inserted;
       
          insert into dbo.ebidding_order_history
          (oid, customer, customerName, handler, business, type, state, progress, stime, code, name, intro, notes, files, amount, budget, branch, projectNo, projectOwner, productLines, productLineOther, contact, startDate, dueDate, creator, created, sended, finished, remark, productionTeam, mode, tax, vendorGroup, terminalReasons, approving, vendorInviter, biddingApplicant, biddingApproval, country, getNewTime)
          values
          (@oid,@customer,@customerName,@handler,@business,@type,@state,@progress,@stime,@code,@name,@intro,@notes,@files,@amount,@budget,@branch,@projectNo,@projectOwner,@productLines,@productLineOther,@contact,@startDate,@dueDate,@creator,@created,@sended,@finished,@remark,@productionTeam,@mode,@tax,@vendorGroup,@terminalReasons,@approving,@vendorInviter,@biddingApplicant,@biddingApproval,@country,@getNewTime)
      end  
  end
 
求大神，看一下有什么问题没？

在我这不知道为什么会有空的记录添加到dbo.ebidding_order_history表中,求大神指教！