{"id":177,"date":"2006-12-21T11:56:34","date_gmt":"2006-12-21T09:56:34","guid":{"rendered":"http:\/\/soci.hu\/blog\/index.php\/2006\/12\/21\/mikor-megy-vissza-a-raiserror-kimenete-a-kliensre-sql-server-2005\/"},"modified":"2006-12-21T11:56:34","modified_gmt":"2006-12-21T09:56:34","slug":"mikor-megy-vissza-a-raiserror-kimenete-a-kliensre-sql-server-2005","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2006\/12\/21\/mikor-megy-vissza-a-raiserror-kimenete-a-kliensre-sql-server-2005\/","title":{"rendered":"Mikor megy vissza a RAISERROR kimenete a kliensre (SQL Server 2005)?"},"content":{"rendered":"<p><font size=\"3\"><font face=\"Calibri\">When RAISERROR is run with a severity of 11 or higher in a TRY block, it transfers control to the associated CATCH block. The error is returned to the caller if RAISERROR is run:<br \/>\n<\/font><\/font>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <font size=\"3\"><font face=\"Calibri\">Outside the scope of any TRY block. (m\u00e9g sz\u00e9p)<br \/>\n<\/font><\/font>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <font size=\"3\"><font face=\"Calibri\">With a severity of 10 or lower in a TRY block. (Inf\u00f3message-eket nem nyeli le, azok visszamennek, mint rowcount vagy print kimenete)<br \/>\n<\/font><\/font>\u00b7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <font size=\"3\"><font face=\"Calibri\">With a severity of 20 or higher that terminates the database connection. (\u00e9rthet\u0151)<\/font><\/font><\/p>\n<p><font face=\"Calibri\" size=\"3\">\u00a0<\/font><\/p>\n<p><font size=\"3\"><font face=\"Calibri\">Azaz a TSQL try\/catch lenyeli a hib\u00e1kat, hasonl\u00f3an, mint ahogy a C<span lang=\"EN-US\"># try\/catch lenyel egy exceptiont. A catchben azt\u00e1n raiserrorral lehet saj\u00e1t hib\u00e1t visszaadni a h\u00edv\u00f3nak, ala rethrow. Valami\u00e9rt az \u00e9n fejemben (valamelyik beta alapj\u00e1n) az volt, hogy a try\/catch ellen\u00e9re is visszamennek a hib\u00e1k a kliensre, de szerencs\u00e9re ez nem \u00edgy van. \u00d6r\u00fcl\u00fcnk.<\/span><\/font><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When RAISERROR is run with a severity of 11 or higher in a TRY block, it transfers control to the associated CATCH&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,21],"tags":[],"class_list":["post-177","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-sql-server-2005"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=177"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/177\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}