Link to home
Start Free TrialLog in
Avatar of Yampolka
Yampolka

asked on

Create Stored Procedure Wizard

In SQL Server 2000 Enterprise Manager I used to use the "Create Stored
Procedure Wizard" all the time to create INSERT and UPDATE stored
procedures.  While it was not perfect it was a very quick way of creating
simple stored procedures and only a few minor changes were required with
simple inserts and updates.
I am fairly new to the SQL Server 2008 edition, but I cannot seem to find a
quick way of creating an INSERT or UPDATE stored procedure.  If I say have
10 or 20 input parameters it seems to take an age to manually find out their
Data Type, Size etc and type in manually, let alone the actual statement
itself.

Is there any easy way to create simple INSERT and UPDATE stored procedures
in SQL Server 2008 Management Studio?

ASKER CERTIFIED SOLUTION
Avatar of gothamite
gothamite
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Yampolka
Yampolka

ASKER

Thank you , but you know in SQL 2000 it was more comfortable.  It generated all list of parameters for me.