Monday, 12 April 2021

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;

No comments:

Post a Comment

redirect to new page from jquery

  function foo(id) { var url = ' @Url . Action ( "Details" , "Branch" , new { id = "__id__" })'...