Page 1 of 1
MS SQl Server return selected value
Posted: Wed Dec 10, 2014 4:27 am
by 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.
Re: MS SQl Server return selected value
Posted: Wed Dec 10, 2014 12:18 pm
by FrancescoT
Dear Tzachk,
you could try with using the SQLCMD tool.
http://technet.microsoft.com/en-us/library/ms162773(v=sql.110).aspxIf recall you could save the returned value in a file.
Regards
Re: MS SQl Server return selected value
Posted: Thu Dec 11, 2014 12:48 am
by 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.
Re: MS SQl Server return selected value
Posted: Fri Dec 12, 2014 5:17 am
by FrancescoT
Dear Tzachk,
unfortunately, it doesn't exist any other way ... unless you create a custom DLL or an EXE for such purpose.
Regards