MSSQL Select one Field

I am building a Auto-It script that connects to ms sql and returns a field for a variable. Here is my query:

SELECT TOP 1 sde_id FROM  sde.SDE_process_information
Displays:

sde_id
116648


But I would like it to just return 116648 only. How do i get results for just one field without the row name.
Thanks


Sqlserver 2008
LVL 2
CityInfoSysAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cyberkiwiCommented:
Without looking at your script, it's very hard to change it.
Normally, a query would only return the value, so your script must be specifically inserting the column name.
Does it actually return as a string with embedded line break?
0
LowfatspreadCommented:
if you are running via sqlcmd try the -H parameter...alternatively  use a stored procedure and an output parameter,,,
0
George K.Commented:
Have a look at these functions


_CreateTable - create a new table in the database.
_CreateColumn - create a new column in a table in the database.
_DropCol - delete a column and its contents from a table in the database.
_DropTbl - delete a table and its contents from the database.
_CountRecords - returns the number of records in a column that match a specific search parameter.
_CountTables - returns the number of tables that are in the database.
_GetColNames - returns an array with the number of columns in the first array element and all of the column names in the specified table from the database.
_GetTblNames -returns an array with the number of tables in the first array element and all of the table names in the specified database.
_GetColVals - gets all of the values in a specified column in a specified table from the database.
_GetColCount - returns the number of columns in a specified table in the database.
_GetColType - returns the data type of a column specified in a table from the database.
_GetDBNames - returns an array with the number of databases in the first array element and all of the database names in the specified server.
_ChangeCon - changes the connection object to allow for a different username, password, server, or database.



http://dailycupoftech.com/2007/04/18/mysql-data-manipulation-with-autoit/




0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

George K.Commented:
Can you paste your code?
0
CityInfoSysAuthor Commented:
Here is the code I am still working on. Mainly I need to figure out the query part. Also this is MSSQL not mysql.
Thanks
;AutoIt Code

$Query = "SELECT TOP 1 sde_id FROM  sde.SDE_process_information"

Func SqlConnection()
	If $adoCn.State = $adStateOpen Then $adoCn.Close
	$adoCn.ConnectionString = $Conn
	$adoCn.Open
	If $adoRs.State = $adStateOpen Then $adoRs.Close
	$adoRs = $adoCn.Execute($Query)
	If $adoRs.State = $adStateOpen Then
		$J = $adoRs.Fields.Count - 2 
		For $K = 0 To $J
		$Output = $Output & $adoRs.Fields($K).Name & @TAB
		Next
		$Output = $Output & @CRLF
		$Output = $Output & $adoRs.GetString(2, -1, @TAB, @CRLF, "Null")
		$adoRs.Close
		GUICtrlSetData($EditResults, $Output)
	EndIf
EndFunc   

Open in new window

0
George K.Commented:
I 've had a very fast look to your code.
Maybe delete this line?:
$Output = $Output & $adoRs.Fields($K).Name & @TAB
0
cyberkiwiCommented:
Delete 4 lines otherwise you have a loop that does nothing. You also get an extra CRLF

delete
            For $K = 0 To $J
            $Output = $Output & $adoRs.Fields($K).Name & @TAB
            Next
            $Output = $Output & @CRLF

so you end up with
;AutoIt Code

$Query = "SELECT TOP 1 sde_id FROM  sde.SDE_process_information"

Func SqlConnection()
	If $adoCn.State = $adStateOpen Then $adoCn.Close
	$adoCn.ConnectionString = $Conn
	$adoCn.Open
	If $adoRs.State = $adStateOpen Then $adoRs.Close
	$adoRs = $adoCn.Execute($Query)
	If $adoRs.State = $adStateOpen Then
		$J = $adoRs.Fields.Count - 2 
		$Output = $Output & $adoRs.GetString(2, -1, @TAB, @CRLF, "Null")
		$adoRs.Close
		GUICtrlSetData($EditResults, $Output)
	EndIf
EndFunc   

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.