USE [testing] GO /****** Object: StoredProcedure [dbo].[sp_get_next] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_get_next] ( @id int ) AS BEGIN SET NOCOUNT ON; select id,aaa,bb,cc from TestDB where id>=(select MAX(id) from TestDB where id<@id) order by id END
SELECT TOP 1 id, aaa, bb, cc FROM myTable WHERE id > @id ORDER BY id ASC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)