[Logo]
Forums Register Login
SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql
where 1234 is under [student id]
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?
If I had asked people what they wanted, they would have said faster horses - Ford. Tiny ad:
ScroogeXHTML 7.1 - RTF to HTML5 / XHTML converter
https://coderanch.com/t/690611/ScroogeXHTML-RTF-HTML-XHTML-converter


This thread has been viewed 1245 times.

All times above are in ranch (not your local) time.
The current ranch time is
Feb 18, 2018 11:18:14.