i have a table as users with this field(id ,name,family,age)mt id and age are int and name and family nvarchar(50)
i tried with design query in editory select name and family with parameter age..under window it show me as this
name, family, age
WHERE (age = @age)
ofcourse i set @age int with my hand not editor but it show me syntax error
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@age".
ofcourse i decalre id as int and auto number age as int and name and family as nvarchar(50)
how can i solve thissimple query error..i guess ididnt make any mistake...plz help me..i guess it should be more simple in editor but it was n't..