ALTER TABLE ##tmpmxz_123 ADD pg1 varchar(1) go UPDATE ##tmpmxz_123 SET pg1 ='1' SELECT * INTO ##tmpmxzb FROM ##tmpmxz_123 ORDER BY bz1, rq, bz2 UPDATE ##tmpmxzb SET pg1 = '1' SELECT * FROM ##tmpmxzb
alter table ##tb add [name] varchar(10) go update ##tb set [name]='222' select * from ##tb id name ----------- ---------- 1 222
ALTER TABLE ##tmpmxz_123 ADD pg1 varchar(1)
这个格式没问题,不知道执行这个语句有何提示?
add 是对的
就是在add pg1 varchar(1)
后加上go就可以了!
go UPDATE ##tmpmxz_123 SET pg1 ='1' SELECT *
INTO ##tmpmxzb
FROM ##tmpmxz_123
ORDER BY bz1, rq, bz2 UPDATE ##tmpmxzb
SET pg1 = '1' SELECT *
FROM ##tmpmxzb
go
update ##tb set [name]='222'
select * from ##tb
id name
----------- ----------
1 222