Where is the create stored procedure wizard in SMS 2005 that we had in 2000?!
The templates are nice, but they show syntax only. The 2000 wizard created insert update and delete stored procedures based on the table structure.
Regards Richard
Looks like it has been removed, which is a real shame. The templates aren't much use to me - I know how to write SQL, but they are tedious when they are simple insert, update and delete statements. Looks like I'll have to write my own little app to do them for me :-(
Pete
|||I'm now using CodeSmith...|||Inside SQL 2005 Management Studio, expand the database (where you want to create your stored procedure) then expand programability, then on stored procedures right click and choose new stored procedure ( the long way.) You should also check out the tempate explorer in SQL Management Studio. Press Ctl-Alt-T and you will see the template explorer come up on the right. You will see that there are a lot more templates than in SQL 2000
quoted from "http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=181070&SiteID=1"
No comments:
Post a Comment