Results 1 to 2 of 2

Thread: Miss

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    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,396
    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
  •