| Author |
Topic |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2010-03-02 : 16:10:00
|
| Hi i need to create table,trigger,index,view script on my local machine.could any one help to do this? |
|
|
ms65g
Constraint Violating Yak Guru
497 Posts |
Posted - 2010-03-02 : 16:11:35
|
| Which SQL Server version are you using?and do you want scipts only codes or data? |
 |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-02 : 16:25:42
|
only code not data,using sql2000quote:
Originally posted by ms65g
Which SQL Server version are you using?and do you want scipts only codes or data?
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-02 : 16:30:55
|
see here (it is easy):http://msdn.microsoft.com/en-us/library/aa197132(SQL.80).aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
ms65g
Constraint Violating Yak Guru
497 Posts |
Posted - 2010-03-02 : 16:32:09
|
| Right click on the database name at object browser then tasks --> generate scripts (if correct)Or use following software, you can download at this link:http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en |
|
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-02 : 16:44:20
|
Hi i need through T-sql statementquote:
Originally posted by webfred
see here (it is easy):http://msdn.microsoft.com/en-us/library/aa197132(SQL.80).aspx
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-02 : 16:52:11
|
You want T-SQL to generate the T-SQL?Then I don't know - sorry.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-02 : 17:30:22
|
quote:
Originally posted by webfred
You want T-SQL to generate the T-SQL?Then I don't know - sorry.
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
generate script