Help

Question

Sir/Madam,

I have doubt with calling stored procedure from front end.

Create Procedure ProcedureName
(@Input1 DataType
@Input2 DataType)
AS
Begin
SELECT * FROM Table1
Insert INTO Table1 VALUES(@Input1, @Input2) 
End

In the above procedure how to get value for select command.


With Regards,
Gomathi.P