alter table countlist alter column c_memo nvarchar(MAX)
#000000
alter table productlist alter column p_name nvarchar(MAX) alter table producttype alter column pt_memo nvarchar(MAX) alter table protofree alter column freeproid1 nvarchar(MAX) alter table ActionLog alter column Remark nvarchar(MAX) alter table ActionLog alter column Remark nvarchar(MAX) alter table cache_app alter column value nvarchar(MAX) alter table domaintrans alter column whoisbody nvarchar(MAX) alter table Free alter column f_content nvarchar(MAX) alter table HostRental alter column Memo nvarchar(MAX) alter table HostRental alter column weihulist nvarchar(MAX) alter table mailsitelist alter column m_agent nvarchar(MAX)
#000001
alter table ShopCart alter column addtime datetime
#000002
update UserDetail set u_resumesum=0 where u_resumesum is nullupdate UserDetail set u_usemoney=0 where u_usemoney is nullupdate UserDetail set u_Invoice=0 where u_Invoice is null
#000003
update userdetail set u_remcount=0 where u_remcount is null
#000004
update userdetail set u_borrormax=0 where u_borrormax is null
#000005
update countlist set u_in=0 where u_in is null
#000006