Here is a xUnit suite for stored procedures in SQL Server.
Here is the version for Oracle
This is a slight pain having two suites for the various databases.
I am not sure what the author of “Working Effectively WIth Legacy Code” would make of these.
His definition of a unit test involves not touching a database – which would make this difficult.