HI
for debuging in VS I put breakPoint on line and click on F10 key and it debug step by step
Now I want debug storeprocedure in sql below is my SP
create procedure dbo.debug
@name nvarchar(20)
,@Transfer nvarchar(30)
,@Type nvarchar(30)
,@Mobile varchar(20)
AS
BEGIN
DECLARE @Result AS int
IF NOT EXISTS(SELECT id FROM Estate_free WHERE (@Mobile IS NOT NULL AND Mobil = @Mobile))
BEGIN
insert into Estate_free(name,Transfer,Type)
values(@name,@Transfer,@Type)
SET @Result = 1
END
else
begin
SET @Result = 0
END
END
in this SP I should enter some parameters
I want checked IF condesion will be run or else will be run?
How I can debug it ?
thanks alot