Mesdames et Messieurs,
Je bien voudrais vous proposer les fonctions Transact-SQL qui sont les suivants
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 ...
Plus de 2000 personnes ont déjà téléchargé ces fonctions. Qui sait, peut-être seront-ils utiles pour vous ?
Pour plus d'information, veuillez visiter http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Veuillez télécharger le fichier
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
Veuillez agréer, Mesdames et Messieurs, l'expression de mes meilleurs sentiments.
|
Envoyer cette page à un ami
Mon compte 
Recherche 
Accueil Forums
Posté le 18/05/2005 06:07 AM
Accueil CommunauTech