SELECT [drug ID] AS 药品编号,[drug name] AS 药品名称,price AS 单价,danwei AS 单位 ,cunliang AS 存量 FROM 药房表 WHERE ( [drug ID] like '%'+@Drug_ID+'%' OR [drug name] LIKE '%'+@Drug_Name+'%' ) AND @Drug_Class=[drug class]
[drug name] LIKE '%'+@Drug_Name+'%' 这一句是不是有问题, 我上边写的有什么错吗? 我就算只用这一个查询条件也出不来结果的.应该不是优先级问题.
CREATE PROCEDURE HUAJIASHOUFEI @Drug_Name char(20),@Drug_ID char(20),@Drug_Class char(10) AS SELECT [drug ID] AS 药品编号,[drug name] AS 药品名称,price AS 单价,danwei AS 单位 ,cunliang AS 存量 FROM 药房表 WHERE @Drug_ID= [drug ID] OR [drug name] LIKE ('%'+@Drug_Name+'%') AND @Drug_Class=[drug class] GO EXEC HUAJIASHOUFEI
WHERE ( [drug ID] like '%'+@Drug_ID+'%' OR [drug name] LIKE '%'+@Drug_Name+'%' )
AND @Drug_Class=[drug class]
我上边写的有什么错吗?
我就算只用这一个查询条件也出不来结果的.应该不是优先级问题.
AS
SELECT [drug ID] AS 药品编号,[drug name] AS 药品名称,price AS 单价,danwei AS 单位 ,cunliang AS 存量 FROM 药房表
WHERE @Drug_ID= [drug ID] OR [drug name] LIKE ('%'+@Drug_Name+'%') AND @Drug_Class=[drug class]
GO
EXEC HUAJIASHOUFEI