mydb, Sql Server - rextester

Language: Layout:

create table CurrencyTbl (CurrencyID int identity(1,1), CurrencyName varchar(30), Rupee decimal(19,6), Euro decimal(19,6), Dollar decimal(19,6), Pound decimal(19,6));
set identity_insert CurrencyTbl on;
insert into CurrencyTbl (CurrencyId, CurrencyName, Rupee, Euro, Dollar, Pound) values 
 (1,'Rupee ',1, 0.008, 0.009, 0.007)
,(2,'Euro  ',121.3, 1, 1.08, 0.84)
,(3,'Dollar',111.4, 0.91, 1, 0.77)
,(4,'Pound ',143.6, 1.18, 1.28, 1);
set identity_insert CurrencyTbl off;
go
CREATE PROC addCurrency @CurrencyName  varchar(30),@Rupee float,
@Euro float,@Dollar float,@Pound float
    AS
    BEGIN
    INSERT into [dbo].[CurrencyTbl] (CurrencyName , Rupee,Euro, Dollar,Pound ) 
    VALUES (@CurrencyName,@Rupee,@Euro,@Dollar,@Pound )
    END
    BEGIN
    Declare @SQL nVarChar(1000)
    SELECT @SQL = 'ALTER TABLE [dbo].[CurrencyTbl] ADD ' + @CurrencyName + ' decimal(19,6);'
    exec sp_executesql @SQL;
    END
    BEGIN
	DECLARE @SQL2 nVarChar(1000)
	SELECT @SQL2 = 'update [dbo].[CurrencyTbl] set '+@CurrencyName+' = CAST(''@Rupee'' AS float)  WHERE CurrencyName = ''Rupee''';
	exec sp_executesql @SQL2;	
	END
go
exec addCurrency 'Monies',2.5,2,2,7
go
select * from CurrencyTbl

View schema
Absolute service time: 0,17 sec