salut, am si eu o eroare de syntaxa (sper) dar nu-mi dau seama ce si cum....am cursorul de mai jos
declare curs cursor for (select id from altele where id = @id or id = 0x)
open curs
fetch next from curs into @aux_id
while @@fetch_status = 0
begin
-------
end
fetch next from curs into @aux_id
close curs
deallocate curs
totul merge ok...doar ca nu-mi ordoneaza cum trebuie si in concluzie am incercat sa-i bag un order by
deci sa-l fac astfel
declare curs cursor for (select id from altele where id = @id or id = 0x order by id asc)
open curs
fetch next from curs into @aux_id
while @@fetch_status = 0
begin
-------
end
fetch next from curs into @aux_id
close curs
deallocate curs
si primesc eroarea
Server: Msg 156, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'order'.
care nu reusesc sa-mi dau seama de la ce.
multumesc mult.
alex.