<div>
declare @b bit<br />
<br />
select @b = 1 -- 1 is true<br />
<br />
or select @b = 0 -- 0 is false<br />
<br />

</div>


<div>
thanks, where would i declare that 1 is true and 0 is false? and how exactly would it look?<br />
<br />
thanks
</div>


<div>
1 is true and 0 is false. This is normal behaviour. Historically -1 is true because it is a bit mask showing all bits as 1 including the sign.
</div>


<div>
You could equally have a varchar field that says 'true' or 'false'. It depends how you represent the value in your database on the front end asp.net code. In this case though a bit field is your best choice of datatype.<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
i want to be able to grant admin rights by using a simple checkbox in asp that when checked and submitted as part of a form, it passes a true value to the sql database. <br />
<br />
my question is what is the data type should i use in sql and how might i implement it?<br />
<br />
thanks
</div>
</div>


Hi,

i want to be able to grant admin rights by using a simple checkbox in asp that when checked and submitted as part of a form, it passes a true value to the sql database. 

my question is what is the data type should i use in sql and how might i implement it?

thanks

declare @b bit

select @b = 1 -- 1 is true

or select @b = 0 -- 0 is false



thanks, where would i declare that 1 is true and 0 is false? and how exactly would it look?

thanks

1 is true and 0 is false. This is normal behaviour. Historically -1 is true because it is a bit mask showing all bits as 1 including the sign.

You could equally have a varchar field that says &#39;true&#39; or &#39;false&#39;. It depends how you represent the value in your database on the front end asp.net code. In this case though a bit field is your best choice of datatype.



True / False value in SQL so i can have a checkbox in my asp front end

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.