Website.SearchForStockItems
Documentation | WideWorldImporters |
Schema | Website |
Name | SearchForStockItems |
Input/Output
Mode | Name | Data type | Description | |
---|---|---|---|---|
1 | IN | SearchText | nvarchar(1000) | |
2 | IN | MaximumRowsToReturn | int |
Script
CREATE PROCEDURE Website.SearchForStockItems @SearchText nvarchar(1000), @MaximumRowsToReturn int WITH EXECUTE AS OWNER AS BEGIN SELECT TOP(@MaximumRowsToReturn) si.StockItemID, si.StockItemName FROM Warehouse.StockItems AS si WHERE si.SearchDetails LIKE N'%' + @SearchText + N'%' ORDER BY si.StockItemName FOR JSON AUTO, ROOT(N'StockItems'); END; |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51