{"id":548,"date":"2012-02-09T13:24:49","date_gmt":"2012-02-09T12:24:49","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=548"},"modified":"2012-02-09T14:16:00","modified_gmt":"2012-02-09T13:16:00","slug":"sql-server-anzahl-nachkommastellen-ermitteln","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=548","title":{"rendered":"SQL Server: Anzahl Nachkommastellen ermitteln"},"content":{"rendered":"<h1>Aufgabe<\/h1>\n<p>Es sollen die Anzahl der Nachkommastelle in einem SQL Query abgefragt werden<\/p>\n<h1>L\u00f6sung<\/h1>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSELECT * FROM completeyear2011ecoflac \r\nWHERE \r\nright(cast(completeactualyear as varchar(32)), \r\n  len(cast(completeactualyear as varchar(32))) \r\n - charindex(&#039;.&#039;,cast(completeactualyear as varchar(32))))&gt;0\r\n<\/pre>\n<h1>Beurteilung<\/h1>\n<p>Wenn die SQL-Umgebung keine Funktion zur Verf\u00fcgung stellt, kann man die obige SQL zwar nutzen,  sollte den hinteren Teil allerdings in eine Funktion auslagern. Das Auslagern in eine Funktion dient der \u00dcbersichtlichkeit und verletzt das DRY-Prinzip nicht (Don&#8217;t repeat yourself!)<\/p>\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fwww.capri-soft.de%2Fblog%2F%3Fp%3D548&amp;layout=standard&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px;margin-top:5px;\"><\/iframe>","protected":false},"excerpt":{"rendered":"<p>Aufgabe Es sollen die Anzahl der Nachkommastelle in einem SQL Query abgefragt werden L\u00f6sung SELECT * FROM completeyear2011ecoflac WHERE right(cast(completeactualyear as varchar(32)), len(cast(completeactualyear as varchar(32))) &#8211; charindex(&#039;.&#039;,cast(completeactualyear as varchar(32))))&gt;0 Beurteilung Wenn die SQL-Umgebung keine Funktion zur Verf\u00fcgung stellt, kann man die obige SQL zwar nutzen, sollte den hinteren Teil allerdings in eine Funktion auslagern. Das &hellip; <a href=\"https:\/\/www.capri-soft.de\/blog\/?p=548\" class=\"more-link\"><span class=\"screen-reader-text\">SQL Server: Anzahl Nachkommastellen ermitteln<\/span> weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11],"tags":[],"class_list":["post-548","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4yGeN-8Q","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=548"}],"version-history":[{"count":5,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/548\/revisions"}],"predecessor-version":[{"id":551,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/548\/revisions\/551"}],"wp:attachment":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}