1-

update tblSodooreSanad  set fldday='01',fldmonth='01' ,fldYear='1396' ,fldDate='13960101' where id=106488


2-

BEGIN TRAN;

UPDATE s
SET s.fldDate  = CAST(f.fldDate AS int),
    s.fldYear  = SUBSTRING(CAST(f.fldDate AS varchar(8)), 1, 4),
    s.fldMonth = SUBSTRING(CAST(f.fldDate AS varchar(8)), 5, 2),
    s.fldDay   = SUBSTRING(CAST(f.fldDate AS varchar(8)), 7, 2)
FROM tblSodooreSanad s
JOIN tblForoosh f
  ON f.fldShomareSanad = TRY_CAST(s.fldSanad AS bigint)
WHERE LEN(CAST(ISNULL(s.fldDate, 0) AS varchar(20))) < 8
  AND s.fldType = 'foroosh'
  AND LEN(CAST(f.fldDate AS varchar(20))) = 8;

UPDATE s
SET s.fldDate  = CAST(b.fldDate AS int),
    s.fldYear  = SUBSTRING(CAST(b.fldDate AS varchar(8)), 1, 4),
    s.fldMonth = SUBSTRING(CAST(b.fldDate AS varchar(8)), 5, 2),
    s.fldDay   = SUBSTRING(CAST(b.fldDate AS varchar(8)), 7, 2)
FROM tblSodooreSanad s
JOIN tblBargashtAzForoosh b
  ON b.fldShomareSanad = TRY_CAST(s.fldSanad AS bigint)
WHERE LEN(CAST(ISNULL(s.fldDate, 0) AS varchar(20))) < 8
  AND s.fldType = 'bargashtazforoosh'
  AND LEN(CAST(b.fldDate AS varchar(20))) = 8;

COMMIT TRAN;



3-
update tblSodooreSanad set fldday='17',fldmonth='03' ,fldYear='1402' ,flddate='14020317' where fldSanad=2807