How to set Connection String in Web.Config

---- LOCAL ----
<appSettings>
<add key="ConnectionString" value="Data Source=SERVER NAME;Initial Catalog=DATA BASE NAME;Integrated Security=True"/>
</appSettings>

---- LIVE ----
<appSettings>
<add key="ConnectionString" value="Data source=SERVER IP;Database=DATABASE NAME;Uid=DB USER ID;Password=DB PASSWORD"/>
</appSettings>

Using a temporary table in dynamic sql in a stored procedure

SET NOCOUNT ON

Declare @Sql Nvarchar(max),@Sql1 Nvarchar(max)

CREATE TABLE #tmpCity (CityIDP BigInt, CityName Varchar(50))

SET @Sql = 'INSERT INTO #tmpCity SELECT CityIDP, CityName  FROM mCity'
EXEC(@Sql)
SELECT @@ROWCOUNT
SET @Sql1 = 'SELECT * FROM #tmpCity'
EXEC(@Sql1)
GO
drop table #tmpCity