如何在下拉列表中添加建议? [英] how to add suggesstion in dropdownlist ?

问题描述

CREATE Procedure dropdownlist
(
mname varchar(200)
)
AS
select medicine_name FROM medicines where medicine_name like mname+'%'

我正在使用上面的查询在用户键入的下拉列表中显示值.
但它会收到错误.

请帮我看看这些.
在此先谢谢您.

I am using the above query to display values in dropdownlist which the user types.
but it recieves error.

Please help me to come out these.
Thanks in advance.

推荐答案

CREATE Procedure dropdownlist
(
@mname varchar(200)
)
AS
select medicine_name FROM medicines where medicine_name like @mname + '%'

使用符号(@)作为第一个字符来指定参数名称.参数名称必须符合标识符规则.
参考: http://msdn.microsoft.com/en-us/library /aa258259(v=sql.80).aspx [ ^ ]

Specify a parameter name using an at sign (@) as the first character. The parameter name must conform to the rules for identifiers.
Ref:http://msdn.microsoft.com/en-us/library/aa258259(v=sql.80).aspx[^]

这篇关于如何在下拉列表中添加建议?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！