'How can I declare a Boolean parameter in SQL statement?
How can I declare a Boolean parameter in SQL statement?
Solution 1:[1]
SQL Server recognizes 'TRUE' and 'FALSE' as bit values. So, use a bit data type!
declare @var bit
set @var = 'true'
print @var
That returns 1.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Eric |