|
... = %s',0,0,@valuesOnly); DECLARE @Index INT; SET @Index = (SELECT CHARINDEX(@valuesOnly,N',')); RAISERROR(N'charindex of , = %i',0,0,@Index); [...] Input: Geometry = 'LINESTRING (-1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917)' Output: @valuesOnly = -1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917 charindex of , = 0 Msg 536, Level 16, State 5,...
http://community.livejournal.com/sqlserver/68109.html
0 links
Published: 1 year, 1 month ago (Wed, 12 Nov 2008 09:22:19 PST); 886 bytes
|
