语句是这样的:
SELECT ItemId,ItemName,Price,Descrn,Saletime
FROM Items
WHERE ItemName LIKE ' @ItemName %' -------------这里把参数这样处理行不?
请高手指教
SELECT ItemId,ItemName,Price,Descrn,Saletime
FROM Items
WHERE ItemName LIKE ' @ItemName %' -------------这里把参数这样处理行不?
请高手指教
FROM Items
WHERE ItemName LIKE @ItemName+'%'