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
Is there any easy way to create simple INSERT and UPDATE stored procedures
in SQL Server 2008 Management Studio?