Double quotes around query resultset

You can add the double quotes to each column, after converting the colunm to a character type where necessary

select
  '"' + cast(col1 as varchar) + '"',
  '"' + cast(col2 as varchar) + '"',
  '"' + cast(col3 as varchar) + '"'
from
    Mytable

I've always found the QUOTENAME() function to be easy to read and use. It doesn't get as confusing when concatenating long strings together.

select quotename('quotename','''')  -- using two single quotes 
select quotename('quotename','"')  -- using a double quote 
select quotename('quotename','[]')  -- using brackets

We just found that in SQL Developer, if you use the following it incoorporates the double quotes on each field. We are using this method in a unix script.

select '"' || field1 || '"' from tablename; returns "field1"

select '"' || field1 || '"' , '"' || field2 || '"' from tablename returns

         "field1" "field2" (in two columns of course.)

Not sure exactly what trouble you're having - it would probably help if you posted your query. Are you looking for something like this?

SELECT  '"' + name + '", "' + CAST(database_id AS varchar(10)) + '"'
FROM    sys.databases

You can also use SSIS to output into almost any format that you can imagine.

You an also change the behavior of double quotes with set quoted_identifier http://msdn.microsoft.com/pt-br/library/ms174393.aspx

Some examples that could be usefull:

set quoted_identifier off
select "123456","4444","This is the issue, sorry.","This is it---once again."
select """123456""","""4444""","""This is the issue, sorry.""","""This is it---once again."""

set quoted_identifier on
select '123456','4444','This is the issue, sorry.','This is it---once again.'
select '"123456"','"4444"','"This is the issue, sorry."','"This is it---once again."'