Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Naqibuquo

    Updating two tables so they contain the same data

    you could use the following approach as well: insert into Table1 select * from Table2 a where not exists ( select * from Table1 b where a.Table2Key = b.Table1Key )
  2. Naqibuquo

    Simple Select ?

    take also a look here: http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables
  3. Naqibuquo

    drop identity of column

    after some diggin' around I came across to this thread http://www.sqlservercentral.com/Forums/Topic13346-8-1.aspx?Highlight=drop+identity. There is a suggestion there to use a dynamic procedure of this sort: Create Procedure CreateTable (@Table sysname, @Target sysname, @Condition...
  4. Naqibuquo

    drop identity of column

    SQLDenis: I know it's undocumented but it's the best thing I've come across that deals with the issue I need to resolve, so, drop, create, rename etc. won't do the trick (pleaz read below). I'm sure the statement is correct, something else must be wrong. SQLSister: Well, I'm not interested in...
  5. Naqibuquo

    drop identity of column

    my problem i'm facing is relevant to a closed thread (thread183-1149286). The script provided works fine and table access is also fine untill... the SQL service is restarted. From then on, the object seems not to be accesible anymore and the following error message appears when a SELECT...

Part and Inventory Search

Back
Top