----------------------------------------------------------------------------------------------
输出换行符:
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 ,count(dm) from t_comn_ggdmz group by dm,dmjbh having count(dm)>1select dm,dmjbh ,count(dm) from t_comn_ggdmz group by dm,dmjbh having count(dm)>1