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)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay