Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Need help in writing the cursor

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-02 : 09:05:30
Harish writes "I wanna write the cursor which will update the column of the table

table structure t1
col1 col2
1 102
2 103
3 104
4 102
5 103

i want to concatenate 000 in the col2
and need the result like this

col1 col2
1 102000
2 103000
3 104000
4 102000
5 103000

Help me in writing this cursor

Thanks in Advance

Harish"
   

- Advertisement -