Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE CountProduct
- @OrderID nvarchar(255),
- @NbProducts int OUT --biến output thì thêm chữ OUT
- AS
- BEGIN --thân PROCEDURE trong BEGIN END;
- SET @NbProducts = --gán giá trị vào biến dùng SET
- (
- SELECT COUNT([OrderDetails].[ProductID])
- FROM [OrderDetails]
- WHERE [OrderID] = @OrderID
- )
- END;
- /*
- declare @t int
- exec CountProduct 'CA-2014-100391', @t output
- print @t
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement