Sybase和Microsoft的SQL Server有什么差别?
我在MS SQL Server中好用的一个存储过程到了Sybase中就怎么也不好用了!
主要是语法不对,这是为什么?
存储过程如下:
CREATE PROCEDURE upd_current
@id_checked int output
AS
declare @id_select int
update WAITING set PROCESSING=2, @id_select=NOTE_ID
from (select MIN(convert(int, NOTE_ID)) t1_1 from WAITING where PROCESSING=1) as t1
where CONVERT(int, NOTE_ID)=t1.t1_1
select @id_checked=@id_select
return
请各位大虾指教!