DEV Community

Md: Shariar haque
Md: Shariar haque

Posted on

Store Procedure for getting all Items from Item table MSSQL

use Shop; -- table name shop
CREATE PROCEDURE AllItems -- procedure name AllItems
AS
SELECT *FROM Item
GO;

EXEC AllItem; -- retrive procedure

Top comments (0)