[求助]基础语法问题
实现的功能:从表中查询出所需要的内容,然后建立一个虚表,删除实表,最后把虚表插入到新表中..
select Content into #test from (select top 4594 * from test where id not in (select top 1 id from test))
但是这条语句报错,不知道那里错了,,大家帮我改改看.
[解决办法]
select Content into #test from (select top 4594 * from test where id not in (select top 1 id from test)) aa --加一个别名
[解决办法]
select Content into #test from (select top 4594 * from test where id not in (select top 1 id from test)) a
[解决办法]
select bmh into #test from (select top 4594 * from rktz where xh not in (select top 1 xh from rktz)) aa 加一表名，我试过测试成功！！！
[解决办法]
select Content into #test from (select top 4594 * from test where id not in (select top 1 id from test)) aa --后面要随便加个别名！
