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]

# 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
# 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.
# 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.
# 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.
# 6 Re: Generate By VB code
As Shuja pointed out, what kind of script are you referring to? :rolleyes:
# 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?