at first,i think its all because of the "IntelliSense Enabled",but its not the truth.

Hoping for the answer....

thanks.

«Inside SQL Server 2005:T-SQL»says:

"SET @var = value" is the right way to assign value to variables;

when u use "SELECT @var=col",the results may diff,

because u dont know how query optimizer executes...

Got it ...

Thanks

Two questions:

1: the "sid > 1" 

   If the "sa" create a product database,the sid in the sysdatabases table will be 'Ox01'.Then the command doesn't work well.

2:the query listed below

Declare...

I do agree with the "add him to the role and DENY individually access to the Vacation table~~~"

The most simple way ....

Mission impossible.

But if u just want to recover the only one row, and u know when it was last modified,u can restore the database to the specified time.

use ur_DB

sp_configure 'Allow Update',1

Reconfigure WITH OVERRIDE

Update sysTypes

Set uid = user_id('sa')   -- change "sa" with the new owner

Where Name = 'TestType'

--TestType is the name of the UDT

sp_configure 'Allow Update',0

Reconfigure WITH OVERRIDE

I think the "With Index()" Option will help~

I think it is better to limit the input parameter @n <= 10.

I modify this proc in my SQL 2000 Query Analyzer

just change the length of all parameters such as...