alter table product ALTER COLUMN proid nvarchar(15)
alter table alter column proid nvarchar(15) null
alter table tb alter column proid nvarchar(15)
表:product 其中一字段名:proid 类型:bigint 小弟想把其类型换为 nvarchar(15) --- alter table product alter column proid nvarchar(15) 接分了
-- 15个字符不够存BIGINT alter table product alter column proid nvarchar(19) --or alter table product alter column proid varchar(19)
create table product(proid bigint) insert into product select 9223372036854775807 alter table product alter column proid varchar(19) select * from product9223372036854775807
其中一字段名:proid 类型:bigint
小弟想把其类型换为 nvarchar(15)
---
alter table product alter column proid nvarchar(15) 接分了
-- 15个字符不够存BIGINT
alter table product alter column proid nvarchar(19)
--or
alter table product alter column proid varchar(19)
insert into product select 9223372036854775807
alter table product alter column proid varchar(19)
select * from product9223372036854775807