Separador de miles sql

SELECT CAST(CONVERT(VARCHAR, CAST(123456 AS MONEY), 1) AS VARCHAR)
SELECT REPLACE(CONVERT(VARCHAR, CONVERT(MONEY, 123456), 1), '.00', '')


DECLARE @BigNumber BIGINT
SET @BigNumber = 1234567891234

SELECT REPLACE(CONVERT(VARCHAR,CONVERT(MONEY,@BigNumber),1), '.00','')



fuente
fuente2

separador de miles y decimal

monto_ingreso = Double.Parse(dr.ItemArray(5)).ToString("N")

12.345,67



fuente

Obtener el separador decimal

Dim p As String = CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator