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";
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.