{"description":"T-SQL\u306e\u30a8\u30e9\u30fc\u51e6\u7406\u65b9\u91dd\u3092\u307e\u3068\u3081\u3066\u307f\u307e\u3057\u305f\u3002 1.\u66f4\u65b0\u306e\u7121\u3044\u30b9\u30c8\u30a2\u30c9\u306f\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u3057\u306a\u3044\u3002 SELECT\u3059\u308b\u3060\u3051\u306e\u30b9\u30c8\u30a2\u30c9\u306f\u3001\u30a8\u30e9\u30fc\u51e6\u7406\u3092\u305b\u305a\u306b\u305d\u306e\u307e\u307e\u4f8b\u5916\u3092\u4e0a\u306b\u6295\u3052\u308b\u3068\u547c\u3073\u51fa\u3057\u5074\u3067TRY-CATCH\u3057\u3084\u3059\u3044\u3067\u3059\u3002 2.SQLServer\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u304b\u3089\u547c\u3073\u51fa\u3059\u30b9\u30c8\u30a2\u30c9\u306fusp_RethrowError\u3092\u4f7f\u3046\u3002 \u3053\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u306e\u8a73\u7d30\u3092\u3092\u30b8\u30e7\u30d6\u306e\u5c65\u6b74\u306b\u6b8b\u3057\u305f\u3044\u3002usp_RethrowError\u3092\u4f7f\u3063\u3066\u6295\u3052\u76f4\u3059\u4f8b\u5916\u306eErrorMessage\u306b\u3001\u30ad\u30e3\u30c3\u30c1\u3057\u305f\u4f8b\u5916\u306e\u5185\u5bb9\u3092\u5c55\u958b\u3059\u308b\u3068\u30b8\u30e7\u30d6\u5c65\u6b74\u306b\u51fa\u3060\u305b\u307e\u3059\u3002usp_RethrowErro\u306fTRY\u2212CATCH\uff08SQLServer2005\u4ee5\u964d\uff09\u306eCATC\u2026","blog_url":"https://ledsun.hatenablog.com/","author_url":"https://blog.hatena.ne.jp/ledsun/","url":"https://ledsun.hatenablog.com/entry/20091008/1254969484","version":"1.0","blog_title":"@ledsun blog","categories":["SQLServer","\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9"],"provider_url":"https://hatena.blog","width":"100%","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fledsun.hatenablog.com%2Fentry%2F20091008%2F1254969484\" title=\"T-SQL\u306e\u30a8\u30e9\u30fc\u51e6\u7406\u65b9\u91dd - @ledsun blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","title":"T-SQL\u306e\u30a8\u30e9\u30fc\u51e6\u7406\u65b9\u91dd","author_name":"ledsun","type":"rich","published":"2009-10-08 11:38:04","height":"190"}