Sunday, March 30, 2014

SQL: Create temp table without declaring and add new column or remove existng column

select * into #temptest from existingTable

alter table #temptest add LoantypeID int

alter table #temptest  drop column InstallmentType 

drop table #temptest

No comments: