开发者

Display Stored Procedure results into Server Explorer

开发者 https://www.devze.com 2023-03-27 19:29 出处:网络
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

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

精彩评论

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

关注公众号