Results 1 to 4 of 4

Thread: sql server

  1. Aug 31st, 2012, 03:53 PM #1
    ubkra
    ubkra is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2012
    Posts
    440

    sql server

    I've got several tables one is a table of classes (index by ClassID)
    Another table is "ClassList" (index by ClassListID) the second column is ClassID how can I search for all students who have the ClassID of 9 for example?

    I have this code

    SELECT * FROM ClassData WHERE ClassID = 6

    It returns nothing in SQL Server even though I can see rows in ClassData with the ClassID of 6.

    What is wrong?
    Reply With Quote Reply With Quote
  2. Aug 31st, 2012, 08:10 PM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: sql server

    From where you are running your sql?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Sep 1st, 2012, 10:38 AM #3
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: sql server

    Table's name is "ClassList" or "ClassData" ?
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  4. Sep 1st, 2012, 11:16 AM #4
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Re: sql server

    Quote Originally Posted by dee-u View Post
    From where you are running your sql?
    Quote Originally Posted by jggtz View Post
    Table's name is "ClassList" or "ClassData" ?
    Where are you running the SQL? Is it on the query analyzer window or your application?
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width