SQL
Everything to do with SQL, Stored Procedures, Triggers etc.
This error took me a while to figure out. I was using SqlDataSource with stored procedures for SELECT and UPDATE commands. The SELECT worked fine. Then I added UPDATE command and while trying to update, I would get this error: "Procedure of function has too many arguments specified" Apparently, good guys at .NET decided it is necessary to send SELECT parameters with the UPDATE command as well. So when I was sending the required parameters to the UPDATE sp, in reality, it was also getting my SELECT...
A nice post about handling DateTime fields and indexing. http://itknowledgeexchange.
Scenario - My stored procedure just returns some integer values depending on different conditions. There are no OUT or any other parameters involved for returning values from the stored procedure. e.g. IF (EXISTS( SELECT * FROM TableName WHERE UserId = @UserId AND RoleId = @RoleId)) RETURN(1) ELSE RETURN(0) If you notice, there are no output parameters involved here. The return value can be accessed from code (C# for example), like this: SqlParameter returnValueParam = command.Parameters.Add("@re...