Alter table to increase max Len
My table name = tbl_Students
This table has a column ' Student_TEL1 ' nvarchar(50)
How can I change the max lenght from (50) to (200)? - Without losing DATA
Many thanks
This table has a column ' Student_TEL1 ' nvarchar(50)
How can I change the max lenght from (50) to (200)? - Without losing DATA
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Vitor Montalvão
Btw, why are you using NVarchar? Do you need Unicode for that column? This will use double of bytes that you'll need for regular Varchar data type.
ASKER
Many thanks. The NvarChar was because of foreign chars.
@Author - Have you tried the code I had given ?