SQL Server doesn't use the LIMIT keyword, instead use TOP() to select the maximum number of rows to return:

	SqlCommand1->CommandText = "SELECT TOP(1) SomeRowName \
							   FROM SomeTableName \
							   WHERE SomeRowName2 == 0";