Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert into bit field 1

Status
Not open for further replies.
ice789911

ice789911

Programmer
Mar 17, 2008
10
GB
Is it possible to manually insert a value of 0 or 1 into a column of type bit using SQl Server Management Studio
I have tired it but keep getting the error 'String not recognised as a boolean'
 
Sort by date Sort by votes
>> value of 0 or 1

No. But you can manually insert the values of [!]True[/!] or [!]False[/!].

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
186
TheBugSlayer
TheBugSlayer
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
234
fredericofonseca
fredericofonseca
intel233
  • Locked
  • Question
Update field
Replies
2
Views
88
intel233
intel233
niall5098
  • Locked
  • Question
disabling audit sends SQL into a spin
Replies
0
Views
53
niall5098
niall5098
dgillz
  • Locked
  • Question
Database field defaulting to a certain value and it should not
Replies
0
Views
78
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top