Professional Web Applications Themes

Why do I get an error? - Microsoft SQL / MS SQL Server

Print out the statement and the error should be visible. Does this help DECLARE depName NVARCHAR(100) set depName='SELECT * FROM dep_list WHERE name LIKE ''%' + name + '%'' AND Department_ID <> ' + char(39) + Department_ID + char(39) + ' ORDER BY name' -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Raanan Avidor" <com> wrote in message news:#phx.gbl...  AND ...

  1. #1

    Default Re: Why do I get an error?

    Print out the statement and the error should be visible.

    Does this help

    DECLARE depName NVARCHAR(100)
    set depName='SELECT * FROM dep_list WHERE name LIKE ''%' + name + '%'' AND
    Department_ID <>
    ' + char(39) + Department_ID + char(39) + ' ORDER BY name'

    --

    ----------------------------
    Allan Mitchell (Microsoft SQL Server MVP)
    MCSE,MCDBA
    www.SQLDTS.com
    I support PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org



    "Raanan Avidor" <com> wrote in message
    news:#phx.gbl... 
    AND 


    Allan Guest

  2. #2

    Default Re: Why do I get an error?

    Without table structure all I can do is suggest you to try this:

    CREATE PROCEDURE spd_search_dep
    (
    name NVARCHAR(30),
    Department_ID NVARCHAR(20)
    )

    as

    SET NOCOUNT ON

    DECLARE depName NVARCHAR(100)

    set depName = 'SELECT * FROM dep_list WHERE name LIKE ''%' + name + '%'' AND
    ''' + Department_ID + ''' <> Department_ID ORDER BY name'


    execute(depName)

    GO

    --
    Dean Savovic
    www.teched.hr


    "Raanan Avidor" <com> wrote in message news:%phx.gbl... 


    Dean Guest

  3. #3

    Default Why do I get an error?

    Hello.

    I've got a stored procedure:

    CREATE PROCEDURE spd_search_dep
    (
    name NVARCHAR(30),
    Department_ID NVARCHAR(20)
    )
    As
    SET NOCOUNT ON
    DECLARE depName NVARCHAR(100)
    set depName='SELECT * FROM dep_list WHERE name LIKE''%' + name + '%'' AND
    ' + Department_ID + ' != Department_ID ORDER BY name'
    execute(depName)
    GO

    When I search for
    Sales Administration, WW

    I get this error:
    Invalid column name 'n'
    I don't have a column called 'n'!

    Help?

    Raanan.


    Raanan Guest

Similar Threads

  1. Replies: 0
    Last Post: March 29th, 09:49 PM
  2. Replies: 0
    Last Post: November 10th, 05:24 PM
  3. Replies: 0
    Last Post: September 25th, 03:23 AM
  4. Replies: 1
    Last Post: August 7th, 07:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139