SQL query create stored procedure error 'Incorrect syntax'

Question

I use sql to create the stored procedures , but I get an error " Incorrect syntax near ' = ' " And here is my code

CREATE PROC [dbo].[sp_T_CATEGORY_GetByTop]
@top nvarchar(10),
@where nvarchar(200),
@order nvarchar(200)
AS
    DECLARE @SQL AS NVARCHAR(500)
    SELECT @SQL = 'SELECT TOP ('+@top+') * FROM [T_CATEGORY]'
    IF LEN(@top) = 0
        BEGIN
            SELECT @SQL = 'SELECT * FROM T_CATEGORY'
        END
    IF LEN(@where) > 0
        BEGIN
            SELECT @SQL = @SQL + 'WHERE' + @where
        END
    IF LEN(@order) > 0
        BEGIN
            SELECT @SQL = @SQL + 'ORDER BY' + @order
        END
        EXEC(@SQL)

thanks everyone.

Pரதீப் · Accepted Answer · 2015-03-05 07:09:13Z

4

You need space before and after where and order by

IF LEN(@where) > 0
    BEGIN
        SELECT @SQL = @SQL + ' WHERE ' + @where
    END
IF LEN(@order) > 0
    BEGIN
        SELECT @SQL = @SQL + ' ORDER BY ' + @order
    END

answered Mar 5, 2015 at 7:09

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query create stored procedure error 'Incorrect syntax'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related