1、CREATE PROCEDURE dbo.SearchUserInfo
(@Age?? int )
AS
SELECT * FROM UserInfo WHERE Age like '%'+cast(@Age as nvarchar(50))+'%'
RETURN
2、
CREATE PROCEDURE dbo.Mfx_SearchUserInfo
--用戶搜索[state-審核狀態(2為全部)、UserLever-用戶級別(0為全部)、keyWord(關鍵字)]
@state int,
@UserLever int,
@keyWord nvarchar(50)

AS
begin
declare @sql nvarchar(4000)
set @sql=' select *,(select nvLeverName from UserLever?? where?? UserInfo.iUserLeverID=UserLever.id) as nvLeverName from UserInfo where (1=1) '
?? if(@state=2)
??? begin
???? if(@UserLever=0)
????? begin
????? set @sql=@sql
????? end
???? else
????? begin
????? set @sql=@sql+' and iUserLeverID='+char(39)+cast(@UserLever as nvarchar(50))+char(39)
????? end
??? end
?? else
??? begin
???? if(@UserLever=0)
????? begin
????? set @sql=@sql+' and iStateID='+char(39)+cast(@state as?? nvarchar(50)) +char(39)
????? end
???? else
????? begin
????? set?? @sql=@sql+' and iStateID='+char(39)+cast(@state as nvarchar(50))+char(39) +'?? and?? iUserLeverID='+char(39)+cast(@UserLever as?? nvarchar(50))+char(39)
????? end
??? end
end
set @sql=@sql+'AND( nvName?? like'+char(39)+'%'+@keyWord+'%'+char(39)+'or nvUserName?? like'+char(39)+'%'+@keyWord+'%'+char(39)+'or?? nvPhone?? like'+char(39)+'%'+@keyWord+'%'+char(39)+'or?? nvIdentityCard?? like'+char(39)+'%'+@keyWord+'%'+char(39)+')'+'order by UserInfo.ID?? desc '
exec(@sql)

轉載于:https://www.cnblogs.com/tiantangwater/archive/2008/12/24/1361706.html

總結

以上是生活随笔為你收集整理的搜索连接字符串存储过程【原创】的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。