随笔分类 -  SqlServer

通过结果集生成新表
摘要：Oracle Create Table T_new as select * from Tab_oldSQL ServerSelect * into T_new from T_old表改名Oraclealter table t rename to T_IdNameSQL Server sp_rename 'T' ,'T_IdName'数据库改名exec sp_renamedb 'hrmsys... 阅读全文
posted @ 2014-05-27 15:21 不及格程序员 阅读(128) 评论(0) 推荐(0)