MS SQl Server return selected value

[tzachk]

Hi Francesco,

I'm trying to run an sql server select command. SELECT x FROM y.
How can I get the returned value?

Regards,
T.

[FrancescoT]

Dear Tzachk,

you could try with using the SQLCMD tool.
http://technet.microsoft.com/en-us/library/ms162773(v=sql.110).aspx

If recall you could save the returned value in a file.

Regards

[tzachk]

Hi Francesco,

Our server software is not installed on the same machine as the SQL server (that is usual case in most organizations), so using SQLcmd is impossible unless I install additional components which I want to avoid.

Any other way?

Regards,
T.

[FrancescoT]

Dear Tzachk,

unfortunately, it doesn't exist any other way ... unless you create a custom DLL or an EXE for such purpose.

Regards