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\';