column alter problm
-
hai all, i have a table named 'applcn', it conatin near 100 field i want to alter one column to not null for that i use the folllowing query
alter table applcn alter column txtreforg3 nvarchar not nullbut it show error like Server: Msg 8152, Level 16, State 6, Line 1 String or binary data would be truncated. The statement has been terminated. how i slovw this???urgent All I ever wanted is what others have.... CrazySanker -
hai all, i have a table named 'applcn', it conatin near 100 field i want to alter one column to not null for that i use the folllowing query
alter table applcn alter column txtreforg3 nvarchar not nullbut it show error like Server: Msg 8152, Level 16, State 6, Line 1 String or binary data would be truncated. The statement has been terminated. how i slovw this???urgent All I ever wanted is what others have.... CrazySankerHi i believe your statement 'alter table applcn alter column txtreforg3 nvarchar not null' does not specify the column length which its will automatically give a default length value = 1 for txtreforg3 which you already has some data more than length = 1 So i suggest you make your statement 'alter table applcn alter column txtreforg3 nvarchar(x) not null' x = depend the max length of your data in table. :) -C-?-M-