You could use the BIT
datatype to represent boolean data. A BIT
field’s value is either 1, 0, or null.
More Related Contents:
- Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
- Datatype for storing ip address in SQL Server
- How do you create a yes/no boolean field in SQL server?
- Real vs. Floating Point vs. Money
- SSIS Excel Import Forcing Incorrect Column Type
- How to create a yes/no boolean field in SQL server?
- Change type of a column with numbers from varchar to int
- Where clause not working in sql server
- Compare the values of column in SQL Server
- T-SQL stored procedure that accepts multiple Id values
- LocalDB deployment on client PC
- How do I escape a percentage sign in T-SQL?
- Using RegEx in SQL Server
- What is the best way to auto-generate INSERT statements for a SQL Server table?
- Get list of databases from SQL Server
- SqlServer: Login failed for user
- How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
- EXEC sp_executesql with multiple parameters
- SQL Server – Dynamic PIVOT Table – SQL Injection
- When must we use NVARCHAR/NCHAR instead of VARCHAR/CHAR in SQL Server?
- How to add custom attributes to SQL connection string?
- SSIS reading LF as terminator when its set as CRLF
- What are some ways of accessing Microsoft SQL Server from Linux?
- How do I remove non-breaking spaces from a column in SQL server?
- Why is casting from float to varchar being rounded in SQL Server?
- How to set value to variable using ‘execute’ in t-sql?
- Taking the second last row with only one select in SQL Server?
- What is the difference between Cartesian product and cross join?
- How to Bulk Insert from XLSX file extension?
- Count number of records returned by group by