{"id":344,"date":"2023-09-27T14:26:23","date_gmt":"2023-09-27T11:26:23","guid":{"rendered":"https:\/\/kb.astrocroc.com\/?p=344"},"modified":"2023-09-27T14:26:23","modified_gmt":"2023-09-27T11:26:23","slug":"%d0%b4%d0%be%d0%b1%d0%b0%d0%b2%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-%d0%b7%d0%b0%d0%bf%d0%b8%d1%81%d0%b8-%d0%b2-mssql","status":"publish","type":"post","link":"https:\/\/kb.astrocroc.com\/?p=344","title":{"rendered":"\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 MSSQL"},"content":{"rendered":"\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-cs\" data-line=\"\">string query = @&quot;declare @strText varchar(200),\n@sCdName varchar(60)\n\nselect @sCdName = CD_Name\nfrom CompanyDepartment\nwhere CD_Key = &quot; + legalID + @&quot;\n\nset @strText = &#039;\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0430 &#039; + @sCdName\n\nInsert into History(HI_DgCod, HI_Date, HI_Who, Hi_Mod, HI_Text)\nVALUES(&#039;&quot; + order.Text + @&quot;&#039;, GetDate(), user_name(), &#039;UPD&#039;, @strText)&quot;;\n\nvar MTConnection = new SqlConnection(connStr);\nMTConnection.Open();\n\nSqlCommand MTCommand = MTConnection.CreateCommand();\nMTCommand.CommandText = query;\nMTCommand.CommandType = CommandType.Text;\n\nMTCommand.ExecuteReader();\n\nMTConnection.Close();\nMTConnection.Dispose();<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[61],"class_list":["post-344","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=344"}],"version-history":[{"count":1,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/344\/revisions"}],"predecessor-version":[{"id":345,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=\/wp\/v2\/posts\/344\/revisions\/345"}],"wp:attachment":[{"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.astrocroc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}