Hi
I don't know if you have that information, but I would like to know if there is any aplication to put the comand "ORDER BY" in the stored procedures made for SQL 6.5, once I intend to use SQL2000 and in it, we have to use that comand and my stored procedures don't have it.
Thanks
Roberto
i don't do much with stored procedures, and i mainly use mysql (which is probably why), but every time i've had to do something similar, i end up having to dump it all into an array and sort the array.
sometimes no help, is help!
I have about 2000 stored procedures made to SQL Server 6.5 with the SELECT command, but without the ORDER BY command in it. In SQL Server 2000 you have to use the ORDER BY command. I would like to know if exists any aplication to put the ORDER BY command in the stored procedures automaticly.