用as,就是取别名,比如select name as 名字 from table 这里NAME就是中文了
select aa as 姓名,bb as 工号
用法如下:
sp_addextendedproperty
[ @name = ] { 'property_name' }
[ , [ @value = ] { 'value' }
[ , [ @level0type = ] { 'level0_object_type' }
, [ @level0name = ] { 'level0_object_name' }
[ , [ @level1type = ] { 'level1_object_type' }
, [ @level1name = ] { 'level1_object_name' }
[ , [ @level2type = ] { 'level2_object_type' }
, [ @level2name = ] { 'level2_object_name' }
]
开一列remark...
表里面没法加注释
只有查询出来的时候可以给别名