你即將離開本站

並前往https://www.reddit.com/r/SQL/comments/ng1txl/can_i_loop_through_name_of_columns_in_update/

Can I loop through name of columns in Update Table query?

Yes you can absolutely use a loop & dynamic SQL to do this. BEGIN WHILE SET @COL = (SELECT ColName FROM @Table WHERE ID = @LOOP) DECLARE @SQL varchar(MAX) ...

確定！ 回上一頁

查詢 「SQL loop table」的人也找了：

  1. SQL loop table
    2.
  2. SQL loop SELECT
    3.
  3. SQL loop insert
    4.
  4. T SQL loop SELECT result
    5.
  5. MySQL For LOOP SELECT
    6.
  6. SQL WHILE loop
    7.
  7. SQL Server WHILE loop from SELECT
    8.
  8. SQL for loop list
    9.