Results 1 to 2 of 2

Thread: Miss

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: Miss

    Hi Guys i am havin a problem in sql firstly i wana know dat is data type boolean work in sql, if yes how? if you guys can giv me an example i'b very happy,
    thanx

  2. #2
    Join Date
    Nov 2004
    Posts
    1,400
    Provided Answers: 1
    There is no Boolean data type in SQL Server. One that is often used instead of Boolean is the Bit data type. It can store the values 0, 1 and NULL.

    Code:
    CREATE TABLE #MyTable(
    	Id		INT	NOT NULL,
    	TrueBoolean	BIT	NOT NULL	DEFAULT 1,
    	FalseBoolean	BIT	NOT NULL	DEFAULT 0,
    	UndefBoolean	BIT
    )
    
    INSERT INTO #MyTable(Id) VALUES
    (1)
    
    SELECT * from #MyTable
    --1	1	0	NULL
    
    UPDATE #MyTable
    SET TrueBoolean = 0
    WHERE UndefBoolean IS NULL
    --1	0	0	NULL
    
    SELECT * FROM #MyTable
    WHERE FalseBoolean = 1
    -- empty result set
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •