SQLTeam.com | Weblogs | Forums

Getting no Result set some time


#1

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 ?


#2

No idea, looks fine to me. What are you running that query in? If it is e.g. an application then the application would have to be prepared to handle multiple resultsets.


#3

This is Simple Query which i ran it SQL 2012


#4

please post a screen shot/screen capture of what you are actually seeing