SQLServer 中的存储过程中判断临时表是否存在,存在则删除临时表
1 2 3 4 5 6 7 8 9 10 |
|
ALTER TABLE #TEMP3 ADD ID INT IDENTITY(1,1)
给临时表加上自增ID
------------------------- A little Progress a day makes you a big success... ----------------------------
1 2 3 4 5 6 7 8 9 10 |
|
ALTER TABLE #TEMP3 ADD ID INT IDENTITY(1,1)
给临时表加上自增ID
------------------------- A little Progress a day makes you a big success... ----------------------------