| Author: avtar 26 Aug 2008 | Member Level: Gold | Rating:  Points: 3 |
Use this select statement in ur SP
declare @c int
set @c = 2
select @c
select Out =
CASE @c
WHEN 0 THEN 'Email doesnot exist'
WHEN -1 THEN 'Email Already exist'
ELSE 'Invalid'
END
|
| Author: venkatesan 26 Aug 2008 | Member Level: Diamond | Rating: Points: 1 |
Hi can u give the full SP
so let you define clearly..
Regards,
M.Venkatesan.
Dot Net Code Snippets
|
| Author: avtar 26 Aug 2008 | Member Level: Gold | Rating: Points: 4 |
Create procedure Test
as
begin
declare @c int
set @c = 2
select @c
select Out =
CASE @c
WHEN 0 THEN 'Email doesnot exist'
WHEN -1 THEN 'Email Already exist'
ELSE 'Invalid'
END
end
try to change value of @c to 0 , -1 and see teh output
|
| Author: venkatesan 26 Aug 2008 | Member Level: Diamond | Rating: Points: 0 |
i think u didnt got my point..
Regards,
M.Venkatesan.
Dot Net Code Snippets
|
| Author: Vijayaragavan.R 27 Aug 2008 | Member Level: Bronze | Rating: Points: 4 |
Create procedure Test
as
begin
declare @c int
set @c = 2
select @c
select Out =
CASE @c
WHEN 0 THEN 'Email doesnot exist'
WHEN -1 THEN 'Email Already exist'
ELSE 'Invalid'
END
end
try to change value of @c to 0 , -1 and see teh output
|