Tuesday

sql split string 


DECLARE @t VARCHAR(50)
SET @t = '3333-4'
SELECT LEFT(@t, CHARINDEX('-', @t) - 1), RIGHT(@t, LEN(@t) - CHARINDEX('-', @t))

more...
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

imagemagic add text to image

rem different types of text annotations on existing images rem cyan yellow orange gold rem -gravity SouthWest rem draw text and anno...