过程 * 转换成数据类型 int 时失败。解决方案

USE [JOauth]GO/****** Object:  StoredProcedure [dbo].[Query_SapplicationInfoList]    Script Date: 04/26/2012 12:32:28 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[Query_SapplicationInfoList](    @startpage INT,     --起始行    @endpage INT,     --结束行    @uid CHAR(36) --用户ID)AS    DECLARE @strsql VARCHAR(4000)        BEGIN        SET @strsql = ' SELECT TOP (' + CAST(@endpage AS VARCHAR) + ' - ' + CAST(@startpage AS VARCHAR)            +            ' + 1)[SAID], [SASid], [SASName], [SACDate],            [SAPic], [SACD], [SASType], [SASWebsite], [SALoginwebsite], [SAAudit],            [SAvisible], [SAifdelete], [SAServerSecrect], [SAifSysAudit], ui.UserName,            ti.Tname     FROM   SapplicationInfo si, TypeInfo ti, UserInfo ui    WHERE  si.SASType = ti.TID           AND si.SASid = ui.[UID]            AND si.SAifdelete = 1 '                IF @uid <> ''        BEGIN            SET @strsql +=                 ' AND SI.SAifSysAudit = 0 AND si.SAvisible = 1 AND ui.UID=''' +                CAST(@uid AS CHAR) + ''' '        END                SET @strsql += ' AND si.SAID NOT IN (SELECT TOP(' + CAST(@startpage AS INT)            +            ' -1) si.[SAID]                           FROM   SapplicationInfo si, TypeInfo ti, UserInfo                                   ui                           WHERE  si.SASType = ti.TID                                  AND ui.UID = si.SASid                                  AND si.SAifdelete = 1 '                        IF @uid <> ''        BEGIN            SET @strsql +=                 ' AND SI.SAifSysAudit = 0  AND si.SAvisible = 1 AND ui.[UID]='''                + CAST(@uid AS CHAR) + ''' '        END                SET @strsql += ' ORDER BY SACDate DESC) ORDER BY SACDate DESC '    END    PRINT @strsql

--消息 245，级别 16，状态 1，过程 Query_SapplicationInfoList，第 29 行--在将 varchar 值 ' SELECT TOP (2 - 1 + 1)[SAID], [SASid], [SASName], [SACDate], --           [SAPic], [SACD], [SASType], [SASWebsite], [SALoginwebsite], [SAAudit], --           [SAvisible], [SAifdelete], [SAServerSecrect], [SAifSysAudit], ui.UserName, --           ti.Tname --    FROM   SapplicationInfo si, TypeInfo ti, UserInfo ui--    WHERE  si.SASType = ti.TID--           AND si.SASid = ui.[UID] --           AND si.SAifdelete = 1  AND SI.SAifSysAudit = 0 AND si.SAvisible = 1 AND ui.UID='ea7ec247-59d2--- 4aa4-ac72-11c601' ' 转换成数据类型 int 时失败。