its not entering the if loop

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL

ALTER PROCEDURE [dbo].[employeegeofence2]
@employeename varchar(64),
@basestationame varchar(64),
@superuserid varchar(64),
@creationdate datetime
AS
begin
Declare @emp as varchar(50)
Declare @empid as varchar(50)

select @empid=tag_id from  student_master where First_Name=@employeename
print @empid
select @emp=First_Name from student_master where First_Name=@employeename
print @emp

if(@emp = '' ) line5
begin
print'sucess'
end
else
begin
prnit 'inserted'
end
SET NOCOUNT ON;
END

The issue I face is that empid and the empname do not exist in the table so it should enter inside the if loop, but its not entering and printing success as n line 5.
I gave (@emp=null) then also its not enetring the if loop only the else gets executed anyone help me out.

Posted 14-Nov-11 17:58pm

ashok_89

Updated 14-Nov-11 18:02pm

Sergey Alexandrovich Kryukov

v3

Add a Solution

2 solutions

Solution 1

If First_Name doesn't exist in the table (ie, there's no data), it's going to return NULL, not ''.

Check out the isnull(FIELD, '') function if you want to replace NULL with an empty string.

Posted 14-Nov-11 18:05pm

_Damian S_

Comments

ashok_89 15-Nov-11 0:09am

always the inserted is only getting printed

_Damian S_ 15-Nov-11 0:41am

Of course it is - that's the else part. The value is not '', it's NULL. NULL and '' are different.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RaisKazi · Accepted Answer · 2011-11-14T18:10:00

You may initialize default value to @emp as below.

SQL

Set @emp = '';

Probably their is no records in your student_master Table for the value you are passing for parameter @employeename.

Or you may keep your check on the basis of count as below.

SQL

Declare @empCount as int;

select @empCount=count(First_Name) from student_master where First_Name=@employeename;

if(@empCount=0) 
begin
  print'sucess'
end
else
begin
  prnit 'inserted'
end

its not entering the if loop

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

its not entering the if loop

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us