在客户的数据库中,创建存储过程,但是有个别存储过程始终创建不成功,并显示下列错误;
望各位朋友给我一个解决方案;谢谢大家;
a transport-level error has occurred when receiving results from the server.(provider:tcp provider,error:0-the specified network name is no longer available)
望各位朋友给我一个解决方案;谢谢大家;
a transport-level error has occurred when receiving results from the server.(provider:tcp provider,error:0-the specified network name is no longer available)
XUAM,您好, 我把存储过程脚本传给客户了,但是客户这边也同样报这个错误;
GO
/****** 对象: StoredProcedure [dbo].[proc_001_InsertCustomerCard] 脚本日期: 03/29/2011 14:08:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--REGION [DBO].[SCH_INSERTUPDATET_PROC_CUSTOMERCARD]------------------------------------------------------------------------------------------------------------------------
-- PROCEDURE NAME: [DBO].[SCH_INSERTUPDATET_PROC_CUSTOMERCARD]
-- DATE GENERATED: 2011年3月22日
-- 添加COSTOMER INFORMATION CARD
------------------------------------------------------------------------------------------------------------------------CREATE PROCEDURE [dbo].[proc_001_InsertCustomerCard]
@GUID NVARCHAR(40),
@APPLICATIONNO NVARCHAR(30),
@PROCESS NVARCHAR(50),
@INCIDENT INT,
@APPLICANT NVARCHAR(20),
@APPLICATIONDATE DATETIME,
@STATUS INT,
@INDATE DATETIME,
@CREATEORREVISE INT,
@SAPWORKFLOWNO NVARCHAR(30),
@CUSTOMERCODE NVARCHAR(30),
@OTHERREMARKS NVARCHAR(200),
@ATTACHMENTCUSTOMER1 NVARCHAR(150),
@ATTACHMENTCUSTOMER2 NVARCHAR(150),
@ATTACHMENTCUSTOMER3 NVARCHAR(150),
@ATTACHMENTCUSTOMER4 NVARCHAR(150),
@ATTACHMENTOTHERS NVARCHAR(150),
@DATAAREVALIDFROM NVARCHAR(50),
@ONE_COMPANYNAME NVARCHAR(20),
@ONE_ADDRESS NVARCHAR(100),
@ONE_TAX_CODE NVARCHAR(30),
@ONE_TEL NVARCHAR(20),
@ONE_BANKNAMEANDACOUNTNO NVARCHAR(40),
@ONE_MARKCUSTOMERTYPE NVARCHAR(10),
@ONE_REMARK NVARCHAR(100),
@TWO_COMPANYNAME NVARCHAR(20),
@TWO_DETAILADDRESS NVARCHAR(100),
@TWO_ZIPCODE NVARCHAR(20),
@TWO_RECEIVER NVARCHAR(20),
@TWO_EMAILADDRESS NVARCHAR(30),
@TWO_TAX NVARCHAR(30),
@TWO_TEL NVARCHAR(20),
@THREE_COMPANYNAME NVARCHAR(20),
@THREE_DETAILADDRESS NVARCHAR(100),
@THREE_ZIPCODE NVARCHAR(20),
@THREE_RECEIVER NVARCHAR(20),
@THREE_TAX NVARCHAR(30),
@THREE_TEL NVARCHAR(20),
@FOUR_EMAILADDRESS NVARCHAR(30),
@FOUR_TAX NVARCHAR(30),
@FOUR_TEL NVARCHAR(20),
@FIVE_ESTIMATEDYEARLYTURNOVER DECIMAL(9, 2),
@SIX_PAYMENTTERM NVARCHAR(30),
@SEVEN_COMPANYNAME NVARCHAR(20),
@SEVEN_DETAILADDRESS NVARCHAR(100),
@SEVEN_CONTACTOR NVARCHAR(30),
@SEVEN_EMAILADDRESS NVARCHAR(30),
@SEVEN_TAX NVARCHAR(30),
@SEVEN_TEL NVARCHAR(20),
@SALESMAN NVARCHAR(20),
@CUSTOMERBRANCHNO NVARCHAR(30),
@CUSTOMERKEYACCOUNTNO NVARCHAR(30),
@CUSTOMERSUBKEYACCOUNTNO NVARCHAR(30),
@RETURNID INT OUTPUT
AS
BEGIN
BEGIN TRAN
DECLARE @REVISEGUID NVARCHAR(40)
SET @REVISEGUID = (SELECT TOP 1 [GUID] FROM [DBO].[T_PROC_001_DETAIL_MINOR] WHERE [CUSTOMERCODE] = @CUSTOMERCODE)
IF @CREATEORREVISE = 0
BEGIN
INSERT INTO [DBO].[T_PROC_001] (
[GUID],[APPLICATIONNO],[PROCESS],[INCIDENT],[APPLICANT],[APPLICATIONDATE],
[STATUS],[INDATE],[CREATEORREVISE],[SAPWORKFLOWNO],[CUSTOMERCODE],[OTHERREMARKS],
[ATTACHMENTCUSTOMER1],[ATTACHMENTCUSTOMER2],[ATTACHMENTCUSTOMER3],[ATTACHMENTCUSTOMER4],
[ATTACHMENTOTHERS]
) VALUES (
@GUID,@APPLICATIONNO,@PROCESS,@INCIDENT,@APPLICANT,@APPLICATIONDATE,@STATUS,
@INDATE,@CREATEORREVISE,@SAPWORKFLOWNO,@CUSTOMERCODE,@OTHERREMARKS,@ATTACHMENTCUSTOMER1,
@ATTACHMENTCUSTOMER2,@ATTACHMENTCUSTOMER3,@ATTACHMENTCUSTOMER4,@ATTACHMENTOTHERS
)
SET @RETURNID = SCOPE_IDENTITY()
END
ELSE
BEGIN
INSERT INTO [DBO].[T_PROC_001] (
[GUID],[APPLICATIONNO],[PROCESS],[INCIDENT],[APPLICANT],[APPLICATIONDATE],
[STATUS],[INDATE],[CREATEORREVISE],[SAPWORKFLOWNO],[CUSTOMERCODE],[OTHERREMARKS],
[ATTACHMENTCUSTOMER1],[ATTACHMENTCUSTOMER2],[ATTACHMENTCUSTOMER3],[ATTACHMENTCUSTOMER4],
[ATTACHMENTOTHERS]
) VALUES (
@REVISEGUID,@APPLICATIONNO,@PROCESS,@INCIDENT,@APPLICANT,@APPLICATIONDATE,@STATUS,
@INDATE,@CREATEORREVISE,@SAPWORKFLOWNO,@CUSTOMERCODE,@OTHERREMARKS,@ATTACHMENTCUSTOMER1,
@ATTACHMENTCUSTOMER2,@ATTACHMENTCUSTOMER3,@ATTACHMENTCUSTOMER4,@ATTACHMENTOTHERS
)
SET @RETURNID = SCOPE_IDENTITY()
END IF @@ERROR <> 0 GOTO ERRORHANDLER --UPDATE [DBO].[T_PROC_CUSTOMERCARD] SET [APPLICATIONNO] = 'CIC-' + RIGHT('00000'+ CONVERT(NVARCHAR,@RETURNID),5) WHERE [ID] = @RETURNID --IF @@ERROR <> 0 GOTO ERRORHANDLER
IF @CREATEORREVISE = 0
BEGIN
INSERT INTO [DBO].[T_PROC_001_DETAIL_MINOR] (
[GUID],[CUSTOMERCODE],[DATAAREVALIDFROM],[ONE_COMPANYNAME],[ONE_ADDRESS],[ONE_TAX_CODE],[ONE_TEL],
[ONE_BANKNAMEANDACOUNTNO],[ONE_MARKCUSTOMERTYPE],[ONE_REMARK],[TWO_COMPANYNAME],
[TWO_DETAILADDRESS],[TWO_ZIPCODE],[TWO_RECEIVER],[TWO_EMAILADDRESS],[TWO_TAX],
[TWO_TEL],[THREE_COMPANYNAME],[THREE_DETAILADDRESS],[THREE_ZIPCODE],[THREE_RECEIVER],
[THREE_TAX],[THREE_TEL],[FOUR_EMAILADDRESS],[FOUR_TAX],[FOUR_TEL],[FIVE_ESTIMATEDYEARLYTURNOVER],
[SIX_PAYMENTTERM],[SEVEN_COMPANYNAME],[SEVEN_DETAILADDRESS],[SEVEN_CONTACTOR],[SEVEN_EMAILADDRESS],
[SEVEN_TAX],[SEVEN_TEL],[SALESMAN],[CUSTOMERBRANCHNO],[CUSTOMERKEYACCOUNTNO],[CUSTOMERSUBKEYACCOUNTNO]
) VALUES (
@GUID,@CUSTOMERCODE,@DATAAREVALIDFROM,@ONE_COMPANYNAME,@ONE_ADDRESS,@ONE_TAX_CODE,@ONE_TEL,@ONE_BANKNAMEANDACOUNTNO,
@ONE_MARKCUSTOMERTYPE,@ONE_REMARK,@TWO_COMPANYNAME,@TWO_DETAILADDRESS,@TWO_ZIPCODE,
@TWO_RECEIVER,@TWO_EMAILADDRESS,@TWO_TAX,@TWO_TEL,@THREE_COMPANYNAME,@THREE_DETAILADDRESS,
@THREE_ZIPCODE,@THREE_RECEIVER,@THREE_TAX,@THREE_TEL,@FOUR_EMAILADDRESS,@FOUR_TAX,
@FOUR_TEL,@FIVE_ESTIMATEDYEARLYTURNOVER,@SIX_PAYMENTTERM,@SEVEN_COMPANYNAME,@SEVEN_DETAILADDRESS,
@SEVEN_CONTACTOR,@SEVEN_EMAILADDRESS,@SEVEN_TAX,@SEVEN_TEL,@SALESMAN,@CUSTOMERBRANCHNO,
@CUSTOMERKEYACCOUNTNO,@CUSTOMERSUBKEYACCOUNTNO
)
END
ELSE
BEGIN
INSERT INTO [DBO].[T_PROC_001_DETAIL_MINOR] (
[GUID],[CUSTOMERCODE],[DATAAREVALIDFROM],[ONE_COMPANYNAME],[ONE_ADDRESS],[ONE_TAX_CODE],[ONE_TEL],
[ONE_BANKNAMEANDACOUNTNO],[ONE_MARKCUSTOMERTYPE],[ONE_REMARK],[TWO_COMPANYNAME],
[TWO_DETAILADDRESS],[TWO_ZIPCODE],[TWO_RECEIVER],[TWO_EMAILADDRESS],[TWO_TAX],
[TWO_TEL],[THREE_COMPANYNAME],[THREE_DETAILADDRESS],[THREE_ZIPCODE],[THREE_RECEIVER],
[THREE_TAX],[THREE_TEL],[FOUR_EMAILADDRESS],[FOUR_TAX],[FOUR_TEL],[FIVE_ESTIMATEDYEARLYTURNOVER],
[SIX_PAYMENTTERM],[SEVEN_COMPANYNAME],[SEVEN_DETAILADDRESS],[SEVEN_CONTACTOR],[SEVEN_EMAILADDRESS],
[SEVEN_TAX],[SEVEN_TEL],[SALESMAN],[CUSTOMERBRANCHNO],[CUSTOMERKEYACCOUNTNO],[CUSTOMERSUBKEYACCOUNTNO]
) VALUES (
@REVISEGUID,@CUSTOMERCODE,@DATAAREVALIDFROM,@ONE_COMPANYNAME,@ONE_ADDRESS,@ONE_TAX_CODE,@ONE_TEL,@ONE_BANKNAMEANDACOUNTNO,
@ONE_MARKCUSTOMERTYPE,@ONE_REMARK,@TWO_COMPANYNAME,@TWO_DETAILADDRESS,@TWO_ZIPCODE,
@TWO_RECEIVER,@TWO_EMAILADDRESS,@TWO_TAX,@TWO_TEL,@THREE_COMPANYNAME,@THREE_DETAILADDRESS,
@THREE_ZIPCODE,@THREE_RECEIVER,@THREE_TAX,@THREE_TEL,@FOUR_EMAILADDRESS,@FOUR_TAX,
@FOUR_TEL,@FIVE_ESTIMATEDYEARLYTURNOVER,@SIX_PAYMENTTERM,@SEVEN_COMPANYNAME,@SEVEN_DETAILADDRESS,
@SEVEN_CONTACTOR,@SEVEN_EMAILADDRESS,@SEVEN_TAX,@SEVEN_TEL,@SALESMAN,@CUSTOMERBRANCHNO,
@CUSTOMERKEYACCOUNTNO,@CUSTOMERSUBKEYACCOUNTNO
)
END
IF @@ERROR <> 0 GOTO ERRORHANDLER COMMIT TRAN
RETURN 0 ERRORHANDLER:
ROLLBACK TRAN
RAISERROR('[proc_001_InsertCustomerCard]:调用[proc_001_InsertCustomerCard]失败',18,127)
RETURN -200
END
重新启动SQL,检查网络!