Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.
|SQL: Best data type for lat & long coordinates? Float vs Decimal?||5||32|
|Copy data to New Year||9||32|
|removing unwanted rows from an sql server ranked table||13||36|
|T-SQL: How to extract records into a new table||7||18|