Updating a database stored procedure Sex free lo
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community create proc UPDATE_PRODUCT @ID_CAT INT, @ID_PRODUCT VARCHAR(30), @LABEL NVARCHAR(30), @QTE INT, @PRICE VARCHAR(50), @IMG IMAGE AS UPDATE [Product_DB].[dbo].[PRODUCTS] SET [ID_CAT] = @ID_CAT ,[LABEL_PRODUCT] = @LABEL ,[QTE_IN_STOCK] = @QTE ,[PRICE] = @PRICE ,[IMAGE_PRODUCT] = @IMG WHERE ID_PRODUCT = @ID_PRODUCT When I run this code the first time, it says "completed successfully" However, I can't find it in Stored Procedure folder.I tried to do multiple refreshes and restarts but still the same.This parameter is constructed dynamically by the stored procedure and its contents can vary. If the parameter type is a table-value type, READONLY must be specified.RECOMPILE Indicates that the Database Engine does not cache a plan for this procedure and the procedure is recompiled at run time.
As stored procedure code is saved in the database, you may reuse it without re-writing the code – thus saving time.
Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Is the data type of the parameter and the schema it belongs to.
Suppose, you are using this database with a web application or any other front-end application.
The form used by the users shows current data as well as gives the option to update the records.