I think, there is some mistake in the correct answer. Both the queries are same in the sense that they return same resultset. In the explanation of the question, it...

Hey Powell,

Here is my query:

Select replace( subp.vproduct+

l.vtype+

...

The thing is that I need to store the output of a query (which is more than 8000 char) into the text column.

And other thing is that string operations like...

if you have access to the application source code which is using this database, then you can debug the application and find out when the records are inserted.

You could also...

What kind of comparisons do you want to do?

Hi,

you could use the @@rowcount property for getting the number of rows of a table and store in some variable to be used in some query.

eg:

select * from tableName;

select @@ROWCOUNT;

Mayur

Hi,

try the following simple script:

-------------------------------------------------------------------------------

declare @count int;

declare @counter int;

declare @STR varchar(20);

declare @temp varchar(1)

declare @tbl table

(

id smallint identity,

alpha varchar(20)

)

insert into @tbl select a from alpha;

select @count=count(1) from @tbl;

set

Hi,

have a look at this atrticle. I hope it would help you.

http://www.sqlservercentral.com/articles/Error+Description/65013/