Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’

by

The @search should be an input parameter of the stored proc, (no Declare required), and you need an As between the signature block for the stored proc and the body of the proc.

Create PROCEDURE [dbo].[usp_cloud_ClientAllSearch]
 @Search NVARCHAR(30)
As

   SELECT client_Name, client_Surname, client_CompanyName, 
        clientContact_TelephoneNo, clientContact_MobileNo, 
        clientAddress_PostalCode
   FROM cloud_Client c
       Join dbo.cloud_ClientAddresses a
          ON a.client_ID = c.client_ID
       LEFT JOIN cloud_ClientContact cc
          ON cc.client_ID = c.client_ID
   WHERE c.client_Name LIKE @Search + '%' or 
         c.client_Surname LIKE @Search + '%' or 
        cc.clientContact_MobileNo LIKE @Search + '%' or 
         a.clientAddress_PostalCode LIKE @Search + '%'

More Related Contents:

  1. Add a column with a default value to an existing table in SQL Server
  2. NULL values inside NOT IN clause
  3. SQL MAX of multiple columns?
  4. Table Naming Dilemma: Singular vs. Plural Names [closed]
  5. Simplest way to do a recursive self-join?
  6. How to calculate percentage with a SQL statement
  7. A table name as a variable
  8. Group by column and multiple Rows into One Row multiple columns
  9. How to set table name in dynamic SQL query?
  10. TSQL PIVOT MULTIPLE COLUMNS
  11. Find the smallest unused number in SQL Server
  12. Can a sql server table have two identity columns?
  13. Saving changes after table edit in SQL Server Management Studio
  14. Logging ALL Queries on a SQL Server 2008 Express Database?
  15. SQL query to find Nth highest salary from a salary table
  16. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  17. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  18. Should I use SQL_Variant data type?
  19. Get the records of last month in SQL server
  20. Log record changes in SQL server in an audit table
  21. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  22. alternatives to REPLACE on a text or ntext datatype
  23. How can I backup a remote SQL Server database to a local drive?
  24. Getting the Id of a row I updated in Sql Server
  25. Zero SQL deadlock by design – any coding patterns?
  26. SQL – How do I get only the numbers after the decimal?
  27. How to retrieve records for last 30 minutes in MS SQL?
  28. Connecting to Oracle Database using Sql Server Integration Services
  29. Why do SQL Server Scalar-valued functions get slower?
  30. Executing SQL query on multiple databases

Leave a Comment