i have error massege in sql query.msg is
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@emp_name".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@emp_name".
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@emp_add".
Msg 137, Level 15, State 2, Line 8
Must declare the scalar variable "@emp_name".
plzzz tell me how can i solve these error. my query is
declare @emp_name varchar(40)
declare @emp_add varchar(40)
declare cursor_employee cursor for
select emp_name,emp_add from employee
open cursor_employee
fetch next from cursor_employee into @emp_name,@emp_add
print '*emp_name='+ @emp_name
print 'emp_add='+ @emp_add
while(@@fetch_status=0)
begin
fetch next from cursor_employee into @emp_name,@emp_add
end