Not able to Update stored proceduere

Question

i want to update the data of a column in the stored procedure

i have a table like this--

the table name is --

Sp_dubai_select_Artilce_all

and i want to update the data because it is having some errors in it like --

the $0 is the error i want to removce it and update the data like this--

please help me doing it

Naveen Bisht · Answer

what database are you using if you are using sql server then click on proc name and modify it and run it agian. else you can use sp_help 'procname ' command and change and run it again

Mohit Sharma · Answer

i have updated the procedure the fact is a stored procedure never be updated or edited the the table of that procedure get edited or dpdated for this i move to the table of this stored procedure and than run the command to replace and update the table than it will gets updated...... steps to update it .... go to the database (In my case it is SHARE)>>programmability>>stored procedure>>select Stored procedure name >>right click on name>>SCRIPT STORED PROCEDURE as>>create to>>new editor window now see the table name from which the stored procedure is taking the data i.e like this...... here the tb_articles is the table which we have to replace and update than go to this table in the dataase>>tables>>table name than right click on the table name move to select top 200 rows than run the update and replace command the stored procedure data will be updated .