I want text data type only.My text is more than 8000 char

What should I do in this scenario?

Yes I am fresher just out of college.

I had undergone training for some months but have never worked on live projects.

But they have put me in a project and asked...

But i want the R_id also to be displayed.How can that be done...

I used stored procedure but it is not working properly

Thanks Sanjay.

It is working fine

That is fine

But I want to get the duplicate records deleted from my table

and get the final result

how is this possible in sql 2000

Thanks

Yes Fracn

varchar2 is used by Oracle only

Thanks for your reply

Nisha

Thanks Fracn

Could you please tell the size for each datatype 

 char,varchar and varchar2

Hi,

I have seen it in BOL.

The size for char and varchar is given as 1 through 8000 bytes.

But in google when i searched it says that varchar stores upto 2000...

Hi,

You can try this one also

select fieldName from dbo.table

where cast(rowid as int)% cast(2 as int)=1