i have an SP like BEGIN DECLARE ... CREATE TEMPORARY TABLE tmptbl_found (...); PREPARE find FROM\"INSERT INTO tmptbl_found
Can I clear 开发者_JAVA百科the multiple result sets that a stored procedure has already gathered so that the next result set that is created becomes the very first result set returned by the procedure
I\'m using visual studio 2008 and I\'ve created a stored procedure that selects back two different result sets.I drag the stored proc on to a linq to sql dbml datacontext class, causing visual studio