[OpenNos] Query syntax

[-Diamond-]

Hello, i'm pretty new into SQL Server, i've used MySQL time ago and maybe some things might be different or idk...
Btw, i'm making a register page for a server and i'm experiencing a problem with a query...
I'm using php oop and pdo:

$stmt = $conn->prepare("SELECT count(*) FROM dbo.Account WHERE Name = :name");
	$stmt->bindParam(":name", $username);
	$stmt->execute();
	if($stmt->rowCount()) $error = "This username already exists";

I tried a select query on Navicat too and it's extremely weird to me...
When i put:

SELECT * FROM dbo.Account WHERE Name="test"

It says that the column name "test" is not valid, it should search through the column "Name" and look for "test", what's wrong in it?
I hope to get helped as soon as possible, thank you in advance!

EDIT:
Figured out by myself, in the query i cannot use RowCount with SELECT statement, and about navicat i was typing "test" instead of 'test'