Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VARCHAR(MAX) - need equiv to MLINE(x,2)
Message
 
 
À
22/11/2007 12:21:01
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01270593
Message ID:
01270944
Vues:
22
I posted ufn_Mline at http://www.berezniker.com/display/SQL/Mline+UDF+-+Return+specific+line. It's more an example than finished UDF. I didn't do much testing on it. Keep in mind that in general UDFs are much sloower than built-in functions.
SELECT cname, 
		dbo.ufn_Mline(mnotes,1) AS cname1, 
		dbo.ufn_Mline(mnotes,2) AS cname2, 
		dbo.ufn_Mline(mnotes,3) AS cname3
	FROM vmax
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform