Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Return value in store procedure
Imran Bashir
Jul 30 2016 6:45 PM
235
Reply
i have this store procedure and i want to make this that will return the value to asp .net application when it is true or false
=====================================
ALTER proc [dbo].[sp_Stock_check]
@sum int ,
@product_id int
as
begin
SELECT product_id
, COUNT(stock_in) as Count_stockIn
, COUNT(stock_out) as Count_stockOut
, SUM(stock_in) as Sum_stockIn
,
SUM(stock_out)+ @sum AS Sum_StockOut,
CASE WHEN SUM(stock_in) >= (SUM(stock_out)+@Sum) THEN 'true' ELSE 'false' END AS IsInGreater
From Stock
Group By product_id
having product_id = @product_id
end
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Regular expression exception
Return Value from Stored Procedure To asp .net