Generate By VB code

Hi all. Can you tell me how to Generate Script(SQL Procedure) by VB Code?
Thank you for your help.
[102 byte] By [luckroth] at [2007-11-20 0:38:46]
# 1 Re: Generate By VB code
anyone pls help me? pls? pls?
luckroth at 2007-11-9 19:57:05 >
# 2 Re: Generate By VB code
See these threads

http://www.mssqlcity.com/Scripts/scrTSQL.htm

http://msdn2.microsoft.com/en-us/library/ms178078.aspx

Search Google for more ...

Regards
Amarjit
amarjitamarNew at 2007-11-9 19:57:59 >
# 3 Re: Generate By VB code
anyone pls help me? pls? pls?
What kind of script do you want to generate? Can you explain a bit more on what you are trying to do.
Shuja Ali at 2007-11-9 19:59:09 >
# 4 Re: Generate By VB code
i guess he wants to create SP via vb code.. well, this is almost the same as executing a regular SQL command..

cn.execute "<SP code here>"

hope that helps.
Thread1 at 2007-11-9 20:00:09 >
# 5 Re: Generate By VB code
i guess he wants to create SP via vb code.. well, this is almost the same as executing a regular SQL command..

cn.execute "<SP code here>"

hope that helps.

No, i don't. I want to know the codes of script. so pls help me.
luckroth at 2007-11-9 20:01:08 >
# 6 Re: Generate By VB code
As Shuja pointed out, what kind of script are you referring to? :rolleyes:
Thread1 at 2007-11-9 20:02:11 >
# 7 Re: Generate By VB code
I want to know code in procedure without generate script wizard. it mean write code in VB, it will automatically generate script.
Anyone can you help me?
luckroth at 2007-11-9 20:03:14 >