假如,我们要测试一个叫做usp_MoreThan()的存储过程,这个存储过程返回SQL表中价格高于输入数值的int值:
create procedure usp_MoreThan
@inputPrice money
as
declare @ans int
select @ans = count(*) from tblPrices where price > inputPrice
return @ans
go
- int expected = 2;
- int actual;
- string input = "100.00";
- string connString = "Server=(local);Database=dbPrices;UID=userId;PWD=password";
- SqlConnection sc = new SqlConnection(connString);
- SqlCommend cmd = new SqlCommend(