ResultSet resultset = ps.execute (); We discovered the workaround here is to not append the select statement at the end of the SQL query. However, when we do this we cannot include the select SQL ...

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID ...

I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.The problem I'm running into is SQL Server exports NULL values as ...