Update database table-Stored Procedure

And also learned about the stored procedure. Create procedure hvc_chatroom_updatetopic
(
@ Topic_id int,
@ Title nvarchar (255 ),
@ Summary nvarchar (2000 ),
@ Time datetime,
@ Guests nvarchar (255 ),
@ Imgurl nvarchar (255)
)
As
Update hvc_chatroom_topicslist
Set

Intitle = @ title,
Insummary = @ summary,
Inguests = @ guests,
Intime = @ time,
Inimgurl = @ imgurl
Where topicid = @ topic_id

Go

When updating data, you must clearly specify the type and length of the data item. If you do not specify the length, the system will take only the first character by default.
The data type and length must be consistent with the type length defined at the time of table creation.