Is there a difference between SQL7 and SQL2000 regarding discussed matter?

quote:

---

May be you need to have "With" verb before (NOLOCK). I did not try and i am not sure.

---

As Andy mentioned, try to use real temp table #aarobtmp and you probably will get thru.

There are some permissions issues regarding "select --into":

May be the following error message has some...

Thanks, Antares, I will look into this - I didn't even think that it could be the rights issue.

Use error handler.

Do all your error related processes there and then exit the procedure.

Recently I posted a script for Error handling inside stored procedure:

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=275

Hope it will help you out.

Edited...

I'm not sure why, but if you put your file in the root directory on c: and specify only name of the document, like: @attachments = 'test.doc' it will work....

Instead of

quote:

---

create sp (@mv_string varchar(1000) )

as

BEGIN

select *

from my_table

where user_id in (@mv_string)

---

Try:

create sp (@mv_string varchar(1000)...

From BOL:

*************************************************************

SET ANSI_NULLS (T-SQL)

Specifies SQL-92 compliant behavior of the Equals (=) and Not Equal to (<>) comparison operators when used with null values.

Syntax

SET ANSI_NULLS {ON | OFF}

Remarks

The SQL-92 standard requires...

The TEXT data type actualy hold a pointer to a binary file on your server, not the data itself in the column.

We have special 'text' tables with several Varchar...

Cool, never thought of it!

from BOL:

CURSOR_STATUS (T-SQL)

A scalar function that allows the caller of a stored procedure to determine whether or not the procedure has returned a cursor and result set for a given...

I don't think it possible.

You can do it shorter:

declare @header varchar(50)

set @header = 'TestColumn'

exec ('select 1 as ' + @header)

See my answer to your second post about nested loops in outer joins - use either FORCE ORDER query hint or SET FORCEPLAN ON

I think the following info from the http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7443&pg=3 might help you out:

With no hint, the query optimizer decides the order of the joins on a cost-based estimation, regardless of their...

Could you post a script for illustration?