Saturday, December 14, 2019

thousands separator for a column 

SELECT REPLACE(CONVERT(VARCHAR, CONVERT(MONEY, TotalArea), 1), '.00', '') 
FROM table
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

base 64 convert to image

public Image LoadImage() {     //data:image/gif;base64,     //this image is a single pixel (black)     byte[] bytes = Convert.FromBase6...