this question may fit better into the Database category instead of Java. Anyway, I hope somebody can help me here.
I have successfully connected to MS SQl server via JDBC-ODBC bridge driver. My problem is I dont know how to access the table, I created a table names emp under "tempdb"(or something like that), but when I tried to the statement "select * from emp", I was told "invalid object name emp". I never used MS SQL before, I have no idea about it. is there command line inferface like SQL * plus for Oracle in MS SQL? what is wrong with the emp table I created?
Thanks & merry x-mas