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.
| Author |
Topic |
|
koci
Starting Member
6 Posts |
 Posted - 2004-10-11 : 13:17:30
|
| Hi all!How to run one script with more than one batch inside, from vb? The script return one result set, which is used to build one report. I need one script because I use temp tables.ADO knows adCmdText, adCmdTable, adCmdStoredProc, adCmdUnknown, adCmdFile, and adCmdTableDirect. Which of this options is the right one?Thank's.PS. Sorry if this post is not in the right place (i.e. vb forums) |
|
|
tuenty
Constraint Violating Yak Guru
278 Posts |
Posted - 2004-10-11 : 13:55:35
|
| adCmdStoredProcCREATE THE SP IN SQL AND CALL IT FROM VBthe less the application makes requests to the DB the faster it will run so it is good to have the logic in just one SP*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*.*A candle loses nothing by lighting another candle |
 |
|
|
|
|
|
How to run one script from vb?