ALTER PROCEDURE dbo.queryequipment
(
@condition nchar(100),
@commpany nchar(100)
)
AS
BEGIN
SELECT * FROM equipment WHERE name like '%'+ @condition+'%' and commpany=@commpany
END
结果报错:''附近有语法错误,莫斯回事哦,我看好多都是这个样子写的沙
赐教!
(
@condition nchar(100),
@commpany nchar(100)
)
AS
BEGIN
SELECT * FROM equipment WHERE name like '%'+ @condition+'%' and commpany=@commpany
END
结果报错:''附近有语法错误,莫斯回事哦,我看好多都是这个样子写的沙
赐教!
@condition nchar(100),
@commpany nchar(100)
)AS
BEGIN
SELECT *
FROM equipment
WHERE name like '%'+ @condition+'%' and commpany=@commpany
END
FROM equipment WHERE name like '%'+ @condition+'%' and commpany=@commpany