How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?

SAinCA, I think this is the code you are referencing from this tip ( http://www.mssqltips.com/tip.asp?tip=1112 ): -- Table - The base table is stored with the -- clustered index, so moving the clustered -- index moves the base table CREATE CLUSTERED INDEX IDX_ProductID ON dbo.OrdersDetail(ProductID)...