fixin (fixin) wrote,
fixin
fixin

Как думаете, для чего этот запрос?



Собственно:


SELECT  COUNT(*) FROM _ReferenceChngR611
DELETE FROM _ReferenceChngR611 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR2057 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR1495 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR1611 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR1791 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR1569 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR2716 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChng2624   WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _InfoRgChngR1753 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _DocumentChngR1295 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _AccumRgChngR1815 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _ReferenceChngR246 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _ReferenceChngR2812 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
DELETE FROM _ReferenceChngR592 WHERE _NodeRRef IN (SELECT _IDRRef FROM _Node6 WHERE _Fld2424 = 1)
SELECT  COUNT(*) FROM _ReferenceChngR611

Tags:
Subscribe

promo fixin december 31, 2037 16:57 1420
Buy for 30 tokens
UPD: Друзья, в августе 2019 года блог переехал на http://fixinchik.ru. Welcome! Добро пожаловать в журнал Осипова Сергея Александровича, известного также как Fixin и Гений 1С. Рекомендую ознакомиться с Часто Задаваемыми Вопросами обо мне. Что я хочу в подарок - список. Мой проект "…
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 48 comments