{"id":353,"date":"2017-09-19T23:25:09","date_gmt":"2017-09-19T23:25:09","guid":{"rendered":"http:\/\/www.manualsqlserver.com\/?p=353"},"modified":"2020-07-17T21:44:43","modified_gmt":"2020-07-17T21:44:43","slug":"funciones-definidas-por-el-usuario-ejemplo","status":"publish","type":"post","link":"https:\/\/manualsqlserver.com\/?p=353","title":{"rendered":"Funciones definidas por el usuario &#8211; Ejemplo"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/manualsqlserver.com\/wp-content\/uploads\/2017\/09\/ManualSQL_FDU_EjemploD.png\" alt=\"\" class=\"wp-image-958\" width=\"233\" height=\"204\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Obtener la cantidad de vocales y consonantes de un texto<\/strong><\/h2>\n\n\n\n<p>En una consulta a trav\u00e9s de internet nos pidieron hacer una funci\u00f3n que al darle una cadena de caracteres, reporte la cantidad de vocales y la cantidad de consonantes. Aqu\u00ed la soluci\u00f3n.<br><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><br><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-8212748961777604\" data-ad-slot=\"5919795031\"><br><script>&lt;br \/>      (adsbygoogle = window.adsbygoogle || []).push({});&lt;br \/> <\/script><\/p>\n\n\n\n<!--more-->\n\n\n\n<p>use Northwind<br>go<\/p>\n\n\n\n<p><strong>La funci\u00f3n creada es como sigue:<\/strong><\/p>\n\n\n\n<p>Create function dbo.fduRetornaVocalesConsonantes (@Palabra nvarchar(200)) &nbsp; returns nvarchar(100)<br>As<br>Begin<br>-- Quitar todos los espacios a la palabra<br>Declare @Dato nvarchar(200), @Letra nvarchar(1)<br>set @Dato = Upper(Replace(LTRIM(RTRIM(@Palabra)),' ',''))<br>-- Para el bucle<br>Declare @Inicio int, @TotalVocales int, @TotalConsonantes int<br>set @Inicio = 1<br>Set @TotalVocales = 0<br>set @TotalConsonantes = 0<br>while @Inicio &lt;= LEN(@Dato)<br>Begin<br>set @Letra = SUBSTRING(@Dato,@Inicio,1)<br>if @Letra in ('A','E','I','O','U')<br>Begin<br>Set @TotalVocales = @TotalVocales +1<br>End<br>Else<br>Begin<br>Set @TotalConsonantes = @TotalConsonantes +1<br>End<br>Set @Inicio = @Inicio +1<br>End<br>Declare @Resultado nvarchar(200)<br>Set @Resultado = 'La palabra ' + Upper(@Palabra) + ' tiene ' +<br>LTRIM(STR(@TotalVocales)) +' vocales y ' + LTRIM(Str(@TotalConsonantes)) + ' consonantes'<br>return @Resultado<br>End<br>go<br><br><script>&lt;br \/>      (adsbygoogle = window.adsbygoogle || []).push({});&lt;br \/> <\/script><\/p>\n\n\n\n<p><strong>Usando la funci\u00f3n definida por el usuario<\/strong><br>select dbo.fduRetornaVocalesConsonantes('Manual SQL Server Profesional')<br>go<\/p>\n\n\n\n<p>El resultado es:\u00a0<\/p>\n\n\n\n<p><strong>La palabra MANUAL SQL SERVER PROFESIONAL tiene 10 vocales y 16 consonantes<\/strong><\/p>\n\n\n\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-2636008503986218\" data-ad-slot=\"1902193434\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Obtener la cantidad de vocales y consonantes de un texto En una consulta a trav\u00e9s de internet nos pidieron hacer una funci\u00f3n que al darle una cadena de caracteres, reporte la cantidad de vocales y la cantidad de consonantes. Aqu\u00ed la soluci\u00f3n.<\/p><p><a class=\"more-link btn\" href=\"https:\/\/manualsqlserver.com\/?p=353\">Seguir leyendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":958,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[236,8],"tags":[29,30,67,53],"class_list":["post-353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-udffunciones","category-programacion","tag-fdu","tag-funciones","tag-funciones-deficidas-por-el-usuario","tag-sqlserver","nodate","item-wrap"],"_links":{"self":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=353"}],"version-history":[{"count":3,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/353\/revisions"}],"predecessor-version":[{"id":2122,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/posts\/353\/revisions\/2122"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=\/wp\/v2\/media\/958"}],"wp:attachment":[{"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/manualsqlserver.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}