1 - SQL

-

SQL 1, SQL . . , -.

1) SQL 1

2) SQL 1 (,  _Reference185 .)

3) 1 (,  0x9E80A570B3B742FB44770FC3B9C6ACCD ""   .)

4) - sqlformat.org

:

:

:

1

RLS,   .

: 1 1.3, , , .

:

   100
 .,
 .,
 .

 .  
( ):

, . , , RLS , (->-> ). , 1ѻ, , 1. , , SQL. , , .

T7._TYPE = 0x08

AND T7._RTRef = 0x000000B5

AND T7. = T1.

AND T7. = T1.

T9._TYPE = 0x08

AND T9._RTRef = 0x000000B6

AND T9. = T1.

T9. = T1.

1 .

SQL

1ѻ, T-SQL SQL Server Management Studio , SQL ( SQL ). :

( 1ѻ):

SQL 1 T-SQL.

2

, . : 1.4 . . DBMSSQL , ( . , .epf). :

:

, .., ( ) :

( ):

, RLS 3 ( WHERE EXISTS() ) .    T1 . , , 2 . . T4 , , , . T12 .. , , , RLS , .

3

SQL 1. , . , , , .


	.,
	.1,
	.

	..((2017, 5, 1), (2017, 5, 31),  = &, , )  

( ) :

( ):

, , . :

1) . , ( , :))

2) #tt2, , , ( ). , .

3) #tt3, 1000 #tt2, ( )

4) #tt4 #tt3 , , , .

5) #tt5 #tt4 , , . .

6) #tt1 #tt4 #tt5. 1 #tt5, : _AccEdKindLineNo 1, _Correspond . #tt4.

7) ,

8) #tt3 1000 #tt2

9) #tt3. ( 4-9)

10) #tt1

, , 1000 , ( ).

2 :

, ( D:\ \TraceTest). , ( TraceTest_54.trc)

SQL ( DRIVER={SQL Server};SERVER=PC_1C_003;UID=sa;PWD=123;DATABASE=Localbase). , .

1, SQL , SQL .

, , , . SQL , 1, 1 .

:

:

: //1c-soft.it-terminal.ru/public/15126/

: https://its.1c.ru/db/metod8dev#content:5896:hdoc

ADO : //1c-soft.it-terminal.ru/public/343268/

1 SQL:
.epf 31,70Kb
27.06.17
64
.epf 1.0 31,70Kb 64

.

1. (Gilev.Vyacheslav) 1737 28.06.17 09:53
2. bulpi bulpi (bulpi) 110 28.06.17 12:58
! ? !
WellMaster; sqncng; JohnConnor; maksa2005; JohnyDeath; kuzyara; kare; +7 1 3
3. (swimdog) 444 28.06.17 15:21
.
tormozit; +1 1
4. p m (pm74) 5 28.06.17 15:26
5. (Synoecium) 197 28.06.17 16:30
(2) :)

(3) , , .
+
6. (tormozit) 4320 28.06.17 19:28
?
-
-
-
-
-
-
CSiER; artbear; +2 1
7. (igomark) 28.06.17 19:40
, -, !
+
8. S KoR (Tanis) 28.06.17 20:17
!

! !

!
+
9. Q (kuzyara) 268 29.06.17 05:20
(6)
-

?

- ...
10. Q (kuzyara) 268 29.06.17 05:48
11. (ArchLord42) 58 29.06.17 07:14
, !
+
12. (tormozit) 4320 29.06.17 07:24
(9)
" "
kuzyara; +1
13. segen segen (1segen1) 27 29.06.17 09:50
! - .
+
14. (user774630) 29.06.17 12:48
(2) , , :)
JohnyDeath; +1 1
15. (Yashazz) 2096 29.06.17 12:57
(2) ? , . . .
+
16. (Yashazz) 2096 29.06.17 13:00
17. (JohnyDeath) 290 29.06.17 14:15
(14) )
+
18. (Serg O.) 133 29.06.17 15:03
8.3 ?

8.2 - !

{.SQL1.(26,22)}: (JSON)
JSON = <<?>>JSON;
19. tixis1c tixis1c (qwed557) 26 29.06.17 19:50
(18)
JSON

8.2 JSON? .
+
20. (Synoecium) 197 30.06.17 06:27
(18) , JSON 1 8.3.6 https://helpf.pro/faq82/view/1664.html
- JSON , 8.2. . . " -", .
+

  • (117)
  • (140)
  • (348)
  • (224)
  • (408)

  • (1325)
  • (4520)
  • (558)
  • (132)
  • (190)
  • (2597)
  • (235)
  • (151)

  • (209)
  • (53)
  • (5516)
  • (2190)
  • (466)
  • (165)
  • (1491)
  • , (555)

  • - (122)
  • (47)
  • (17)
  • (232)
  • (492)
  • (187)
  • (44)
  • (278)

  • (1142)
  • (464)
  • (68)
  • (123)
  • (29)
  • (3178)
  • (1123)
  • (131)
  • (252)
  • (398)

  • (55)
  • (339)
  • (5034)
  • (387)
  • (447)
  • (80)
  • (371)
  • (303)

  • (144)
  • (292)
  • (126)
  • (22)
  • (133)
  • (70)