Unit Testing for SQL Server Database Projects with Visual Studio
Learn database testing concepts, database testing basics and how to perform database testing manually with this database testing tutorial with examples in SQL Serve
================The Database Table =================
==============The Sample Stored Proc=================
create proc entrytest
(
@id Int = NULL ,
@Name VARCHAR(50) = NULL ,
@City VARCHAR(50) = NULL
)
as
INSERT INTO emptb1
VALUES
(
@id ,
@name ,
@city
)
go
==============Run Stored Proc=================
exec entrytest
@id =1 ,
@Name ='Peter' ,
@City ='pune'
go
============ The Unit test ( Test Condition = Row Count = 0 and later 1)=====
DECLARE @RC AS INT, @id AS INT, @Name AS VARCHAR (50), @City AS VARCHAR (50);
SELECT @RC = 0,
@id = 3,
@Name = 'peter',
@City = 'pune';
EXECUTE @RC = [dbo].[entrytest] @id, @Name, @City;
SELECT @RC AS RC;
============ The Unit test ( Pre Test Condition = No Condition)=====
delete from dbo.emptb1 where id=3
============ The Unit test ( Post Test Condition =Row Count = 1)=====
select * from dbo.emptb1 where id= 3
На этой странице сайта вы можете посмотреть видео онлайн Unit Testing for SQL Server Database Projects with Visual Studio длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь TechPledge 06 Декабрь 2019, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 6,792 раз и оно понравилось 50 зрителям. Приятного просмотра!
