[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 105
  • Last Modified:

How would you create a SQL Statement to alter a table in SQL Server 2008 to add an additonal column?

How would you create a SQL Statement to alter a table in SQL Server 2008 to add an additonal column?

I tried the following SQL Statement:

ALTER TABLE tblFlINT ADD ActiveRecord boolean;

Which created the following error:

Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #57: Cannot find data type boolean.

I also tried:

ALTER TABLE tblFlINT ADD ActiveRecord bool;

Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #57: Cannot find data type bool.
0
zimmer9
Asked:
zimmer9
1 Solution
 
Lee SavidgeCommented:
Use bit. It stores 1 and 0.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now