----------------------------------------------------------------------------------------------

输出换行符：

print char(10);

----------------------------------------------------------------------------------------------

新增数据列：

alter table tableName add column columnName column_Type;

修改数据列:

alter table tableName alter column columnName column_Type;

表和列重命名

重命名表：EXEC sp_rename? 'old_tableName','new_tableName';

重命名列：EXEC sp_rename 'tableName.[old_ColumnName]','new_ColumnName','COLUMN';

----------------------------------------------------------------------------------------------

查询重复列 select dm,dmjbh,count(dm) from t_comn_ggdmz group by dm,dmjbh having count(dm)>1select dm,dmjbh having count(dm)>1select dm,dmjbh having count(dm)>1

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!