可以 create proc xx @tiaojian varchar(50) as select * form table where fields like '%'+@tiaojian+'%"
create proc xx @tiaojian varchar(50) as select * form table where fields like '%'+@tiaojian+'%'
我编写了存储过程,无法执行,没办法用了sql语句实现。 seleCT Article_Publish.ArticleID, Article_Publish.Title, Article_Publish.Content, Article_Editiones.EditionDes,Account_User.UserName, Article_Publish.Author,Article_Publish.DatePub FROM Article_Publish INNER JOIN Article_Editiones ON Article_Publish.EditionID = Article_Editiones.EditionID INNER JOIN Account_User ON Article_Publish.DepartmentID = Account_User.UserID WHERE Article_Publish.EditionID = '1' AND Article_Publish.Title LIKE '%e%' ORDER BY Article_Publish.ArticleID DESC;
create proc xx @tiaojian varchar(50)
as
select * form table where fields like '%'+@tiaojian+'%"
as
select * form table where fields like '%'+@tiaojian+'%'
seleCT Article_Publish.ArticleID, Article_Publish.Title, Article_Publish.Content, Article_Editiones.EditionDes,Account_User.UserName, Article_Publish.Author,Article_Publish.DatePub
FROM Article_Publish INNER JOIN Article_Editiones ON
Article_Publish.EditionID = Article_Editiones.EditionID INNER JOIN Account_User ON
Article_Publish.DepartmentID = Account_User.UserID
WHERE Article_Publish.EditionID = '1' AND Article_Publish.Title LIKE '%e%'
ORDER BY Article_Publish.ArticleID DESC;