update syntax using cursor is as follows

update <table name> set <condition>

where current of <cursor name>

it updates one row at a time. based on the position of cursor

Here is my code

-----

create procedure Usp_TableType

@table1 table(sno int,sname varchar(20))

as

insert into @table1 values(1,'xyz')

return @table1

go

----

here is error messages

Server: Msg 156, Level 15, State 1, Procedure Usp_TableType, Line 2

Incorrect syntax near the keyword...

Our server was running under local system account. now we changed to domain account.

now debugger is working fine.

thanks

ravi

Thank you allen,

Its working

I was the only person on the total server when i ran the quey in query analyser.Does this query analyser is goodenough as ado/rdo connected application or is QA slow?.

...