sqlserver 数据库操作备忘录

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

输出换行符：

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