UPdate with join query

 UPDATE

    dbo.USERS

SET

    dbo.USERS.UserName = 

       CONCAT(t.FName,t.LName)

FROM 

    dbo.USERS c

    INNER JOIN dbo.PROFILES t

        ON c.Email = t.Email;

Delete All Stored Procedure -from database in Sql server

 DECLARE @spname sysname;

DECLARE SPCursor CURSOR FOR
SELECT SCHEMA_NAME(schema_id) + '.' + name
FROM sys.objects
WHERE type = 'P';
OPEN SPCursor;
FETCH NEXT FROM SPCursor INTO @spname;
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC('DROP PROCEDURE ' + @spname);
FETCH NEXT FROM SPCursor INTO @spname;
END
CLOSE SPCursor;
DEALLOCATE SPCursor;