Untitled
unknown
sql
2 years ago
536 B
5
Indexable
do $$ begin if not exists (select "Id" from "NsSedAddressee" where "SfTerritorialAuthorityId" = '51a5523e-f606-45f3-a554-a6010715e346') then insert into "NsSedAddressee"("CreatedOn", "CreatedById", "ModifiedOn", "ModifiedById", "SfTerritorialAuthorityId", "NsMedoUserId", "NsMedoUserPass") values ('2023-08-02 11:50:00.000', '410006e1-ca4e-4502-a9ec-e54d922d2c00', '2023-08-02 11:50:00.000', '410006e1-ca4e-4502-a9ec-e54d922d2c00', '51a5523e-f606-45f3-a554-a6010715e346', '10763312', '12345'); end if; end; $$ language PLPGSQL;
Editor is loading...