store procedure

Question

My Question is can we change column datatype of store procedure after creation?

Shubham Kumar · Answer

Ramya Firstly proc have not any column it have parameters if you want to change the parameter datatype so its possible just alter the proc as your desire change after datatype

Shubham Kumar · Answer

No You have to do like this before -- on creating time create procedure sp_insertdata @someParameter varchar(20) As begin --your query end ------------------------------------ after -- on altering time Alter procedure sp_insertdata @someParameter varchar(10) As begin --your query end and execute it

Ramya S · Answer

Here i want to change the varchar (size) from 1 to 10 of the parameter how to do ex:alter proc sp_insertdata alter @name varchar(20)