A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql
Joined: Sep 24, 2009
Jan 23, 2010 02:37:42
where 1234 is under [student id]
Joined: May 14, 2008
Jan 23, 2010 08:43:13
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?
JBoss In Action
I agree. Here's the link:
subject: SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql
convert from decimal to byte array but base 8
How to store composite objects in Hibernate
what does hiobernate Session's update work ?
generate Unique key
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013