SQl喜欢查询查找名字或First&姓氏在喜欢 [英] SQl Like Query Find First Name Or First & last Name In Like

问题描述

如果Pass FirstName显示所有Match FirstName记录使用Like

&If Pass First&LastName显示所有匹配记录使用like

sql Query For If Pass FirstName Display All the Match FirstName record using Like
& If Pass First & LastName Display All the Match Record using like

推荐答案

这并不难：

It's not difficult:

DECLARE @FNAME NVARCHAR(MAX)
DECLARE @LNAME NVARCHAR(MAX)
DECLARE @SP INT
SET @SP = CHARINDEX (' ', @Name)
IF (@SP = 0)
   SELECT * FROM MyTable WHERE FirstName = @Name
ELSE
   BEGIN
   SET @FNAME = SUBSTRING(@NAME, 0, @SP)
   SET @LNAME = SUBSTRING(@NAME, @SP, 9999)
   SELECT * FROM MyTable WHERE FirstName = @FNAME AND LastName = @LNAME
   END

如果你想根据存储过程的参数使用不同的条件我将使用两个完全独立的参数。一个用于名字，另一个用于姓氏。这使得逻辑更容易，你不需要开始拆分和解释单个字符串参数。



类似

If you want to use different conditions based on the parameters of the stored procedure I would use two completely separate parameters. One for the first name and another for the last name. This makes the logic much easier and you don't need to start splitting and interpreting the single string parameter.

Something like

create procedure names @first varchar(100), @last varchar(100) as
begin
   if @last is null
      select * from table_name where first_name like @first
   else
      select * from table_name where first_name like @first and last_name like @last
end

这篇关于SQl喜欢查询查找名字或First&姓氏在喜欢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！