• Post Reply Bookmark Topic Watch Topic
  • New Topic

SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql  RSS feed

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
where 1234 is under [student id]
 
author
Bartender
Posts: 5856
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is studentid a character column or a numeric column? If numeric, does it work if you remove the quotes? Are you sure there is a studentrecord with that studentid? Are you getting an error, or just no rows selected?
 
Paper jam tastes about as you would expect. Try some on this tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!