User-Defined Funciones de la Secuencia Transact-SQL

02/05/2005 - 18:35 por Igor2004 | Informe spam
Senoras y Senores

Quisiera poner a su alcance las funciones de Transact-SQL que vienen a
continuacion.
GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
AT() Returns the beginning numeric position of the first occurrence of a
character expression within
another character expression, counting from the leftmost character
RAT() Returns the numeric position of the last (rightmost) occurrence of a
character string within
another character string
OCCURS() Returns the number of times a character expression occurs within
another character expression
PADL() Returns a string from an expression, padded with spaces or
characters to a specified length on the left side
PADR() Returns a string from an expression, padded with spaces or
characters to a specified length on the right side
PADC() Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides
PROPER() Returns from a character expression a string capitalized as
appropriate for proper names
RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but
the search of which is on the right
ARABTOROMAN() Returns the character Roman number equivalent of a specified
numeric expression
ROMANTOARAB() Returns the number equivalent of a specified character Roman
number expression ...

For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wcon...velExtreme~2,54,33,27115


Por favor tome el archivo
http://www.universalthread.com/wcon...velExtreme~2,2,27115

Quisiera agradecerles a Ustedes toda vuestra atencion y mis mejores
sentimientos.
 

Leer las respuestas

#1 Maxi
03/05/2005 - 00:45 | Informe spam
Gracias!!!


Maxi - Buenos Aires - Argentina
Desarrollador 3 Estrellas
Msn:

Maxi.da[arroba]gmail.com

"Igor2004" escribió en el mensaje
news:
Senoras y Senores

Quisiera poner a su alcance las funciones de Transact-SQL que vienen a
continuacion.
GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
AT() Returns the beginning numeric position of the first occurrence of a
character expression within
another character expression, counting from the leftmost character
RAT() Returns the numeric position of the last (rightmost) occurrence of a
character string within
another character string
OCCURS() Returns the number of times a character expression occurs within
another character expression
PADL() Returns a string from an expression, padded with spaces or
characters to a specified length on the left side
PADR() Returns a string from an expression, padded with spaces or
characters to a specified length on the right side
PADC() Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides
PROPER() Returns from a character expression a string capitalized as
appropriate for proper names
RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but
the search of which is on the right
ARABTOROMAN() Returns the character Roman number equivalent of a specified
numeric expression
ROMANTOARAB() Returns the number equivalent of a specified character Roman
number expression ...

For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wcon...velExtreme~2,54,33,27115


Por favor tome el archivo
http://www.universalthread.com/wcon...velExtreme~2,2,27115

Quisiera agradecerles a Ustedes toda vuestra atencion y mis mejores
sentimientos.

Preguntas similares