Thinker

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Thinker

Forum for story


    -Q-----ST201111-0072

    Aueeins
    Aueeins
    呢喃的歌声


    帖子数 : 205
    积分 : 5229
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG

    -Q-----ST201111-0072 Empty -Q-----ST201111-0072

    Post by Aueeins 2011-11-16, 9:47 pm


    Update HPVMAKE88 set make =(select distinct model from dbo.HPVMAK88 where make not in (select distinct make from dbo.HPVMAKE88))
    Insert into HPVMAKE88 (make) (select distinct model from dbo.HPVMAK88 where make not in (select distinct make from dbo.HPVMAKE88))
    Aueeins
    Aueeins
    呢喃的歌声


    帖子数 : 205
    积分 : 5229
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG

    -Q-----ST201111-0072 Empty Re: -Q-----ST201111-0072

    Post by Aueeins 2011-11-16, 9:47 pm

    select Make from HPVMAKe88 order by make
    select Model from HPVMAK88
    Aueeins
    Aueeins
    呢喃的歌声


    帖子数 : 205
    积分 : 5229
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG

    -Q-----ST201111-0072 Empty Re: -Q-----ST201111-0072

    Post by Aueeins 2011-11-16, 9:47 pm

    select distinct Make from HPVMAKE88 order by make
    select distinct Model from HPVMAK88
    Aueeins
    Aueeins
    呢喃的歌声


    帖子数 : 205
    积分 : 5229
    威望 : 0
    注册日期 : 2011-09-08
    地点 : SG

    -Q-----ST201111-0072 Empty Re: -Q-----ST201111-0072

    Post by Aueeins 2011-11-16, 9:48 pm

    1.结果无论如何,不能保持一致
    2.当选择Yes,会向table HPVMAK88 Insert很多重复数据

      Current date/time is 2024-11-25, 4:20 pm