SQL Update Table Script

SET NOCOUNT ON;


Update [schema_name].[maintable_name]
SET 
 column_name1 = C.column_name
,column_name2 = C.column_name
,column_name3  = C.column_name
FROM [schema_name].[maintable_name] W
JOIN [schema_name].[jointable_name] C 
ON C.columnnameId = W.columnnameId 


select ? = @@ROWCOUNT;