What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
ALTER PROCEDURE [dbo].[SP_MyTableTest] ( @Prices varchar(max) OUT ) AS BEGIN Declare @Price varchar(10) Set @Prices = '' Set @MyCursor = Cursor For Select Code, Name, Cast(Price as varchar(10) ) from tbl_Products Open @MyCursor Fetch Next From @MyCursor Into @Price While @@FETCH_STATUS = 0 Begin Set @Prices = @Prices + '''' + @Price + ''',' // Always returns Null Set @Prices = ''''+ @Price + ''',' //WORKS! Fetch Next From @MyCursor Into @Name End Close @MyCursor Deallocate @MyCursor
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.