34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @P1 varchar
set @P1='CAFG3'
SELECT TOP (200) orderno, customid, detilid, Ordernum, idd, ordate
FROM orders
WHERE (Ordernum LIKE '%'+@P1+'%') order by orderno
--加个order by
DECLARE @P1 varchar(100)--定义类型别忘记长度 否则默认为1 了 即 @P1='C'
set @P1='CAFG3'
SELECT TOP (200) orderno, customid, detilid, Ordernum, idd, ordate
FROM orders
WHERE (Ordernum LIKE '%'+@P1+'%')