SQL test

Sql code posted
created at 29 Mar 08:23

Edit | Back 
1
2
3
4
5
6
7
8
 
UPDATE PgBuildings SET PgBuildings.IdOrganization = 43
WHERE PgBuildings.IdOrganization in (39, 40, 42, 90);

UPDATE PgUsers  SET PgUsers.IdOrganization = 43
WHERE PgUsers.IdOrganization in (39, 40, 42, 90);

DELETE FROM PgOrganizations 
WHERE PgOrganizations.IdOrganization in (39, 40, 42, 90);
302 Bytes in 2 ms with coderay