SQL_公司语法

【网学网提醒】：以下是网学会员为您推荐的SQL_公司语法，希望本篇文章对您学习有所帮助。

    February05,200910:31:31AM
    --F30:ビ叫禣ノ挡衡
    SELECTw530.*,t114.collction_id
    FROMW530_REPORT_DEPIDw530INNERJOIN
    T114_FEE_COLLECTIONt114ON
    w530.department_id=t114.FK_T101_department_idINNERJOIN
    T141_FEE_SHAREt141ONt114.collction_id=t141.collction_idAND
    w530.department_id=t141.own_department_cdeINNERJOIN
    T142_FEE_DEP_SHAREt142ONt114.collction_id=t142.collction_idAND
    w530.department_id=t142.Belong_DepartmentidINNERJOIN
    T143_FEE_DEP_INSURt143ONt114.collction_id=t143.collction_idAND
    w530.department_id=t143.Belong_Departmentid

    V1
    SELECTw530.*,t141.fee_id,t141.collction_idASExpr1,t141.dept_share_seq,
    t141.application_amt,t114.collction_id,t114.btnsource_id,
    t114.use_employee_id,t114.fee_use_property_id,t114.business_travel_code,
    t114.pay_dte,t114.remarks
    FROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114
    ONw530.department_id=t114.FK_T101_department_id
    INNERJOINT141_FEE_SHAREt141ONt114.collction_id=t141.collction_idAND
    w530.department_id=t141.own_department_cde
    --INNERJOINM019_EMPLOYEEON
    --M019_EMPLOYEE.employee_id=t114.use_employee_idINNERJOIN
    --M043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOIN
    --M004_FEE_DETAIL_SUBJECTm004INNERJOIN
    --M003_FEE_Secondm003ON
    --m004.FK_M003_category_fee_id=m003.FK_M002_category_fee_idAND
    --m004.FK_M003_second_fee_id=m003.econd_fee_idON
    --t141.fee_id=m004.fee_idINNERJOIN
    --M038_FEE_USE_PROPERTYm038ON
    --t114.fee_use_property_id=m038.fee_use_property_cdeINNERJOIN
    --M046_business_travelm046ON
    --t114.business_travel_code=m046.business_travel_code
    V2
    SELECTw530.*,t141.fee_id,t141.collction_idASExpr1,t141.dept_share_seq,
    t141.application_amtv,t114.insurance_cde,
    t114.collction_id,t114.btnsource_id,
    t114.use_employee_id,t114.fee_use_property_id,t114.business_travel_code,
    t114.pay_dte,t114.remarks,m043.fee_id_nme,m004.FK_M003_second_fee_id,
    m003.fee_second_nme,M019_EMPLOYEE.empolyee_name_nme,
    m038.fee_use_property_desc,m046.business_travel_name
    FROMW530
    _REPORT_DEPIDw530INNERJOIN
    T114_FEE_COLLECTIONt114ON
    w530.department_id=t114.FK_T101_department_idINNERJOIN
    T141_FEE_SHAREt141ONt114.collction_id=t141.collction_idAND
    w530.department_id=t141.own_department_cdeINNERJOIN
    M019_EMPLOYEEON
    M019_EMPLOYEE.employee_id=t114.use_employee_idINNERJOIN
    M043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOIN
    M004_FEE_DETAIL_SUBJECTm004ONt141.fee_id=m004.fee_idINNERJOIN
    M003_FEE_Secondm003ON
    m004.FK_M003_category_fee_id=m003.FK_M002_category_fee_idAND
    m004.FK_M003_second_fee_id=m003.econd_fee_idINNERJOIN
    M038_FEE_USE_PROPERTYm038ON
    t114.fee_use_property_id=m038.fee_use_property_cdeINNERJOIN
    M046_business_travelm046ON
    t114.business_travel_code=m046.business_travel_code
    V3:酚W513逆︗抖
    /*************************************************************************/
    SELECTemployee_id,econd_fee_id,fee_id,fee_id_nme,collecion_amt,
    fee_second_nme,bargain_cde,insurance_cde,btnsource_id,insurance_nme,
    use_employee_id,use_employee_nme,fee_use_property_id,
    fee_use_property_desc,business_travel_code,business_travel_nme,pay_dte,
    digest_description,department_id,departname_full_nme
    FROMW513_Act_Month_Rpt
    /*************************************************************************/
    selectw530.print_user,m004.FK_M003_second_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amtv
    ,m003.fee_second_nme,bargain_cde='??',t114.insurance_cde,t114.btnsource_id,insurance_nme='??'
    ,t114.use_employee_id,M019_EMPLOYEE.empolyee_name_nme,t114.fee_use_property_id
    ,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte
    ,t114.remarks,w530.department_id,w530.departname_full_nme
    --SELECTw530.*,t141.fee_id,t141.collction_idASExpr1,t141.dept_share_seq,
    --t141.application_amtv,t114.insurance_cde,
    --t114.collction_id,t114.btnsource_id,
    --t114.use_employee_id,t114.fee_use_property_id,t114.business_travel_code,
    --t114.pay_dte,t114.remarks,m043.fee_id_nme,m004.FK_M003_second_fee_id,
    --m003.fee_second_nme,M019_EMPLOYEE.empolyee_name_nme,
    --m038.fee_use_property_desc,m046.business_travel_name
    FROMW530_REPORT_DEPIDw530INNERJOIN

    T114_FEE_COLLECTIONt114ON
    w530.department_id=t114.FK_T101_department_idINNERJOIN
    T141_FEE_SHAREt141ONt114.collction_id=t141.collction_idAND
    w530.department_id=t141.own_department_cdeINNERJOIN
    M019_EMPLOYEEasm019ON
    M019_EMPLOYEE.employee_id=t114.use_employee_idINNERJOIN
    M043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOIN
    M004_FEE_DETAIL_SUBJECTm004ONt141.fee_id=m004.fee_idINNERJOIN
    M003_FEE_Secondm003ON
    m004.FK_M003_category_fee_id=m003.FK_M002_category_fee_idAND
    m004.FK_M003_second_fee_id=m003.econd_fee_idINNERJOIN
    M038_FEE_USE_PROPERTYm038ON
    t114.fee_use_property_id=m038.fee_use_property_cdeINNERJOIN
    M046_business_travelm046ON
    t114.business_travel_code=m046.business_travel_code
    V4
    INSERTINTOW513_Act_Month_Rpt
    SELECTw530.print_user,ISNULL(t141.econd_fee_id,'')ASExpr9,ISNULL(t141.fee_id,
    '')ASExpr10,t114.collction_id,m043.fee_id_nme,t141.application_amt,
    m003.fee_second_nme,
    (CASEWHENt114.insurance_cde='_'THEN''ELSEt114.insurance_cdeEND)
    ASExpr11,t114.btnsource_id,'??'ASinsurance_nme,
    t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,
    m038.fee_use_property_desc,t114.business_travel_code,
    m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,
    w530.departname_full_nme,''ASExpr1,''ASExpr2,''ASExpr3,GETDATE()
    ASExpr4,''ASExpr5,''ASExpr6,''ASExpr7,GETDATE()ASExpr8
    FROMW530_REPORT_DEPIDw530INNERJOIN
    T114_FEE_COLLECTIONt114ON
    w530.department_id=t114.FK_T101_department_idINNERJOIN
    (SELECTcollction_id,category_fee_id,econd_fee_id,fee_id,
    SUM(application_amt)ASapplication_amt
    FROMT141_FEE_SHARE

    /***************************************************************************************/
    "UPDATE朝瓃Α籔TABLEFOREIGNKEY兵ン'FK__T121_APPROVE_FLO__4C364F0E'祇ネ侥
    侥祇ネ戈畐'HWBGT'戈'T101_YEAR_COST_DEPARTMENT'\r\n朝瓃Α竒挡"
    /*G51001CallG51002*/
    "G51002.aspx?approve_flow_nbr=1150"
    /*btnDepId_Click块场腹珼匡*/
    sURL="GNYSS503.a
    spx?id=FormView1_txtDepId"
    sScript="'GNYSS503.aspx?id=FormView1_txtDepId','','height=650,width=850,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,alwaysRaised=yes',''"
    sScript=" "
    ex.Message="System.Web.Services.Protocols.SoapException:狝竟礚猭矪瞶璶―--->System.Data.SqlClient.SqlException:ミ硈钡︓狝竟祇ネ岿粇讽硈钡︓SQLServer2005ア毖琌箇砞砞﹚SQLServerぃす砛环狠硈钡(provider:ㄣ恨絬矗ㄑ,error:40-礚猭秨币︓SQLServer硈钡)\nSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception,BooleanbreakConnection)\nSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj)\nSystem.Data.SqlClient.TdsParser.Connect(Boolean&;useFailoverPartner,Boolean&;failoverDemandDone,Stringhost,StringfailoverPartner,Stringprotocol,SqlInternalConnectionTdsconnHandler,Int64timerExpire,Booleanencrypt,BooleantrustServerCert,BooleanintegratedSecurity,SqlConnectionowningObject,BooleanaliasLookup)\nSystem.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectionowningObject,SqlConnectionStringconnectionOptions,StringnewPassword,BooleanredirectedUserInstance)\nSystem.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity,SqlConnectionStringconnectionOptions,ObjectproviderInfo,StringnewPassword,SqlConnectionowningObject,BooleanredirectedUserInstance)\nSystem.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions,ObjectpoolGroupProviderInfo,DbConnectionPoolpool,DbConnectionowningConnection)\nSystem.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionowningConnection,DbConnectionPoolpool,DbConnectionOptionsoptions)\nSystem.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject)\nSystem.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject)\nSystem.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnectionowningObject)\nSystem.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnectionowningConnection)\nSystem.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnectionouterConnection,DbConnectionFactoryconnectionFactory)\nSystem.Data.SqlClient.SqlConnection.Open()\nDataAccess.M006DB.Select_Search(M006InfomyInfo,SqlConnectionsqlConTrn,SqlTransactiontransaction)C:\\DocumentsandSettings\\Administrator\\\\G44\\M001_010\\M006DB.cs:︽474\nWSM006.Select_Search(M006Infom006Info)c:\\DocumentsandSettings\\Administrator\\\\G44\\WSG44\\App_Code\\WSM006.cs:︽57\n---
    ず场ㄒ猵帮舼發萝挡Ю---"
    "DataSource=VMCANDY;InitialCatalog=HWBGT;UserID=sa"
    ex={"跑计嘿'@fee_id'竒琩高уΩ┪箇祘ず跑计嘿ゲ斗琌斑\r\n︽1:'w530'粂猭ぃタ絋"}
    ex.Message="︽1:'w530'粂猭ぃタ絋"
    "insertintoW513_Act_Month_Rptselectw530.print_user,m004.FK_M003_second_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amtv,m003.fee_second_nme,t114.collction_id,t114.insurance_cde,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,w530.departname_full_nmeFROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOINT141_FEE_SHAREt141ONt114.collction_id=t141.collction_id/*ANDw530.department_id=t141.own_department_cde*/INNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOINM004_FEE_DETAIL_SUBJECTm004ONt141.fee_id=m004.fee_idINNERJOINM003_FEE_Secondm003ONm004.FK_M003_second_fee_id=m003.econd_fee_id*/andm004.FK_M003_category_fee_id=m003.FK_M002_category_fee_id*/INNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_codeWHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code"
    insertintoW513_Act_Month_Rpt
    selectw530.print_user,m004.FK_M003_second_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amtv,m003.fee_second_nme,t114.collction_id,t114.insurance_cde,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,w530.departname_full_nmeFROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOINT141_FEE_SHAREt141ONt114.collction_id=t141.collction_id/*ANDw530.department_id=t141.own_department_cde*/INNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOINM004_FEE_DETAIL_SUBJECTm004ONt141.fee_id=m004.fee_idINNERJOINM003_FEE_Secondm003ONm004.FK_M003_second_fee_id=m003.econd_fee_id/*andm004.FK_M003_category_fee_id=m003.FK_M002_category_fee_id*/INNERJOINM038_FEE_USE_PR
    OPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_id
    ANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code
    insertintoW513_Act_Month_Rpt
    selectw530.print_user,m004.FK_M003_second_fee_id,t141.fee_id,m043.fee_id_nme
    ,t141.application_amt,m003.fee_second_nme,t114.collction_id,t114.insurance_cde
    ,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id
    ,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte
    ,t114.remarks,w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()
    FROMW530_REPORT_DEPIDw530
    INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_id
    INNERJOINT141_FEE_SHAREt141ONt114.collction_id=t141.collction_id/*ANDw530.department_id=t141.own_department_cde*/
    INNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_id
    INNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_id
    INNERJOINM004_FEE_DETAIL_SUBJECTm004ONt141.fee_id=m004.fee_id
    INNERJOINM003_FEE_Secondm003ONm004.FK_M003_second_fee_id=m003.econd_fee_id/*andm004.FK_M003_category_fee_id=m003.FK_M002_category_fee_id*/
    INNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cde
    INNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_id
    ANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code
    insertintoW513_Act_Month_Rpt
    selectw530.print_user,t141.econd_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amt,m003.fee_second_nme,t114.collction_id,t114.insurance_cde,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()
    FROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOINT141_FEE_SHAREt141ONt114.collction_id=t141.collction_id/*ANDw530.department_id=t141.own_department_cde*/INNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ON
    t141.fee_id=m043.fee_idINNERJOINM003_FEE_Secondm003ONt141.econd_fee_id=m003.econd_fee_id/*andm004.FK_M003_category_fee_id=m003.FK_M002_category_fee_id*/INNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code
    ex.Message
    "PRIMARYKEY笻は兵ン'I0010439'礚猭ン'W513_Act_Month_Rpt'础狡ま龄\r\n朝瓃Α竒挡"
    ㄏノ祘Α絏ゼ矪瞶System.Security.SecurityException
    Message="舱ンぃす砛场だ獺ヴ㊣狠"
    Source="M041_050"
    StackTrace:
    System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assemblyasm,PermissionSetgranted,PermissionSetrefused,RuntimeMethodHandlermh,SecurityActionaction,Objectdemand,IPermissionpermThatFailed)
    DataAccess.M050DB..ctor()
    _Default..ctor()
    ASP.f30001_aspx..ctor()
    __ASP.FastObjectFactory_app_web_qlawxg2y.Create_ASP_f30001_aspx()
    System.Web.Compilation.BuildResultCompiledType.CreateInstance()
    System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPathvirtualPath,TyperequiredBaseType,HttpContextcontext,BooleanallowCrossApp,BooleannoAssert)
    System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContextcontext,StringrequestType,VirtualPathvirtualPath,StringphysicalPath)
    System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContextcontext,StringrequestType,VirtualPathvirtualPath,StringphysicalPath)
    System.Web.HttpApplication.MapHttpHandler(HttpContextcontext,StringrequestType,VirtualPathpath,StringpathTranslated,BooleanuseAppConfig)
    System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    System.Web.HttpApplication.ExecuteStep(IExecutionStepstep,Boolean&;completedSynchronously)
    '/WG44'莱ノ祘Αい祇ネ狝竟岿粇
    --------------------------------------------------------------------------------
    舱篈岿粇
    磞瓃:矪瞶狝叭璶―┮惠舱篈郎祇ネ岿粇叫浪跌疭﹚岿粇冈灿戈癟続讽э眤舱篈郎
    猂竟岿粇癟:更舱篈郎祇ネ岿粇:礚猭秨﹍菏跌'\\10.0.0.9\d$\Data\地玭祘Α\xin\WG44'跑竒笷呼隔BIOS㏑
    惠岿粇冈灿戈癟叫把綷Microsoft醚畐ゅン810886ぃや穿WindowsXPキUNCノ杆
    更
    ﹍祘Α岿粇:
    [⊿Τ闽﹍祘Α絏]

    ﹍祘Α郎:\\10.0.0.9\d$\Data\地玭祘Α\xin\WG44\web.config︽:0
    --------------------------------------------------------------------------------
    セ戈癟:Microsoft.NETFrameworkセ:2.0.50727.1433;ASP.NETセ:2.0.50727.1433
    insertintoW513_Act_Month_Rpt
    selectw530.print_user,t141.econd_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amt,m003.fee_second_nme,t114.collction_id,t114.insurance_cde,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()FROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOIN(selectcollction_id,fee_id,sum(application_amt)asapplication_amtFromT141_FEE_SHAREGroupbycollction_id,fee_id)ast141ONt114.collction_id=t141.collction_idINNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOINM003_FEE_Secondm003ONt141.econd_fee_id=m003.econd_fee_id/*andm004.FK_M003_category_fee_id=m003.FK_M002_category_fee_id*/INNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'
    ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code
    insertintoW513_Act_Month_Rpt
    selectw530.print_user,t141.econd_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amt,m003.fee_second_nme,t114.collction_id,t114.insurance_cde,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()FROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOIN(selectcollction_id,econd_fee_id,fee_id,sum(application_amt)asapplication_amtFromT141_FEE_SHAREGroupbycollction_id,econd_fee_id,fee_id)ast141ONt114.collction_id=t141.collction_idINNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOINM003_FEE_Secondm003ONt141.econd_fee_id=m003.econd_fee_id/*andm004.FK_M003_category_fee_id=m003.FK_M002_c
    ategory_fee_id*/INNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code

    insertintoW513_Act_Month_Rpt
    selectw530.print_user,t141.econd_fee_id,t141.fee_id,m043.fee_id_nme,t141.application_amt,m003.fee_second_nme,t114.collction_id,t114.insurance_cde,t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,t114.remarks,w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()
    FROMW530_REPORT_DEPIDw530
     INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_id
     INNERJOIN(selectcollction_id,econd_fee_id,fee_id,sum(application_amt)asapplication_amtFromT141_FEE_SHAREGroupbycollction_id,econd_fee_id,fee_id)ast141ONt114.collction_id=t141.collction_id
     INNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_id
     INNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_id
     INNERJOINM003_FEE_Secondm003ONt141.econd_fee_id=m003.econd_fee_id/*andm004.FK_M003_category_fee_id=m003.FK_M002_category_fee_id*/
     INNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cde
     INNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code"

    INSERTINTOW513_Act_Month_Rpt
    varchar->numeric

     '0871222','33','1706','G0900000088','瞶竭ó皑禣-眏繧',468,'ゅㄣ厨籔','??','0951056'
     ,'現','2','','9','ㄤ','穝狥ㄊ玻朝柬醇羆竒瞶.ゅ瑄瞶碔ü关朝賧捌羆蝗︽砛彻竡','0101','胺眃篬キ玂繧场','','','','2009/2/1116:50:58','','','','2009/2/1116:50:58'

    INSERTINTO()
    VALUES('0871222','33','1706','G0900000088','瞶竭ó皑禣-眏繧',468,
    'ゅㄣ厨籔','??','0951056','現','2','','9','ㄤ',
    '穝狥ㄊ玻朝柬醇羆竒瞶.ゅ瑄瞶碔ü关朝賧捌羆蝗︽砛彻竡',

    '0101','胺眃篬キ玂繧场','','','','2009/2/1116:50:58','','','',
    '2009/2/1116:50:58')

    INSERTINTOW513_Act_Month_Rpt
    (employee_id,econd_fee_id,fee_id,bargain_cde,fee_id_nme,collecion_amt,
    fee_second_nme,insurance_cde,btnsource_id,insurance_nme,
    use_employee_id,use_employee_nme,fee_use_property_id,
    fee_use_property_desc,business_travel_code,business_travel_nme,pay_dte,
    digest_description,department_id,departname_full_nme,user_insert_cde,
    ip_insert_cde,PGM_insert_cde,row_insert_tms,user_modify_cde,
    ip_modify_cde,PGM_modify_cde,row_modify_tms)
    VALUES('9871222','33','1706','G0900000088','瞶竭ó皑禣-眏繧',468,
    'ゅㄣ厨籔','','','??','0951056','現','2','','9','ㄤ',
    '1989/11/12',
    SUBSTRING('穝狥ㄊ玻朝柬醇羆竒瞶.ゅ瑄瞶碔ü关朝賧捌羆蝗︽砛彻竡',
    0,10),'0101','胺眃篬キ玂繧场','','','','2009/2/1116:50:58','','','',
    '2009/2/1116:50:58')
    "戈︽玡竚迭't114'籔ノ琩高い戈嘿┪ぃ才"
    "礚戈︽嘿'pay_dte'\r\n礚戈︽嘿'tally_up_ind'"

    "insertintoW513_Act_Month_Rptselectw530.print_user,isnull(t141.econd_fee_id,''),isnull(t141.fee_id,''),t114.collction_id,m043.fee_id_nme,t141.application_amt,m003.fee_second_nme,(casewhent114.insurance_cde='_'then''elset114.insurance_cdeend),t114.btnsource_id,insurance_nme='??',t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte,SUBSTRING(t114.remarks,0,15),w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()FROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOIN(selectcollction_id,category_fee_id,econd_fee_id,fee_id,sum(application_amt)asapplication_amtFromT141_FEE_SHAREGroupbycollction_id,category_fee_id,econd_fee_id,fee_id)ast141ONt114.collction_id=t141.collction_idINNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_idINNERJOINM003_FEE_Secondm003ONt141.econd_fee_id=m003.econd_fee_idandt141.category_fee_id=m003.FK_M002_category_fee_idINNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_tr
    avel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code"
     sqlStr
    "insertintoW513_Act_Month_Rptselectw530.print_user,t145.econd_fee_id,t145.fee_id,t145.CV_nbr+convert(char,t145.CV_seq_nbr),m043.fee_id_nme,(casewhent145.journal_debit_credit_ind='D'then1else-1end)*t145.journal_amt,m003.fee_second_nme,(casewhent145.insurance_cde='_'then''elset145.insurance_cdeend),t145.btnsource_id,insurance_nme='??',t145.use_employee_id,m019.empolyee_name_nme,t145.fee_use_property_id,m038.fee_use_property_desc,t145.business_travel_code,m046.business_travel_name,t145.pay_dte,SUBSTRING(t145.journal_digest_dsc,0,15),w530.department_id,w530.departname_full_nme,'','','',getdate(),'','','',getdate()FROMW530_REPORT_DEPIDw530INNERJOINT145_PAID_INP_DTLt145ONw530.department_id=t145.departmentidINNERJOINM019_EMPLOYEEm019ONm019.employee_id=t145.use_employee_idINNERJOINM043_FEE_CODEm043ONt145.fee_id=m043.fee_idINNERJOINM003_FEE_Secondm003ONt145.econd_fee_id=m003.econd_fee_idandt145.category_fee_id=m003.FK_M002_category_fee_idINNERJOINM038_FEE_USE_PROPERTYm038ONt145.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt145.business_travel_code=m046.business_travel_codeWHEREtally_up_ind<>'Y'ANDt145.fee_idlike@fee_idANDt145.insurance_cdelike@insurance_cdeANDt145.btnsource_idlike@btnsource_idANDt145.use_employee_idlike@use_employee_idANDt145.fee_use_property_idlike@fee_use_property_idANDt145.business_travel_codelike@business_travel_code" string
    =============February12,2009================
    "System.Web.Services.Protocols.SoapException:狝竟礚猭矪瞶璶―--->System.Exception:闽羛嘿'm046'FROMい竒﹚Ω
    \nDataAccess.RF3001.gotoError(StringMessageError)C:\\DocumentsandSettings\\Administrator\\MyDocuments\\xin\\RF3001\\RF3001.cs:︽75
    \nDataAccess.RF3001.CalFeeInsertW513(in_W513ParaminW513P,SqlConnectionsqlConTrn,SqlTransactiontransaction)C:\\DocumentsandSettings\\Administrator\\MyDocuments\\xin\\RF3001\\RF3001.cs:︽433
    \nWSRF3001.CalFeeInsertW513(in_W513ParaminW513P,ObjectsqlContrn,Objecttransaction)c:\\DocumentsandSettings\\Administrator\\MyDocuments\\xin\\WSG44\\App_Code\\WSRF3001.cs:︽29
    \n---ず场ㄒ猵帮舼發萝挡Ю---"
    "闽羛嘿'm046'FROMい竒﹚Ω"

    /**********************************************/
    ㊣厨
    "10.0.0.9/Smart-Query/squery.aspx?Path=HWBGT&;filename=F31_3&;sys=F31_3&;Parameter1=0871222&;Parameter2=&;Parameter3=&;Parameter4=&;Parameter
    5=&;Parameter6=&;Parameter7=&;Parameter8=&;Parameter9="
    ReportgeneratingError:тぃ戈︽department_id
    System.Data.DataTable.ParseSortString(StringsortString)
    System.Data.DataView.CheckSort(Stringsort)
    System.Data.DataView.set_Sort(Stringvalue)ExcelXmlParser.WebReports.InitSort()
    D:\Works\Smart2006\ExcelXmlParser\WebReport.cs:︽832ExcelXmlParser.WebReports.InitReport(XmlElementRootElement;DataSetaDataSet;ReportGeneratorxParser)
    D:\Works\Smart2006\ExcelXmlParser\WebReport.cs:︽820ExcelXmlParser.WebReports.WebReport(DataSetaDataSet;XmlElementRootElement;ReportGeneratorxParser;Data_BaseaDataObject1)
    D:\Works\Smart2006\ExcelXmlParser\WebReport.cs:︽80

    "10.0.0.9/Smart-Query/squery.aspx?Path=HWBGT&;filename=F30_3&;sys=F30_3&;Parameter1=0871222&;Parameter2=&;Parameter3=&;Parameter4=&;Parameter5=&;Parameter6=&;Parameter7=&;Parameter8=&;Parameter9=&;Parameter10=06"
    ReportgeneratingError:тぃ戈︽department_id
    System.Data.DataTable.ParseSortString(StringsortString)
    System.Data.DataView.CheckSort(Stringsort)System.Data.DataView.set_Sort(Stringvalue)
    ExcelXmlParser.WebReports.InitSort()D:\Works\Smart2006\ExcelXmlParser\WebReport.cs:︽832
    ExcelXmlParser.WebReports.InitReport(XmlElementRootElement;DataSetaDataSet;ReportGeneratorxParser)
    D:\Works\Smart2006\ExcelXmlParser\WebReport.cs:︽820ExcelXmlParser.WebReports.WebReport(DataSetaDataSet;XmlElementRootElement;ReportGeneratorxParser;Data_BaseaDataObject1)
    D:\Works\Smart2006\ExcelXmlParser\WebReport.cs:︽80
    February13,2009
    insertintoW513_Act_Month_Rpt
    selectw530.print_user,isnull(t141.econd_fee_id,''),isnull(t141.fee_id,''),t114.collction_id,m043.fee_id_nme
    ,t141.application_amt/1,m003.fee_second_nme,(casewhent114.insurance_cde='_'then''elset114.insurance_cdeend),t114.btnsource_id
    ,/*insurance_nme='??'*/insurance_nme=caset114.insurance_cdewhen'_'then''when'1'then'ó繧'when'2'then'繧'when'3'then'繧'when'4'then'種繧'end,t114.use_employee_id,m019.empolyee_name_nme,t114.fee_use_property_id,m038.fee_use_property_desc,t114.business_travel_code,m046.business_travel_name,t114.pay_dte
    ,SUBSTRING(t114.remarks,0,15),w530.department_id,w530.departname_full_nme,@user_insert_cde,@ip_insert_cde,@PGM_insert_cde,getdate(),@user_insert_cde,@ip_insert_cde,@PGM_insert_cde,getdate()FROMW530_REPORT_DEPIDw530INNERJOINT114_FEE_COLLECTIONt114ONw530.department_id=t114.FK_T101_department_idINNERJOIN(selectcollction_id,category_fee_id,econd_fee_id,fee_id,sum(application_amt)asapplication_amtFromT141_FEE_SHAREGroupbycollction_id,category_fee_id,econd_fee_id,fee_id)ast141ONt114.collction_id=t141.collction_idINNERJOINM019_EMPLOYEEm019ONm019.employee_id=t114.use_employee_idINNERJOINM043_FEE_CODEm043ONt141.fee_id=m043.fee_id
    INNERJOINM003_FEE_Secondm003ONt141.econd_fee_id=m003.econd_fee_idandt141.category_fee_id=m003.FK_M002_category_fee_idINNERJOINM038_FEE_USE_PROPERTYm038ONt114.fee_use_property_id=m038.fee_use_property_cdeINNERJOINM046_business_travelm046ONt114.business_travel_code=m046.business_travel_code
    WHEREt114.FK_T101_budget_year_dte=2009ANDtally_up_ind<>'Y'ANDt141.fee_idlike@fee_idANDt114.insurance_cdelike@insurance_cdeANDt114.btnsource_idlike@btnsource_idANDt114.use_employee_idlike@use_employee_idANDt114.fee_use_property_idlike@fee_use_property_idANDt114.business_travel_codelike@business_travel_code"
    "DataSource=Gen;InitialCatalog=HWBGT;PersistSecurityInfo=True;UserID=sa"

上一篇资讯： sql_语言教程

下一篇资讯： SQL_server数据库学习记录