Update all columns in one update

--Procedure to Update all columns in a given table (@Source) w/ Join from another Table (@Dest)
    CREATE PROCEDURE UPDATE_ALL

    @SOURCE VARCHAR(100),
    @DEST VARCHAR(100),
    @ID VARCHAR(100)

    AS

        DECLARE @SQL VARCHAR(MAX) =  

        'UPDATE D SET ' +

        -- Google 'for xml path stuff' This gets the rows from query results and 
        -- turns into comma separated list.
        STUFF((SELECT ', D.'+ COLUMN_NAME + ' = S.' + COLUMN_NAME
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE TABLE_NAME = @DEST
        AND COLUMN_NAME <> @ID 
        FOR XML PATH('')),1,1,'')

        + ' FROM ' + @SOURCE + ' S JOIN ' + @DEST + ' D ON S.' +  @ID + ' = D.' + @ID

        --SELECT @SQL
        EXEC (@SQL)
    
    
    
    --usage: 
    	EXEC UPDATE_ALL 'source_table','destination_table','id_column'
    
    
    
   -- Here's a hardcore way to do it with SQL SERVER. Carefully consider security and integrity before you try it, though.
    --This uses schema to get the names of all the columns and then puts together a big update statement to update all columns except ID column, which it uses to join the tables.
    --This only works for a single column key, not composites.

Source: stackoverflow.com

Update all column fileds

  $users = DB::table('mails')->distinct('mark')->count('mark');
             
             if ($users == 1){    
                 $mark = Mails::all();
                 $mark->mark = '0';
                 $mark->save();
                 
                 echo 'reset values to 0';
             }else{
                 
                 echo 'DIferent values';
             }

Source: laracasts.com

Similar codes

0 vote340 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote326 views1 answer
Mysql config slave
SQL
0 vote307 views1 answer
Oracle last connection
SQL
1 vote338 views1 answer
Sql group by sum with condition
SQL
1 vote345 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote393 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote321 views1 answer
How to put is null in where in clause
SQL
0 vote361 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote425 views1 answer
How to show current database in mysql
SQL
0 vote328 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL