Display Indian Rupees & Indian Language in SSMS

We will use Format function which returns a value formatted with the specified format and optional culture. This function will use three parameter i.e Value, format & Culture.

FORMAT ( value, format [, culture ] )

SQL Script to display Indian Rupee & USD:

DECLARE @currency money = 9876.54;
SELECT @currency NoFilter,
FORMAT(@currency, 'C', 'en-us') 'en-us',
FORMAT(@currency, 'C', 'en-in') 'en-in'

SQL Script to display in Indian Languages:

DECLARE @currency datetime = GETDATE();
SELECT
FORMAT(@currency, 'D', 'en-us') 'en-us',
FORMAT(@currency, 'D', 'hi-in') 'hi-in',
FORMAT(@currency, 'D', 'gu-in') 'gu-in',
FORMAT(@currency, 'D', 'pa-in') 'pa-in';