1.复制数据表。原样复制。 select * into new_tb from old_tb
2012版本
select * into [pccw].[dbo].[tb_pccw20130911] from [pccw].[dbo].[tb_pccw20130905]
select * into new_tb from old_tb where 1<>1
复制表结构
删除表中所有的数据记录:delete from table1
Powered by: 博客园 Copyright © 2024 股墓山庄庄主 Powered by .NET 9.0 on Kubernetes