Galera, Tenho esta SP no SQL Server: CREATE PROCEDURE GG_SP_MANAGER_USUARIOS_GETDATAGRID
@DataForPage AS Int,
@CurrentPage AS Int,
@WhereClause AS Varchar(255),
@SortField AS Varchar(255)
AS
DECLARE @COUNTER AS Int
SET @COUNTER = (SELECT COUNT(GG_MANAGER_USUARIOS.Usuario) FROM GG_MANAGER_USUARIOS)
IF @DataForPage = 0
SET @DataForPage = 10
IF @CurrentPage = 0
SET @CurrentPage = 1
DECLARE @SQLStatement varchar(8000)
SET @SQLStatement ='' +
'SELECT ' +
'Usuario, ' +
'Nome, ' +
'Sobrenome, ' +
'Email, ' +
'Senha, ' +
'Telefone, ' +
'DataCad, ' +
'DataAlt, ' +
'DataVisita, ' +
'Visitas, ' +
'Ip, ' +
'Grupo, ' +
'Grupo_Nome, ' +
'Liberado ' +
'FROM (' +
'SELECT ' +
'GG_MANAGER_USUARIOS.Usuario, ' +
'GG_MANAGER_USUARIOS.Nome, ' +
'GG_MANAGER_USUARIOS.Sobrenome, ' +
'GG_MANAGER_USUARIOS.Email, ' +
'GG_MANAGER_USUARIOS.Senha, ' +
'GG_MANAGER_USUARIOS.Telefone, ' +
'GG_MANAGER_USUARIOS.DataCad, ' +
'GG_MANAGER_USUARIOS.DataAlt, ' +
'GG_MANAGER_USUARIOS.DataVisita, ' +
'GG_MANAGER_USUARIOS.Visitas, ' +
'GG_MANAGER_USUARIOS.Ip, ' +
'GG_MANAGER_USUARIOS.Grupo, ' +
'GG_MANAGER_GRUPOS.Nome AS Grupo_Nome, ' +
'GG_MANAGER_USUARIOS.Liberado, ' +
'ROW_NUMBER() OVER(ORDER BY ' + @SortField + ') AS RowNum ' +
'FROM ' +
'GG_MANAGER_USUARIOS LEFT OUTER JOIN ' +
'GG_MANAGER_GRUPOS ON GG_MANAGER_USUARIOS.Grupo = GG_MANAGER_GRUPOS.Grupo' +
') AS RegInfo ' +
'WHERE ( RowNum BETWEEN ' + CONVERT(nvarchar(10), @CurrentPage) +
' AND (' + CONVERT(nvarchar(10), @CurrentPage) + ' + '
+ CONVERT(nvarchar(10), @DataForPage) + ') - 1 )'
IF LEN(@WhereClause) >0
SET @SQLStatement = @SQLStatement + ' AND ( ' + @WhereClause + ' )'
EXEC(@SQLStatement)
RETURN @COUNTER
GO Alguém pode me ajudar convertendo para MySQL? Grato.
