写sql触发器报错了，求助

allenpang 2008-12-04 07:30:06
USE [TDTClub]
GO
/****** 对象: Trigger [dbo].[CreateTDTDBMember] 脚本日期: 12/04/2008 18:56:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create TRIGGER Club_Membersbak_insert
ON [dbo].[Club_Members]
FOR INSERT
AS
set ANSI_NULLS ON
set ANSI_WARNINGS ON
declare @MemberId varchar(10);
　　declare @Password varchar(50);　　declare @Status bit;
declare @IsFounder bit;
declare @MemberType tinyint;
declare @NameGB varchar(20);
declare @Gender varchar(10);
declare @DOB varchar(50);
declare @IDCardNo varchar(20);
declare @AccountAddress varchar(100);
declare @HomeAddress varchar(100);
declare @PostCode varchar(10);
declare @TelHome varchar(20);
declare @TelOffice varchar(20);
declare @Cell varchar(20);
declare @Company varchar(50);
declare @Department varchar(20);
declare @Salary varchar(20);
declare @NameEN varchar(30);
declare @Email varchar(200);
declare @Marriage varchar(10);
declare @ParentName varchar(30);
declare @ParentAddress varchar(100);
declare @ParentTel varchar(20);
declare @ContactName varchar(30);
declare @ContactTel varchar(20);
declare @ContactRelation varchar(20);
declare @EnglishLevel varchar(10);
declare @ValidDate smalldatetime;
declare @ValidDateFrom smalldatetime;
declare @LeadsId varchar(10);
declare @SourceCode varchar(30);
declare @RefId varchar(20);
declare @RefMemberId varchar(10);
declare @RecMail bit;
declare @RecSms bit;
declare @SalesCode varchar(20);
declare @Demo varchar(200);
declare @KeyInBy varchar(20);
declare @DateAdded datetime;
declare @Points int;
declare @LogInCount int;
declare @TimeLastLogIn datetime;
declare @NO varchar(50);
declare @To varchar(50);
declare @Certification varchar(250);
declare @TotalPrice decimal(182);
declare @Installments int;
declare @InitialPayment decimal(182);
declare @PayDate varchar(50);
declare @PayBy varchar(10);
declare @PayFrom varchar(50);
declare @PayTo varchar(50);
declare @PerMonthPrice decimal(182);
declare @SignDate varchar(50);
declare @EcName varchar(50);
declare @SrcID varchar(50);
declare @SrcNotes varchar(255);
declare @LevelTestDate varchar(20);
declare @DeliveryDate varchar(20);
declare @ConfirmDate varchar(20);
declare @DeliveryADD varchar(250);
declare @PayStatus varchar(50);
declare @MMA bit;
declare @MMADate varchar(20);
declare @CrewNo varchar(50);
declare @Size varchar(20);
declare @Employ varchar(50);
declare @Cumulative decimal(182);
declare @Periods int;
declare @ArrearageDate varchar(20);
declare @M int;
declare @ContactRelation1 varchar(20);
declare @Rcell varchar(50);
declare @OldElevel varchar(10);
declare @FILENAME varchar(50);
declare @FILEVISUALPATH varchar(255);
declare @MemberSort varchar(50);
declare @TalkFamilyID int;
declare @FamilyGradeID int;
begin
　　select @MemberId=MemberId,@Password=Password,@Status=Status,@IsFounder=IsFounder,@MemberType=MemberType, @NameGB=NameGB,@Gender=Gender,@DOB=DOB,@IDCardNo=IDCardNo,@AccountAddress=AccountAddress,
@HomeAddress=HomeAddress,@PostCode=PostCode,@TelHome=TelHome,@IsFounder=IsFounder,@Cell=Cell,
@Company=Company,@Department=Department,@Salary=Salary,@NameEN=NameEN,@Email=Email,
@Marriage=Marriage,@ParentName=ParentName,@ParentAddress=ParentAddress,@ParentTel=ParentTel,@ContactName=ContactName,
@ContactTel=ContactTel,@ContactRelation=ContactRelation,@EnglishLevel=EnglishLevel,@ValidDate=ValidDate,@ValidDateFrom=ValidDateFrom,
@LeadsId=LeadsId,@SourceCode=SourceCode,@RefId=RefId,@RefMemberId=RefMemberId,@RecMail=RecMail,
@RecSms=RecSms,@SalesCode=SalesCode,@Demo=Demo,@KeyInBy=KeyInBy,@DateAdded=DateAdded,
@Points=Points,@LogInCount=LogInCount,@TimeLastLogIn=TimeLastLogIn,@NO=[NO],@To=[To],
@Certification=Certification,@TotalPrice=TotalPrice,@Installments=Installments,@InitialPayment=InitialPayment,@PayDate=PayDate,
@PayBy=PayBy,@PayFrom=PayFrom,@PayTo=PayTo,@PerMonthPrice=PerMonthPrice,@SignDate=SignDate,
@EcName=EcName,@SrcID=SrcID,@SrcNotes=SrcNotes,@LevelTestDate=LevelTestDate,@DeliveryDate=DeliveryDate,
@ConfirmDate=ConfirmDate,@DeliveryADD=DeliveryADD,@PayStatus=PayStatus,@MMA=MMA,@MMADate=MMADate,
@CrewNo=CrewNo,@Size=[Size],@Employ=Employ,@Cumulative=Cumulative,@Periods=Periods,
@ArrearageDate=ArrearageDate,@M=M,@ContactRelation1=ContactRelation1,@Rcell=Rcell,@OldElevel=OldElevel,
@FILENAME=[FILENAME],@FILEVISUALPATH=FILEVISUALPATH,@MemberSort=MemberSort,@TalkFamilyID=TalkFamilyID,@FamilyGradeID=FamilyGradeID from inserted
　　if @MemberId<>0　　begin
　　insert into [Club_Membersbak]
([MemberId]
,[Password]
,[Status]
,[IsFounder]
,[MemberType]
,[NameGB]
,[Gender]
,[DOB]
,[IDCardNo]
,[AccountAddress]
,[HomeAddress]
,[PostCode]
,[TelHome]
,[TelOffice]
,[Cell]
,[Company]
,[Department]
,[Salary]
,[NameEN]
,[Email]
,[Marriage]
,[ParentName]
,[ParentAddress]
,[ParentTel]
,[ContactName]
,[ContactTel]
,[ContactRelation]
,[EnglishLevel]
,[ValidDate]
,[ValidDateFrom]
,[LeadsId]
,[SourceCode]
,[RefId]
,[RefMemberId]
,[RecMail]
,[RecSms]
,[SalesCode]
,[Demo]
,[KeyInBy]
,[DateAdded]
,[Points]
,[LogInCount]
,[TimeLastLogIn]
,[NO]
,[To]
,[Certification]
,[TotalPrice]
,[Installments]
,[InitialPayment]
,[PayDate]
,[PayBy]
,[PayFrom]
,[PayTo]
,[PerMonthPrice]
,[SignDate]
,[EcName]
,[SrcID]
,[SrcNotes]
,[LevelTestDate]
,[DeliveryDate]
,[ConfirmDate]
,[DeliveryADD]
,[PayStatus]
,[MMA]
,[MMADate]
,[CrewNo]
,[Size]
,[Employ]
,[Cumulative]
,[Periods]
,[ArrearageDate]
,[M]
,[ContactRelation1]
,[Rcell]
,[OldElevel]
,[FILENAME]
,[FILEVISUALPATH]
,[MemberSort]
,[TalkFamilyID]
,[FamilyGradeID])
values(@MemberId,@Password,@Status,@IsFounder,@MemberType,
@NameGB,@Gender,@DOB,@IDCardNo,@AccountAddress,
@HomeAddress,@PostCode,@TelHome,@TelOffice,@Cell,
@Company,@Department,@Salary,@NameEN,@Email,
@Marriage,@ParentName,@ParentAddress,@ParentTel,@ContactName,
@ContactTel,@ContactRelation,@EnglishLevel,@ValidDate,@ValidDateFrom,
@LeadsId,@SourceCode,@RefId,@RefMemberId,@RecMail,
@RecSms,@SalesCode,@Demo,@KeyInBy,@DateAdded,
@Points,@LogInCount,@TimeLastLogIn,@NO,@To,
@Certification,@TotalPrice,@Installments,@InitialPayment,@PayDate,
@PayBy,@PayFrom,@PayTo,@PerMonthPrice,@SignDate,
@EcName,@SrcID,@SrcNotes,@LevelTestDate,@DeliveryDate,
@ConfirmDate,@DeliveryADD,@PayStatus,@MMA,@MMADate,
@CrewNo,@Size,@Employ,@Cumulative,@Periods,
@ArrearageDate,@M,@ContactRelation1,@Rcell,@OldElevel,
@FILENAME,@FILEVISUALPATH,@MemberSort,@TalkFamilyID,@FamilyGradeID)
　　end　　end


红色部分报错
...全文
917 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
-狙击手- 2008-12-05
  • 打赏
  • 举报
 回复
decimal(182)

---
decimal(12,2)
nalnait 2008-12-05
  • 打赏
  • 举报
 回复 




create TRIGGER  Club_Membersbak_insert 

ON [dbo].[Club_Members] 

FOR INSERT 

AS 

set ANSI_NULLS ON 

set ANSI_WARNINGS ON 

declare @MemberId varchar(10) 

declare @Password varchar(50) 

declare @Status bit 

    declare @IsFounder bit 

    declare @MemberType tinyint 

    declare @NameGB varchar(20) 

    declare @Gender  varchar(10) 

    declare @DOB varchar(50) 

    declare @IDCardNo varchar(20) 

    declare @AccountAddress varchar(100) 

    declare @HomeAddress varchar(100) 

    declare @PostCode varchar(10) 

    declare @TelHome varchar(20) 

    declare @TelOffice varchar(20) 

declare @Cell varchar(20) 

declare @Company varchar(50) 

declare @Department varchar(20) 

declare @Salary varchar(20) 

declare @NameEN varchar(30) 

declare @Email varchar(200) 

declare @Marriage varchar(10) 

declare @ParentName varchar(30) 

declare @ParentAddress varchar(100) 

declare @ParentTel varchar(20) 

declare @ContactName varchar(30) 

declare @ContactTel varchar(20) 

declare @ContactRelation varchar(20) 

declare @EnglishLevel varchar(10) 

declare @ValidDate smalldatetime 

declare @ValidDateFrom smalldatetime 

declare @LeadsId varchar(10) 

declare @SourceCode varchar(30) 

declare @RefId varchar(20) 

declare @RefMemberId varchar(10) 

declare @RecMail bit 

declare @RecSms bit 

declare @SalesCode varchar(20) 

declare @Demo varchar(200) 

declare @KeyInBy varchar(20) 

declare @DateAdded datetime 

declare @Points int 

declare @LogInCount int 

declare @TimeLastLogIn datetime 

declare @NO varchar(50) 

declare @To varchar(50) 

declare @Certification varchar(250) 

declare @TotalPrice decimal(38) 

declare @Installments int 

declare @InitialPayment decimal(38) 

declare @PayDate varchar(50) 

declare @PayBy varchar(10) 

declare @PayFrom varchar(50) 

declare @PayTo varchar(50) 

declare @PerMonthPrice decimal(38) 

declare @SignDate varchar(50) 

declare @EcName varchar(50) 

declare @SrcID varchar(50) 

declare @SrcNotes varchar(255) 

declare @LevelTestDate varchar(20) 

declare @DeliveryDate varchar(20) 

declare @ConfirmDate varchar(20) 

declare @DeliveryADD varchar(250) 

declare @PayStatus varchar(50) 

declare @MMA bit 

declare @MMADate varchar(20) 

declare @CrewNo varchar(50) 

declare @Size varchar(20) 

declare @Employ varchar(50) 

declare @Cumulative decimal(38) 

declare @Periods int 

declare @ArrearageDate varchar(20) 

declare @M int 

declare @ContactRelation1 varchar(20) 

declare @Rcell varchar(50) 

declare @OldElevel varchar(10) 

declare @FILENAME varchar(50) 

declare @FILEVISUALPATH varchar(255) 

declare @MemberSort varchar(50) 

declare @TalkFamilyID int 

declare @FamilyGradeID int 

begin 

select @MemberId=MemberId,@Password=Password,@Status=Status,@IsFounder=IsFounder,@MemberType=MemberType,  @NameGB=NameGB,@Gender=Gender,@DOB=DOB,@IDCardNo=IDCardNo,@AccountAddress=AccountAddress, 

          @HomeAddress=HomeAddress,@PostCode=PostCode,@TelHome=TelHome,@IsFounder=IsFounder,@Cell=Cell, 

          @Company=Company,@Department=Department,@Salary=Salary,@NameEN=NameEN,@Email=Email, 

          @Marriage=Marriage,@ParentName=ParentName,@ParentAddress=ParentAddress,@ParentTel=ParentTel,@ContactName=ContactName, 

          @ContactTel=ContactTel,@ContactRelation=ContactRelation,@EnglishLevel=EnglishLevel,@ValidDate=ValidDate,@ValidDateFrom=ValidDateFrom, 

  @LeadsId=LeadsId,@SourceCode=SourceCode,@RefId=RefId,@RefMemberId=RefMemberId,@RecMail=RecMail, 

  @RecSms=RecSms,@SalesCode=SalesCode,@Demo=Demo,@KeyInBy=KeyInBy,@DateAdded=DateAdded, 

  @Points=Points,@LogInCount=LogInCount,@TimeLastLogIn=TimeLastLogIn,@NO=[NO],@To=[To], 

  @Certification=Certification,@TotalPrice=TotalPrice,@Installments=Installments,@InitialPayment=InitialPayment,@PayDate=PayDate, 

  @PayBy=PayBy,@PayFrom=PayFrom,@PayTo=PayTo,@PerMonthPrice=PerMonthPrice,@SignDate=SignDate, 

  @EcName=EcName,@SrcID=SrcID,@SrcNotes=SrcNotes,@LevelTestDate=LevelTestDate,@DeliveryDate=DeliveryDate, 

  @ConfirmDate=ConfirmDate,@DeliveryADD=DeliveryADD,@PayStatus=PayStatus,@MMA=MMA,@MMADate=MMADate, 

  @CrewNo=CrewNo,@Size=[Size],@Employ=Employ,@Cumulative=Cumulative,@Periods=Periods, 

  @ArrearageDate=ArrearageDate,@M=M,@ContactRelation1=ContactRelation1,@Rcell=Rcell,@OldElevel=OldElevel, 

  @FILENAME=[FILENAME],@FILEVISUALPATH=FILEVISUALPATH,@MemberSort=MemberSort,@TalkFamilyID=TalkFamilyID,@FamilyGradeID=FamilyGradeID 

from inserted 

if @MemberId <>0 

begin 

insert into [Club_Membersbak] 

          ([MemberId] 

          ,[Password] 

          ,[Status] 

          ,[IsFounder] 

          ,[MemberType] 

          ,[NameGB] 

          ,[Gender] 

          ,[DOB] 

          ,[IDCardNo] 

          ,[AccountAddress] 

          ,[HomeAddress] 

          ,[PostCode] 

          ,[TelHome] 

          ,[TelOffice] 

          ,[Cell] 

          ,[Company] 

          ,[Department] 

          ,[Salary] 

          ,[NameEN] 

          ,[Email] 

          ,[Marriage] 

          ,[ParentName] 

          ,[ParentAddress] 

          ,[ParentTel] 

          ,[ContactName] 

          ,[ContactTel] 

          ,[ContactRelation] 

          ,[EnglishLevel] 

          ,[ValidDate] 

          ,[ValidDateFrom] 

          ,[LeadsId] 

          ,[SourceCode] 

          ,[RefId] 

          ,[RefMemberId] 

          ,[RecMail] 

          ,[RecSms] 

          ,[SalesCode] 

          ,[Demo] 

          ,[KeyInBy] 

          ,[DateAdded] 

          ,[Points] 

          ,[LogInCount] 

          ,[TimeLastLogIn] 

          ,[NO] 

          ,[To] 

          ,[Certification] 

          ,[TotalPrice] 

          ,[Installments] 

          ,[InitialPayment] 

          ,[PayDate] 

          ,[PayBy] 

          ,[PayFrom] 

          ,[PayTo] 

          ,[PerMonthPrice] 

          ,[SignDate] 

          ,[EcName] 

          ,[SrcID] 

          ,[SrcNotes] 

          ,[LevelTestDate] 

          ,[DeliveryDate] 

          ,[ConfirmDate] 

          ,[DeliveryADD] 

          ,[PayStatus] 

          ,[MMA] 

          ,[MMADate] 

          ,[CrewNo] 

          ,[Size] 

          ,[Employ] 

          ,[Cumulative] 

          ,[Periods] 

          ,[ArrearageDate] 

          ,[M] 

          ,[ContactRelation1] 

          ,[Rcell] 

          ,[OldElevel] 

          ,[FILENAME] 

          ,[FILEVISUALPATH] 

          ,[MemberSort] 

          ,[TalkFamilyID] 

          ,[FamilyGradeID]) 

values(@MemberId,@Password,@Status,@IsFounder,@MemberType, 

  @NameGB,@Gender,@DOB,@IDCardNo,@AccountAddress, 

  @HomeAddress,@PostCode,@TelHome,@TelOffice,@Cell, 

  @Company,@Department,@Salary,@NameEN,@Email, 

  @Marriage,@ParentName,@ParentAddress,@ParentTel,@ContactName, 

  @ContactTel,@ContactRelation,@EnglishLevel,@ValidDate,@ValidDateFrom, 

  @LeadsId,@SourceCode,@RefId,@RefMemberId,@RecMail, 

  @RecSms,@SalesCode,@Demo,@KeyInBy,@DateAdded, 

  @Points,@LogInCount,@TimeLastLogIn,@NO,@To, 

  @Certification,@TotalPrice,@Installments,@InitialPayment,@PayDate, 

  @PayBy,@PayFrom,@PayTo,@PerMonthPrice,@SignDate, 

  @EcName,@SrcID,@SrcNotes,@LevelTestDate,@DeliveryDate, 

  @ConfirmDate,@DeliveryADD,@PayStatus,@MMA,@MMADate, 

  @CrewNo,@Size,@Employ,@Cumulative,@Periods, 

  @ArrearageDate,@M,@ContactRelation1,@Rcell,@OldElevel, 

  @FILENAME,@FILEVISUALPATH,@MemberSort,@TalkFamilyID,@FamilyGradeID) 



end 

end
allenpang 2008-12-05
  • 打赏
  • 举报
 回复
消息 2750，级别 16，状态 1，过程 Club_Membersbak_insert，第 1 行
第 12 个列或参数: 指定的列精度 182 大于最大精度 38。
消息 2750，级别 16，状态 1，过程 Club_Membersbak_insert，第 1 行
第 27 个列或参数: 指定的列精度 182 大于最大精度 38。
消息 2750，级别 16，状态 1，过程 Club_Membersbak_insert，第 1 行
第 32 个列或参数: 指定的列精度 182 大于最大精度 38。
消息 2750，级别 16，状态 1，过程 Club_Membersbak_insert，第 1 行
第 34 个列或参数: 指定的列精度 182 大于最大精度 38。


还是报错呢，第一次写触发器，就碰到这么多问题，晕死。。。
Andy__Huang 2008-12-04
  • 打赏
  • 举报
 回复
修改好了:


create TRIGGER Club_Membersbak_insert
ON [dbo].[Club_Members]
FOR INSERT
AS
set ANSI_NULLS ON
set ANSI_WARNINGS ON
declare @MemberId varchar(10)
declare @Password varchar(50)
declare @Status bit
declare @IsFounder bit
declare @MemberType tinyint
declare @NameGB varchar(20)
declare @Gender varchar(10)
declare @DOB varchar(50)
declare @IDCardNo varchar(20)
declare @AccountAddress varchar(100)
declare @HomeAddress varchar(100)
declare @PostCode varchar(10)
declare @TelHome varchar(20)
declare @TelOffice varchar(20)
declare @Cell varchar(20)
declare @Company varchar(50)
declare @Department varchar(20)
declare @Salary varchar(20)
declare @NameEN varchar(30)
declare @Email varchar(200)
declare @Marriage varchar(10)
declare @ParentName varchar(30)
declare @ParentAddress varchar(100)
declare @ParentTel varchar(20)
declare @ContactName varchar(30)
declare @ContactTel varchar(20)
declare @ContactRelation varchar(20)
declare @EnglishLevel varchar(10)
declare @ValidDate smalldatetime
declare @ValidDateFrom smalldatetime
declare @LeadsId varchar(10)
declare @SourceCode varchar(30)
declare @RefId varchar(20)
declare @RefMemberId varchar(10)
declare @RecMail bit
declare @RecSms bit
declare @SalesCode varchar(20)
declare @Demo varchar(200)
declare @KeyInBy varchar(20)
declare @DateAdded datetime
declare @Points int
declare @LogInCount int
declare @TimeLastLogIn datetime
declare @NO varchar(50)
declare @To varchar(50)
declare @Certification varchar(250)
declare @TotalPrice decimal(182)
declare @Installments int
declare @InitialPayment decimal(182)
declare @PayDate varchar(50)
declare @PayBy varchar(10)
declare @PayFrom varchar(50)
declare @PayTo varchar(50)
declare @PerMonthPrice decimal(182)
declare @SignDate varchar(50)
declare @EcName varchar(50)
declare @SrcID varchar(50)
declare @SrcNotes varchar(255)
declare @LevelTestDate varchar(20)
declare @DeliveryDate varchar(20)
declare @ConfirmDate varchar(20)
declare @DeliveryADD varchar(250)
declare @PayStatus varchar(50)
declare @MMA bit
declare @MMADate varchar(20)
declare @CrewNo varchar(50)
declare @Size varchar(20)
declare @Employ varchar(50)
declare @Cumulative decimal(182)
declare @Periods int
declare @ArrearageDate varchar(20)
declare @M int
declare @ContactRelation1 varchar(20)
declare @Rcell varchar(50)
declare @OldElevel varchar(10)
declare @FILENAME varchar(50)
declare @FILEVISUALPATH varchar(255)
declare @MemberSort varchar(50)
declare @TalkFamilyID int
declare @FamilyGradeID int
begin
select @MemberId=MemberId,@Password=Password,@Status=Status,@IsFounder=IsFounder,@MemberType=MemberType, @NameGB=NameGB,@Gender=Gender,@DOB=DOB,@IDCardNo=IDCardNo,@AccountAddress=AccountAddress,
@HomeAddress=HomeAddress,@PostCode=PostCode,@TelHome=TelHome,@IsFounder=IsFounder,@Cell=Cell,
@Company=Company,@Department=Department,@Salary=Salary,@NameEN=NameEN,@Email=Email,
@Marriage=Marriage,@ParentName=ParentName,@ParentAddress=ParentAddress,@ParentTel=ParentTel,@ContactName=ContactName,
@ContactTel=ContactTel,@ContactRelation=ContactRelation,@EnglishLevel=EnglishLevel,@ValidDate=ValidDate,@ValidDateFrom=ValidDateFrom,
@LeadsId=LeadsId,@SourceCode=SourceCode,@RefId=RefId,@RefMemberId=RefMemberId,@RecMail=RecMail,
@RecSms=RecSms,@SalesCode=SalesCode,@Demo=Demo,@KeyInBy=KeyInBy,@DateAdded=DateAdded,
@Points=Points,@LogInCount=LogInCount,@TimeLastLogIn=TimeLastLogIn,@NO=[NO],@To=[To],
@Certification=Certification,@TotalPrice=TotalPrice,@Installments=Installments,@InitialPayment=InitialPayment,@PayDate=PayDate,
@PayBy=PayBy,@PayFrom=PayFrom,@PayTo=PayTo,@PerMonthPrice=PerMonthPrice,@SignDate=SignDate,
@EcName=EcName,@SrcID=SrcID,@SrcNotes=SrcNotes,@LevelTestDate=LevelTestDate,@DeliveryDate=DeliveryDate,
@ConfirmDate=ConfirmDate,@DeliveryADD=DeliveryADD,@PayStatus=PayStatus,@MMA=MMA,@MMADate=MMADate,
@CrewNo=CrewNo,@Size=[Size],@Employ=Employ,@Cumulative=Cumulative,@Periods=Periods,
@ArrearageDate=ArrearageDate,@M=M,@ContactRelation1=ContactRelation1,@Rcell=Rcell,@OldElevel=OldElevel,
@FILENAME=[FILENAME],@FILEVISUALPATH=FILEVISUALPATH,@MemberSort=MemberSort,@TalkFamilyID=TalkFamilyID,@FamilyGradeID=FamilyGradeID
from inserted
if @MemberId <>0
begin
insert into [Club_Membersbak]
([MemberId]
,[Password]
,[Status]
,[IsFounder]
,[MemberType]
,[NameGB]
,[Gender]
,[DOB]
,[IDCardNo]
,[AccountAddress]
,[HomeAddress]
,[PostCode]
,[TelHome]
,[TelOffice]
,[Cell]
,[Company]
,[Department]
,[Salary]
,[NameEN]
,[Email]
,[Marriage]
,[ParentName]
,[ParentAddress]
,[ParentTel]
,[ContactName]
,[ContactTel]
,[ContactRelation]
,[EnglishLevel]
,[ValidDate]
,[ValidDateFrom]
,[LeadsId]
,[SourceCode]
,[RefId]
,[RefMemberId]
,[RecMail]
,[RecSms]
,[SalesCode]
,[Demo]
,[KeyInBy]
,[DateAdded]
,[Points]
,[LogInCount]
,[TimeLastLogIn]
,[NO]
,[To]
,[Certification]
,[TotalPrice]
,[Installments]
,[InitialPayment]
,[PayDate]
,[PayBy]
,[PayFrom]
,[PayTo]
,[PerMonthPrice]
,[SignDate]
,[EcName]
,[SrcID]
,[SrcNotes]
,[LevelTestDate]
,[DeliveryDate]
,[ConfirmDate]
,[DeliveryADD]
,[PayStatus]
,[MMA]
,[MMADate]
,[CrewNo]
,[Size]
,[Employ]
,[Cumulative]
,[Periods]
,[ArrearageDate]
,[M]
,[ContactRelation1]
,[Rcell]
,[OldElevel]
,[FILENAME]
,[FILEVISUALPATH]
,[MemberSort]
,[TalkFamilyID]
,[FamilyGradeID])
values(@MemberId,@Password,@Status,@IsFounder,@MemberType,
@NameGB,@Gender,@DOB,@IDCardNo,@AccountAddress,
@HomeAddress,@PostCode,@TelHome,@TelOffice,@Cell,
@Company,@Department,@Salary,@NameEN,@Email,
@Marriage,@ParentName,@ParentAddress,@ParentTel,@ContactName,
@ContactTel,@ContactRelation,@EnglishLevel,@ValidDate,@ValidDateFrom,
@LeadsId,@SourceCode,@RefId,@RefMemberId,@RecMail,
@RecSms,@SalesCode,@Demo,@KeyInBy,@DateAdded,
@Points,@LogInCount,@TimeLastLogIn,@NO,@To,
@Certification,@TotalPrice,@Installments,@InitialPayment,@PayDate,
@PayBy,@PayFrom,@PayTo,@PerMonthPrice,@SignDate,
@EcName,@SrcID,@SrcNotes,@LevelTestDate,@DeliveryDate,
@ConfirmDate,@DeliveryADD,@PayStatus,@MMA,@MMADate,
@CrewNo,@Size,@Employ,@Cumulative,@Periods,
@ArrearageDate,@M,@ContactRelation1,@Rcell,@OldElevel,
@FILENAME,@FILEVISUALPATH,@MemberSort,@TalkFamilyID,@FamilyGradeID)

end
end
求助帖：MySQL创建触发器后插入数据报错
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档。
oracle 报错pls 00405,求助帖！oracle触发器if中不支持子查询怎么处理
报错 此上下文中不支持子查询 错误：PLS-00405: 此上下文中不支持子查询 行：4 文本：if :new.def15=*Y* and :new.pk_corp in (select pk_corp from bd_corp where pk_corp=*1553* or fathercorp=*1553*) then 错误...
求助MYSQL触发器
CREATE TRIGGER jisuanfei17 AFTER INSERT ON 用电信息 FOR EACH ROW SELECT* FROM 用电信息 order by 客户号 desc INSERT INTO 费用管理(客户号,月份,费用,收费标志) ...如何实现 在触发器里先查询再运行
mysql创建触发器难题_[]MYSQL创建触发器遇到很奇怪的有关问题
[求助]mysql创建触发器遇到很奇怪的问题。今天遇到一个很奇怪的问题，是关于创建触发器的。创建触发器代码如下SQL codecreate trigger trigger_t_test_U after update on t_test for each row begin insert into t_...
SQL执行存储过程执行报错：必须声明标量变量“@roomNumber”！
SQL执行存储过程执行报错：必须声明标量变量“@roomNumber”！ 第一次写存储过程，结果出错：必须声明标量变量“@roomNumber”，我已在建存储开始声明了，可不知道为什么还是出错，求助 CREATE PROCEDURE [dbo]....
MS-SQL Server

34,590

社区成员

254,589

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章