Post reply

What is wrong with this insert query?

  • February 27, 2012 at 9:06 am

    #251439

    Hi all,

    I have a query like this:

    insert into tableA

    select '7',id,'appname',url,getdate()

    from tableB

    TableA has 5 columns. When I run the query it shows 177 rows affected, but nothing is inserted.

    Thank you.

  • February 27, 2012 at 9:07 am

    #1452136

    Any triggers on the table?

    Or possibly a rollback command later in the script?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 27, 2012 at 9:15 am

    #1452139

    I am running just this insert statement manually. There are no triggers on either tables.

    Thanks.

  • February 27, 2012 at 9:16 am

    #1452141

    How are you determining that the rows aren't there? A separate query?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 27, 2012 at 9:23 am

    #1452148

    Select * from databasename.dbo.tableA

    Thanks.

  • February 27, 2012 at 9:25 am

    #1452154

    Ah! stupid me. The query actually had top 1000. When I took that out, the records were there. Thanks for your time.

  • February 28, 2012 at 7:23 am

    #1452587

    Makes sense. You're welcome.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply