Search results for query: *

I'm trying to query a table and get back 'something' from which I can extract the table's column names and types. At the moment I'm using meta data (Java) but need at least one record in my ResultSet to be able to get the meta data in the first place. So... 1. How can I select just one...

i thought that was probably the case. thanks.

I'm querying mySQL tables quite happily from a Java application but .... If a create a query in mySQL itself can I then save it somewhere on the server and then run a query on that saved query! ... or would it be best to just build the entire query into one SQL statement and run that from the...

M6Q0M6 is the name of the server. If I run "Netstat -an" from the DOS prompt nothing appears to be listening at 1344. I then run sqlservr.exe and get the same old error messages. Running "Netstat -an" again now shows something listening on port 1344 but I guess that's because...

forgot to add.. running win2000

delighted to!... 2002-11-21 23:52:35.82 kernel initconfig: Number of user connections limited to 32767. 2002-11-21 23:52:35.82 kernel SQL Server is starting at priority class 'normal'(1 CPU detected). 2002-11-21 23:52:35.82 kernel User Mode Scheduler configured for thread processing...

nothing in the start menu. Running sqlservr.exe gives: lots of text then... "Error: 17826, Severity: 18, State: 1" Is it a conflict with port 1433? I can't uninstall or reinstall - so am feeling a bit stuck!!

insulting the expertise of many of you I know but ... I've installed MSDE from win200 disk but am not getting any icons in the task bar and can't work out how to open the Service manager. I don't think it has installed correctly. Any advice? Thanks.

I have a simple table containing personID-choiceID pairs. I want to retrieve PersonIDs that have opted for one choice and another and another etc... Using an intersect query may not be the best way but ... (SELECT * from <table> WHERE choiceID= [variable]) intersect (SELECT * from <table> WHERE...

is it possible to find out the username of the person running a java application under windows2000. I've got an application running on a windows2000 network and i want it to automatically get the username of the person logged on. KJS

I'm trying to connect to mySQL using a servlet and the sun.jdbc.odbc.JdbcOdbcDriver. I think the driver is found but i get the message 'no suitable driver' when i try: DriverManager.getConnection(&quot;jdbc:mySQL://localhost:3306/test&quot;);