Can anybody tell me if i can retrieve the specific records without using
filter that is where clause

Why don't you want to use a WHERE clause? Could you explain the problem
with an example (A CREATE TABLE statement and some sample data may
help.)

--
David Portas
SQL Server MVP
--

Without a WHERE filter how would you retrieve specific rows? You would have
to retrieve the whole table and filter somewhere else which will no doubt be
less performant

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Gopalan" <Gopalan (AT) discussions (DOT) microsoft.com> wrote