开发者

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'
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜