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

    Possible to concate strings for column names in UPDATE statment

    Invicta.<br><br>I quote an example.<br><br>declare @str1 = 'First'<br>declare @str2 = 'Name'<br>declare @command varchar(100)<br><br>I need it to update the column name
  2. joblue

    Possible to concate strings for column names in UPDATE statment

    Is it possible to have this in an UPDATE statement?<br><br>UPDATE table SET @str1+@str2 = '001'<br><br>I got the result of &quot;1 row affected&quot; <br>But when I try to select that column, it wasn't updated.<br>The result remains NULL.<br><br>Thank you.

Part and Inventory Search

Back
Top