to 琅琊观海:load能否如此用？怎么msdn上没有load table tablename这种用法：Loads a backup copy of one of the following: User database (LOAD DATABASE) Transaction log (LOAD TRANSACTION) Header information about the dump (LOAD HEADERONLY) Important The LOAD statement is included in Microsoft® SQL Server™ version 7.0 for backward compatibility. The LOAD statement is identical to the RESTORE statement. It is recommended that the RESTORE statement be used instead of the LOAD statement. In a future version of SQL Server, LOAD will not be supported. （不过我的msdn是1999年7月的，老了点）to yangzi(告别CSDN中):不能重建索引啊：（
可以从系统表里面吧他删除! delete from sysobjets where tablename=@kkkk
可以从系统表里面吧他删除! delete from sysobjets where tablename=@kkkk
Transaction log (LOAD TRANSACTION)
Header information about the dump (LOAD HEADERONLY) Important The LOAD statement is included in Microsoft® SQL Server™ version 7.0 for backward compatibility. The LOAD statement is identical to the RESTORE statement. It is recommended that the RESTORE statement be used instead of the LOAD statement. In a future version of SQL Server, LOAD will not be supported.
（不过我的msdn是1999年7月的，老了点）to yangzi(告别CSDN中):不能重建索引啊：（
delete from sysobjets where tablename=@kkkk
delete from sysobjets where tablename=@kkkk