{"id":336,"date":"2017-04-28T20:30:24","date_gmt":"2017-04-28T16:30:24","guid":{"rendered":"https:\/\/bukleev.ru\/?page_id=336"},"modified":"2018-12-14T07:59:22","modified_gmt":"2018-12-14T03:59:22","slug":"%d0%be%d0%bf%d1%80%d0%b5%d0%b4%d0%b5%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-%d0%b7%d0%b0%d1%8f%d0%b2%d0%be%d0%ba-%d0%b4%d0%bb%d1%8f-%d1%83%d0%b4%d0%b0%d0%bb%d0%b5%d0%bd%d0%b8%d1%8f-%d0%b8-%d1%83%d0%b4%d0%b0","status":"publish","type":"page","link":"https:\/\/bukleev.ru\/?page_id=336","title":{"rendered":"\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u044f\u0432\u043e\u043a \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0438\u0445 \u0438\u0437 \u043f\u0440\u0438\u043b\u0438\u043d\u043a\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u0431\u0430\u0437\u044b MySQL \u0432 MSSQL"},"content":{"rendered":"<p>\u0412 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u044b 2 \u043a\u0443\u0440\u0441\u043e\u0440\u0430, \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u0438\u043c\u0435\u0440\u0430!<\/p>\n<p>\u0412\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u043a\u043e\u0434 \u0432 MSSQL \u0442\u0430\u043a:<\/p>\n<pre>DECLARE @SQLtext nvarchar(max)\r\nDECLARE @SQLmysql nvarchar(max)\r\n\r\n---------- 1 -------------------\u041d\u0430\u0447\u0430\u043b\u043e------------------\r\n SET @SQLtext = 'Select id from ticket where queue_id = <em><strong>3<\/strong><\/em>' \r\n SET @SQLtext = 'SELECT id FROM OPENQUERY(OTRS, '+ CHAR(39) + @SQLtext + CHAR(39) +') AS derivedtbl_1'\r\n\r\n create table #dataset([id] [bigint])\r\n insert #dataset exec (@SQLtext)\r\n\r\n DECLARE @id bigint\r\n DECLARE @id_a bigint\r\n DECLARE @MySQLT nvarchar(max)\r\n \r\n DECLARE #db CURSOR FOR Select id from #dataset order by id\r\n OPEN #db FETCH #db INTO @id\r\n while @@FETCH_STATUS &lt;&gt; -1 \r\n begin \r\n DECLARE @idt nvarchar(20)\r\n SET @idt = CAST(@id as nvarchar(20))\r\n\r\n DROP TABLE #dataset_a\r\n\r\n SET @SQLtext = 'Select id from article where ticket_id = ' + @idt \r\n SET @SQLtext = 'SELECT id FROM OPENQUERY(OTRS, '+ CHAR(39) + @SQLtext + CHAR(39) +') AS derivedtbl_1'\r\n create table #dataset_a([id] [bigint])\r\n insert #dataset_a exec (@SQLtext)\r\n DECLARE #db_a CURSOR FOR Select id from #dataset_a\r\n OPEN #db_a FETCH #db_a INTO @id_a\r\n while @@FETCH_STATUS &lt;&gt; -1 \r\n begin \r\n DECLARE @T nvarchar(max)\r\n DECLARE @idt_a nvarchar(20)\r\n SET @idt_a = CAST(@id_a as nvarchar(20))\r\n SET @MySQLT = 'SELECT * FROM OPENQUERY(OTRS, '+ CHAR(39) + 'CALL `otrs`.`DeleteArticleByID`(#####);' + CHAR(39) +') AS derivedtbl_1'\r\n SET @T = REPLACE(@MySQLT,'#####', @idt_a )\r\n EXEC (@T)\r\n FETCH #db_a INTO @id_a \r\n end \r\n CLOSE #db_a DEALLOCATE #db_a\r\n DROP TABLE #dataset_a\r\n \r\n SET @MySQLT = 'SELECT * FROM OPENQUERY(OTRS, '+ CHAR(39) + 'CALL `otrs`.`DeleteTicketByID`(#####);' + CHAR(39) +') AS derivedtbl_1'\r\n SET @T = REPLACE(@MySQLT,'#####', @idt )\r\n EXEC (@T)\r\n FETCH #db INTO @id \r\n end \r\n CLOSE #db DEALLOCATE #db\r\n---------- 1 --------------------\u043e\u043a\u043e\u043d\u0447\u0430\u043d\u0438\u0435-----------------<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0412 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u044b 2 \u043a\u0443\u0440\u0441\u043e\u0440\u0430, \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u0438\u043c\u0435\u0440\u0430! \u0412\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u043a\u043e\u0434 \u0432 MSSQL \u0442\u0430\u043a: DECLARE @SQLtext nvarchar(max) DECLARE @SQLmysql nvarchar(max) &#8212;&#8212;&#8212;- 1 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-\u041d\u0430\u0447\u0430\u043b\u043e&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; SET @SQLtext = &#8216;Select id from ticket where queue_id = 3&#8217; SET @SQLtext = &#8216;SELECT id<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-336","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=336"}],"version-history":[{"count":5,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/336\/revisions"}],"predecessor-version":[{"id":342,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/336\/revisions\/342"}],"wp:attachment":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}