[fadzlan]

I understand that if the test hits database, then its an integration test.

But what if a whole load of the logics are in stored procedure? Surely those needs test too.

Of course, one can make an argument that depending too much on stored procedures is an anti pattern....

[atom-morgan]

The stored procedure should be tested within the domain of the stored procedure. The consumer of its result just tests its ability to use the result it should be given (fulfilling its end of the contract).