Create procedure loadGrid() as begin select *from custdetails end
CREATE PROCEDURE loadGrid() BEGIN SELECT * FROM custdetails; END
CREATE PROCEDURE [dbo].[loadGrid] AS BEGIN SELECT * FROM custdetails END GO
DELIMITER @@ create procedure usp_sum_of_sales( IN pro_id int ) begin select sum(Price) from Sales where Product_id =pro_id group by Product_id ; end call usp_sum_of_sales (200);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)