stored procedure problem

[kal13na13]

hi I have created stored procedure for the selection,insertion and updation for updations while excuting the stored procedure it asks for declaring the variables I dont know how to declare variables in the stored procedure .Can anyone help me. thanks of help in advance kal2na2

[Fariborz Golara]

you can declare in SQL Server procedure like this DECLARE @local_variable data_type E.g. DECLARE @I INT, @S VARCHAR(10), @M MONEY For more information you could search "DECLARE" in "SQL Server Book Online" Fariborz Golara -- modified at 4:33 Monday 12th December, 2005