I"ve a table like this
create table tblTest
(id int identity (1,1),
empID varchar(11) collate SQL_Latin1_General_CP1_CI_AS)
here My database Collation and the empID collation are same.
I've inserted few records in to this table
insert tblTest
select '00001000023'
insert tblTest
select '00001000022'
insert tblTest
select '00001000020'
insert tblTest
select '00001000019'
insert tblTest
select '00001000018'
insert tblTest
select '00001000017'
insert tblTest
select '00001000016'
-- Now Query Part
select * from [dbo].[tblTest] where empid ='00001000023'
select * from [dbo].[tblTest] where empid ='00001000023'
I've executed both the statements at the same time
I got result for the second line and for the first query i did not get any result .what would be the cause ?