[SQL]为什么我的程序无法正常工作?

我有一个非常简单的过程，由于某种原因，当我使用Visual Studio的数据库激活它时，它可以工作，但是当我从代码中使用它时，它就失败了(提取的值是如果有这样的用户，则从0而不是1).

I have this extremely simple procedure, and for some reason it works when I''m activating it using the Visual Studio''s Database thingy, but fails when I''m using it from my code (the extracted value is 0 instead of 1 when there''s such a user).

CREATE PROCEDURE Client_Authenticate
 (@ID int,@Password varchar(32),@OutAuthenticated tinyint OUTPUT) AS
 BEGIN
 	SELECT * FROM _Clients WHERE ClientID = @ID AND MD5Hash = @Password
	SET @OutAuthenticated = @@ROWCOUNT
 END

同样，以下过程从代码执行时似乎什么也没做.

Also the following procedure seem to do nothing when executed from code.

CREATE PROCEDURE Client_ConnectionChanged
 (@ID int,@Value tinyint) AS
 BEGIN
 UPDATE _Clients SET ClientConnected = @Value WHERE ClientID = @ID
 END