• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 109
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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