tag:blogger.com,1999:blog-6082652835152798567.post3411152552386412401..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Debugging sql server stored proceduresUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6082652835152798567.post-26275161443779883122015-11-01T16:22:14.456-08:002015-11-01T16:22:14.456-08:00I am not exactly sure but by referring previous vi...I am not exactly sure but by referring previous videos i think it can be done by passing table valued variable to procedure.<br /><br />create type tableValuedVariable as table<br />(x int,<br />y int<br />)<br /><br />create procedure SP_XYAB<br />@tv tableValuedVariable readonly<br />as<br />begin<br />select * into bckUp from @tv<br />-- insert into select * from @tv<br />end<br /><br />declare @tvV1 tableValuedVariable<br />insert into @tvV1 values (1,2)<br />-- insert as many you want<br />execute SP_XYAB @tvV1Anonymoushttps://www.blogger.com/profile/01681902154144782131noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-4079897719998937842015-09-29T04:02:47.580-07:002015-09-29T04:02:47.580-07:00Hi Sir,
Thank you so much for keep on po...Hi Sir,<br /> Thank you so much for keep on posting the videos on sqlserver.Can you please record the video for passing multiple values to stored procedure(say 1000).This is one of my interview questions.<br /> Thnaks in advancechandra sekhar sharma MCAhttps://www.blogger.com/profile/04236578531464880774noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-52684362302929088912015-09-29T03:58:17.652-07:002015-09-29T03:58:17.652-07:00Hi Venkat Sir,
Thank you so mu...Hi Venkat Sir,<br /> Thank you so much for keep posting videos on sqlserver.Can you please tell me how to pass mutiple values as parameters to a stored procedure(say 1000).This is one my interview questions.<br />Thanks in advancechandra sekhar sharma MCAhttps://www.blogger.com/profile/04236578531464880774noreply@blogger.com