Dear Team,
how to write search store procedure in sql for following table
like of contact list search by name ,mobileno, in sigle query
create table Person
(
ContactID INT,
FirstName NVARCHAR(50),
LastName NVARCHAR(50),
EmailAddress NVARCHAR(50),
EmailPromotion INT,
Phone NVARCHAR(25),
)