select field1=oldField, field2=oldField2 into newTableName from oldTableName
Muf(沐枫)说得对! SELECT * INTO Newtable FROM oldtable
//新字段=老字段 //新的,不存在的表名称(目标) //源表 select field1=oldField, field2=oldField2 into newTableName from oldTableName where oldField1='you condition' 我试过了。SQL数据库
对,楼上的兄弟说的对。用 select......into...... 就可以的
select ...into...在tquery里能用吗?????不能的! 在tquery里应该用insert into ....select ...。
就象FOX里亽“COPY TO 文件名 ON 条件” 一样
SELECT * INTO Newtable
FROM oldtable
select field1=oldField, field2=oldField2 into newTableName from oldTableName
where oldField1='you condition'
我试过了。SQL数据库
在tquery里应该用insert into ....select ...。