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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-19 : 08:27:20
|
| John writes "I need a way to read a Stored Procedure into a VB6 program.I have no problem parsing it out once I have it, nor do I have a problem deleting it and writing out a new verion. I need to update some pieces of code in several stored procedures depending upon input variables. John Dyczkodyczko@yahoo.com" |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-19 : 09:09:03
|
| Sounds like an odd request. Can you provide an example of changes resulting from inputs? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-11-19 : 09:09:25
|
quote:
Originally posted by AskSQLTeam
I have no problem parsing it out once I have it, nor do I have a problem deleting it and writing out a new verion.
You will...Ever here of version control?What rights do you have? How do you connect...what does the dba say?Do you have a dba?Never get in a ground war in asia in the winter...(ooops sorry...free association thing again...)Brett8-) |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-19 : 12:18:17
|
sp_helptext [stored procedure or view name]That's what you need. I hope you know what you are doing, though.Owais
Where there's a will, I want to be in it. |
|
|
|
|
|
|
How to read a Stored procedure from VB code