Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old November 13th, 2008, 06:21 AM
MaliciousMatt MaliciousMatt is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2008
Posts: 2 MaliciousMatt User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 5 sec
Reputation Power: 0
Search Stored Procedure

Hi guys,

I'm trying to create a stored procedure to search a database based on a first name. I have come up with the following but it does not seem to be working. Can anyone tell me why?

Code:
ALTER PROCEDURE usp_Search
@SearchText nchar(10)
AS
BEGIN
SELECT     dbo.Person.PersonID, dbo.Person.FirstName, dbo.Person.LastName, dbo.Person.ExtID, dbo.Person.Mobile, dbo.Position.Position_Name, 
                      dbo.Section.Section_Name, dbo.Division.Division_Name
FROM         dbo.Person INNER JOIN
                      dbo.Extension ON dbo.Person.ExtID = dbo.Extension.ExtID INNER JOIN
                      dbo.Position ON dbo.Person.PositionID = dbo.Position.Position_ID INNER JOIN
                      dbo.Section ON dbo.Person.SectionID = dbo.Section.Section_ID INNER JOIN
                      dbo.Division ON dbo.Section.Division_ID = dbo.Division.Division_ID
WHERE Person.FirstName LIKE '%' + @SearchText + '%'


END  

Reply With Quote
  #2  
Old December 14th, 2008, 09:16 PM
doug_pearce doug_pearce is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2008
Posts: 2 doug_pearce User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 55 m 35 sec
Reputation Power: 0
One thing I noticed is that you are joining to an Extension table but you are not pulling any fields from that table. You may not need to link that table. That may be an issue if you do not have any related records in that table. That goes that same for all the tables you are joining. Make sure you have related records in those tables.

Also, what exactly do you mean by it is not working? Is it just that no records are being returned or a specific error is being returned?

Reply With Quote
  #3  
Old April 4th, 2009, 08:25 AM
MaliciousMatt MaliciousMatt is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2008
Posts: 2 MaliciousMatt User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 5 sec
Reputation Power: 0
Solved. The parameter needed to be varchar as it was inputting as if it had spaces after it which is why records were coming back weird... so say, if i entered matthew it would come out 'matthew '

Thanks.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Search Stored Procedure


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.

Request Your Free Technology Downloads!
 
Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.

Request Your Free Technology Downloads!
 
Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.

Request Your Free Technology Downloads!
 
Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.

Request Your Free Technology Downloads!
 
Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.

Request Your Free Technology Downloads!
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2010 by Developer Shed. All rights reserved. DS Cluster 2 Hosted by Hostway
For more Enterprise Application Development news, visit eWeek