使用FSO把文本信息导入数据库

;Varchar(100),              --公司所在城市

   …

)

AS

SET NOCOUNT ON

       BEGIN TRAN

            INSERT INTO Tb_WCLibrary(  

                             WC_CompanyName,

                             WC_CCompanyName,

                             WC_Address,

                             …

                                )

               VALUES(

                          @in_CompanyName,

                          @in_CCompanyName,

                          @in_Address,

                          …

                           )

IF @@ERROR <> 0

BEGIN

ROLLBACK TRAN

RETURN -1

END

COMMIT TRAN

RETURN 0

SET NOCOUNT OFF

至此，全文内容讲解结束，希望这篇文章能给读者带来一定的帮助。