Display Stored Procedure results into Server Explorer
I do not have admin panel on my website (I find it overkill) and use default local MS Studio Server Explorer to admin my website's database. I use Views and it works great for my purposes. But now I need parametrized View and I created Stored Procedure. But I didn't find a way how to display result set of SP as View does it. It sends data to Output window instead of Server Explorer's gr开发者_如何学JAVAid view. Any ideas?
you can run the stored proc using "EXEC", this will put the results in a grid at the bottom of the screen. i.e.
exec mySp 'Param'
精彩评论