how to increase the values of varchar colum

habib ullah

8y933

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]

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this Query:
ALTER TABLE TB_NAME ALTER COLUMN COLUMN_NAME VARCHAR (432)
Rafnas T P8y ago
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 P8y ago
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 Swaminathan8y ago
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 Arumugam8y ago
ALTER TABLE 'table_name'
CHANGE COLUMN 'col_name' VARCHAR(500);

It will work but i never have tried it