[result] Forum Topics

select name, REPLACE(format, ' – ', '/') as format, CAST(price AS UNSIGNED INTEGER) as price, CONCAT('http://www.example.com/',url_key) as url, id, delivery, sku from Database1 where delivery <> 'finished' INTO OUTFILE 'test.txt' FIELDS TERMINATED BY '\t'; this query returns empty result while select name, REPLACE(format, ' – ', '/') as format, CAST(price …

Hi, is there a way how to (in transact sql) catch output from stored procedure which returns set (2 and more) of tables and move through it ??? thanks!

Hi, i hava a dropdownlist in asp.net mvc page. On selecting particular select item from dropdownlist i have made an ajax post request to the controller method that returns me the result. Everything is working fine. i also get the required result. But the problem is how shall i extract …

I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses …