Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 how to use stored procedure in dataset??

Author  Topic 

krish001
Yak Posting Veteran

61 Posts

Posted - 2009-10-28 : 07:59:37
stored procedure in dataset??

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-28 : 08:19:49
When adding dataset, if you leave the Type as Text you would use

exec stored_procedure_name

If you switch the command type to StoredProcedure you can leave the "exec" out.



John
It's a small world (but I wouldn't want to paint it)
Go to Top of Page

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-10-28 : 17:02:33
quote:
Originally posted by krish001

stored procedure in dataset??



why not, did you try? whats the problem?
Go to Top of Page
   

- Advertisement -