我想实现如下的sql语句:
select pid,pname
from products
where pid like 'T11%'
就是查询pid以"T11"开头的记录。存储过程我写成如下,结果不是我想要的,怎么修改呢?CREATE PROCEDURE [dbo].[get_product_list]
@kid varchar(20)
AS
BEGIN
select pid,pname
from products
where pid like ''''+@kid+'%'+''''
END
select pid,pname
from products
where pid like 'T11%'
就是查询pid以"T11"开头的记录。存储过程我写成如下,结果不是我想要的,怎么修改呢?CREATE PROCEDURE [dbo].[get_product_list]
@kid varchar(20)
AS
BEGIN
select pid,pname
from products
where pid like ''''+@kid+'%'+''''
END
@kid varchar(20)
AS
BEGIN
exec('select pid,pname
from products
where pid like '''+@kid+'%''')
END
@kid varchar(20)
AS
BEGIN
select pid,pname
from products
where pid like @kid+'%'
END