Declaring @Local_Variable and @Parameters in Stored Procedure
Can we declare Local Variables and Parameters in a Stored Procedure in SQL? I have couple of parameters to pass from the program, at the same time I need to declare couple of Local Variables to do some calaculations in the SP. Please let me know. Thank you very much in advance.