Help on SQL Script

lcs1788 — Wed, 18 Oct 2006 10:43:39 +0800

hi all, i have a sql script to update all linked table, but i get the error say tat the @Country is Invalid obj...???
Will be appreciate very much

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

(1 row(s) affected)

Server: Msg 208, Level 16, State 1, Line 19
Invalid object name '@Country'.

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

My SQL Statement is below, can anybody help me???
-------------------------------------------------

Declare CountryCursor CURSOR
FOR Select SysObjects.name from Syscolumns, sysobjects where syscolumns.name = 'Country' and sysObjects.xtype = 'u' and syscolumns.id = sysobjects.id

Open CountryCursor

Declare @Country char(256)

Fetch Next From CountryCursor into @Country
select @Country

While @@FETCH_STATUS = 0
Begin

update @Country --<<Here is the error

set Country=Replace(left(Country,3),Char(13),'')

Fetch Next From CountryCursor into @Country
End

Close CountryCursor

Deallocate CountryCursor

Lowyat.NET: Latest topics by lcs1788

Help on SQL Script