SQL两行对比，输入改变行

declare @vechilesimid varchar(50)
declare @longtitude float
declare @latitude float
declare @passengerstate int
declare @createdate datetime
declare @ID int
declare @PAS int

declare CS cursor for
select * from [Table_3]
open CS
fetch  next from CS into @vechilesimid,@longtitude,@latitude,@passengerstate,@createdate,@ID
WHILE (@@FETCH_STATUS = 0)
begin
if  @PAS!=@passengerstate  
Begin
    print'车牌:'+@vechilesimid;
    print'经度:'+Convert(Varchar(50),@longtitude);
    print'纬度:'+Convert(Varchar(50),@latitude);
    print'乘客数:'+Convert(Varchar(50),@passengerstate);
    print'时间:'+Convert(Varchar(50),@createdate,121);
    print'序号:'+Convert(Varchar(10),@ID)
End
select @PAS=@passengerstate
fetch  next from CS into @vechilesimid,@longtitude,@latitude,@passengerstate,@createdate,@ID
end
close cs
DEALLOCATE  cs

游标运行好慢，我本来想c#连接sql，在读SQL数据，但是VS坏了，不想重装

游标是慢,但是不知道你想做什么,是要Select出来呢(这个可以不用游标),还是要Print出来
搞定了就要结贴噻