代码:
create procedure xp_keypress @name char(10)
as
select * from userr where name like '@name%'
我想得到一个动态的like中参数"@name",请问各位大哥大姐怎么修改??
create procedure xp_keypress @name char(10)
as
select * from userr where name like '@name%'
我想得到一个动态的like中参数"@name",请问各位大哥大姐怎么修改??
as
select * from userr where name like @name+'%'
go