id | name | price | category |
---|---|---|---|
1 | Penguin | 250 | Bird |
2 | Bear | 1050 | Mammal |
3 | Duck | 150 | Bird |
4 | Camel | 550 | Mammal |
5 | Owl | 185 | Bird |
6 | Whale | 880 | Mammal |
declare @price int = 200
select * from products where @price < price
id | name | price | category |
---|---|---|---|
1 | Penguin | 250 | Bird |
2 | Bear | 1050 | Mammal |
3 | Camel | 550 | Mammal |
4 | Whale | 880 | Mammal |
declare @query nchar = 'iPentec'
declare @query nchar(128) = 'iPentec'