数据库表中字段的传递
select distinct * into #Tmp from tableName
drop table tableName
select * into tableName from #Tmp
drop table #Tmp
数据库的恢复(有备份文件)
use master
RESTORE LOG 空间数据库实验二 FROM DISK='D:\新建文件夹\MSSQL14.SQLEXPRESS01\MSSQL\DATA\空间数据库实验二.bak'
WITH RECOVERY,STOPAT='2019-11-11 8:00:10'