CHAR(13) + CHAR(10)
VD:
DECLARE @sql varchar(8000)
SET @sql = 'SELECT * INTO SINvw_Budget_Yesterday FROM HKGvw_Budget_Yesterday'
SET @sql = @sql + CHAR(13) + CHAR(10) +'GO' + CHAR(13) + CHAR(10)
SET @sql = @sql + 'sp_rename ''SINvw_Budget_Yesterday.HKDActual'', ''SGDActual'', ''column'''
PRINT @sql
EXEC(@sql)
