how to increase the values of varchar colum

Question

how to increase the value of varchar columns and assing the specific pattern code is the cannot the increment my store procedure is that ALTER PROCEDURE [School].[GetRegisterationNumber] AS begin declare @StudentRegNo nvarchar(50) set @StudentRegNo=(select MAX(StudentRegNo)from School.StudentInformation) if @StudentRegNo is null begin set @StudentRegNo='OXPS-0001' select @StudentRegNo end else begin select 'OXPS'+'-'+RIGHT('0000'+ convert(varchar(10),@StudentRegNo),4) --set @StudentRegNo=SCOPE_IDENTITY() end end

Mageshwaran R · Answer

Hi, Try this Query: ALTER TABLE TB_NAME ALTER COLUMN COLUMN_NAME VARCHAR (432)

Rafnas T P · Answer

but i do not think you need to give max size for student registration no, 50 or 100 character is more for that, i think you need to give this size in your table colum then follow my before comment there i have given how to change table column size I hope it helps Thank you

Rafnas T P · Answer

hi, if you wanted to increase below nvarchar value declare @StudentRegNo nvarchar(50) then just change that into how much character you want for example 200 characters then' declare @StudentRegNo nvarchar(200) if you do not know how much size would be and it will be more then below line declare @StudentRegNo nvarchar( max ) and acordingly you have to change your database table column lenght by using below line, here I am asuming column is studentregno and table name is tblstudent alter table tblstudent alter column studentregno varchar (200); or alter table tblstudent alter column studentregno varchar ( max );

Raghavendar Swaminathan · Answer

Hi Habib, You can go with Murugan instructions where as use can use the varchar(max) to avoid the fixed length size. Thanks Raghav

Mohan Arumugam · Answer

ALTER TABLE 'table_name' CHANGE COLUMN 'col_name' VARCHAR(500); It will work but i never have tried it

how to increase the values of varchar colum

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)