摘要： ALTER TABLE表名ALTER column 列名 varchar(35) NULL EXEC SP_RENAME 'TABLE.[old-column-name]','new-column-name' EXEC sp_rename 'old-table-name', 'new-table-n 阅读全文

摘要： select Row_Number() over( order by getdate() ) as SN,* from table exec sp_helptext spRpt_R169_v2 SELECT b.name as TableName,a.name as columnname From 阅读全文