Data type and Operator type Errors
You got problem because sqllite and sql server datatype are different.

In the specific, you use a text datatype. This is bad, in sql server, for many reasons:


Text will be removed in future versions of sql server: https://msdn.microsoft.com/it-it/library/ms187993.aspx
You cannot compare with the equal operator
Always choose appropriate data type. Store a number in a text field will lead you to problems.


So, I suggest you to build your table with appropriate datatypes. In your case name must be a varchar and age an integer (if it is ok).

Also you must not learn starting on a book for a specific rdbms and use another one, or you will get a lot of problems like this.