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
    in SQL Server
    Please explain how to build.
    See more | Go to post

      Leave a comment:

    • tdority
      started a topic mssql 2000 update from select
      in SQL Server

      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...