User Profile

Collapse

Profile Sidebar

Collapse
tdority
tdority
Last Activity: Jul 11 '07, 07:05 PM
Joined: Jul 11 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • tdority
    replied to mssql 2000 update from select
    Please explain how to build.
    See more | Go to post

    Leave a comment:


  • tdority
    started a topic mssql 2000 update from select

    mssql 2000 update from select

    I am trying to update a table from a select statement, any suggestions?

    update (select column1 from table1)
    set column2 = 'value'

    The data in column1 contains the name of the table I want to update column2 with the 'value'.

    I'm am pretty sure the syntax is in correct along with the structure. The error...

    Server: Msg 170, Level 15, State 1, Line 2
    Line 2: Incorrect syntax near...
    See more | Go to post
No activity results to display
Show More
Working...