IT Community - Software Programming, Web Development and Technical Support

Store a boolean value in SQL Server.

This is a discussion on Store a boolean value in SQL Server. within the Database Support forums, part of the Web Development category; Hi all... Can anyone tell me how can i store a boolean value in SQL Server? Thanks in advance......


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 04-14-2008, 07:58 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 547
itbarota is on a distinguished road
Default Store a boolean value in SQL Server.

Hi all...


Can anyone tell me how can i store a boolean value in SQL Server?


Thanks in advance...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-14-2008, 07:59 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 237
Pvinothkumar is on a distinguished road
Default Re: Store a boolean value in SQL Server.

Hi all...


In SQL Server, there's no boolean data type. The nearest data type that can be used in place of boolean data is the BIT data type, which is an integer data type that can accept a value of 1, 0 or NULL value only.



Thanks
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create store procedure? senraj Database Support 4 04-25-2008 05:26 AM
can i store java objects in a Database? saravanan Database Support 0 03-20-2008 05:44 AM
How to Store and Retrieve the values in server side caches in ASP.NET? oxygen ASP and ASP.NET Programming 1 07-23-2007 12:14 AM
Can I store a COM object in a session ? saravanan PHP Programming 1 07-22-2007 09:22 PM
Which is the best place to store connectionstring in .NET projects ? sundarraja ASP and ASP.NET Programming 1 07-21-2007 12:18 AM


All times are GMT -7. The time now is 04:15 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0