Paging sort stored procedure error, help

cv4bf5d65fd

ALTER PROCEDURE dbo.VerseLogPaging
The
@SortColumn as varchar (100) = null,
@StartRow as int = null,
@StopRow as int = null

AS

---- Create a table variable with an identifier column
declare @t_table table
(
[rownum] [int] IDENTITY (1, 1) Primary key NOT NULL,
[SortColumn] [varchar] (40),
[VerseNumber] [varchar] (20),
[SubmitTime] [datetime],
[VerseText] [varchar] (500),
[UserID] [varchar] (20)
)
declare @sql varchar (8000)

---- Stop processing the query after returning the specified number of @StopRow lines
Set RowCount @StopRow

---- Insert into table variable
set @sql = 'insert' + @ t_table + '([VerseNumber], [SubmitTime], [VerseText], [UserID]) SELECT [VerseNumber], [SubmitTime], [VerseText], [UserID] FROM ConstructionVerseLog order by' + @SortColumn
exec (@sql)

---- Return to the correct result
set @sql = 'SELECT * FROM' + @ t_table + 'WHERE rownum> =' + @ StartRow + 'ORDER BY rownum'
exec (@sql)

/ * SET NOCOUNT ON * /
RETURN

redfish119

Undeclared @t_table

fanfan1980

order by ['+ @ SortColumn +'] '

To

order by '+ @ SortColumn +' '

Remove [] try

redfish119

- -Or not

Anxious

fanfan1980

print @sql

--Print @sql and see

redfish119

No rows affected.
(0 row (s) returned)
No rows affected.
(0 row (s) returned)
Running [dbo]. [VerseLogPaging] (@SortColumn = versenumber, @StartRow = 5, @StopRow = 20).

Syntax error converting the varchar value 'ORDER BY rownum' to a column of data type int.
(20 row (s) affected)
(0 row (s) returned)
@RETURN_VALUE =
Finished running [dbo]. [VerseLogPaging].
The thread '(null) (56)' (0x800003cc) has exited with code 0 (0x0).
The program 'SQL Debugger: T-SQL' has exited with code 0 (0x0).

redfish119

insert @t_table
(
[VerseNumber], [SubmitTime], [VerseText], [UserID])
SELECT [VerseNumber], [SubmitTime], [VerseText], [UserID]
FROM ConstructionVerseLog
order by '+ @ SortColumn +'

---- Return to the correct result
set @ sql = @ sql +
'SELECT * FROM @t_table WHERE rownum> =' + @StartRow +
'ORDER BY rownum'
EXEC (@sql)
Set RowCount 0-it is better to add this sentence

fanfan1980

Syntax error converting the varchar value 'ORDER BY rownum' to a column of data type int.

--Data type conversion error

redfish119

SELECT * FROM @t_table WHERE rownum> = '+ @StartRow +

@StartRow declares an int type

fanfan1980

Paste the SQL statement of the stored procedure and the table structure of ConstructionVerseLog to see