修改Sql Server字段类型

由于人员的不段增加varchar(5000)已经不能满足需求，现在的方案是把字段类型由varchar改为text

1 --修改短信人员字段
2 alter table T_BAS_SendMessage alter column [Content] text
3 alter table T_BAS_SendMessage alter column ReceiveInsideName text
4 alter table T_BAS_SendMessage alter column ReceiveInsideLoginName text
5 alter table T_BAS_SendMessage alter column ReceiveOutsideName text
6 alter table T_BAS_SendMessage alter column ReceiveOutsidePhone text
7 alter table T_BAS_SendMessage alter column WeChatUniqueLogo text
8 alter table T_BAS_SendMessage alter column WeChatNumber text
9 go

View Code

微软的说法是用这个数据类型来代替之前的text、ntext 和 image 数据类型，它们之间的对应关系为：

varchar(max)-------text;

nvarchar(max)-----ntext;

varbinary(max)----image.

建议使用varchar(max)代替text

1 alter table T_BAS_SendMessage alter column [Content] varchar(max)
2 alter table T_BAS_SendMessage alter column ReceiveInsideName varchar(max)
3 alter table T_BAS_SendMessage alter column ReceiveInsideLoginName varchar(max)
4 alter table T_BAS_SendMessage alter column ReceiveOutsideName varchar(max)
5 alter table T_BAS_SendMessage alter column ReceiveOutsidePhone varchar(max)
6 alter table T_BAS_SendMessage alter column WeChatUniqueLogo varchar(max)
7 alter table T_BAS_SendMessage alter column WeChatNumber varchar(max)
8 go

View Code

顶

Top

关注