Store procedure are used for separately used for operation individual's result.There is used for sql query used for operation made.There is some operation as select,insert and delete operation query store.The store procedure name are defined in the application to do operation as define in store procedure.The operation is retreive using store procedure used.There is create or alter are need for table.There is need to define table parameter types are need.There is also need unique value that is indx have automatic increase value.
There is used a @ symbol for field of the table used.There is used as alter with table name,Insert into operation and values are used for insert operation.@value is used For retrieve from textbox have value name used.
There is need to used same column name as the insert operation.The unique value need not to be insert value,It is automatic update it.There is also used SET as value set for any column.There is used as int,varchar(50),char(2),output,date,dateandTime.Varchar(200),char(10),string and etc.
If any column need to unknown value then declare as NULL value for that column.The output give any error or say any rows affected or not.If any row affect then operation is successful.If any raw not affect then the result is not retrieve using query.Error describe problem inquery used.