http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/3975.aspxMon, 11 Feb 2008 16:38:40 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3975Alex0http://sqlserver.ro/forums/thread/3975.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3975<P>rezolvat.</P> <P>am scos parantezele de la select</P> <P>alex.</P>http://sqlserver.ro/forums/thread/3974.aspxMon, 11 Feb 2008 16:33:32 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3974Alex0http://sqlserver.ro/forums/thread/3974.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=3974<P>salut, am si eu o eroare de syntaxa (sper) dar nu-mi dau seama ce si cum....am cursorul de mai jos</P> <P>declare curs cursor for (select id from altele where id = @id or id = 0x)<BR>open curs<BR>fetch next from curs into @aux_id<BR>while @@fetch_status = 0<BR>begin</P> <P>-------</P> <P>end<BR>fetch next from curs into @aux_id<BR>close curs<BR>deallocate curs</P> <P>totul merge ok...doar ca nu-mi ordoneaza cum trebuie si in concluzie am incercat sa-i bag un order by</P> <P>deci sa-l fac astfel</P> <P>declare curs cursor for (select id from altele where id = @id or id = 0x <STRONG>order by id asc</STRONG>)<BR>open curs<BR>fetch next from curs into @aux_id<BR>while @@fetch_status = 0<BR>begin</P> <P>-------</P> <P>end<BR>fetch next from curs into @aux_id<BR>close curs<BR>deallocate curs</P> <P>si primesc eroarea</P> <P>Server: Msg 156, Level 15, State 1, Line 27<BR>Incorrect syntax near the keyword 'order'.</P> <P>care nu reusesc sa-mi dau seama de la ce.</P> <P>multumesc mult.</P> <P>alex.</P>