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.
| Author |
Topic |
|
sara
Starting Member
4 Posts |
 Posted - 2007-08-12 : 06:18:48
|
| Hai, can i use cursor to update the record in the base table. if i update the cursor,will that get refelcted in the table.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-12 : 09:26:49
|
It depends on how you declare you cursor.But why, WHY, why do you need a cursor to update a table?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
sara
Starting Member
4 Posts |
Posted - 2007-08-12 : 19:41:58
|
quote:
Originally posted by khtan
is this question related to your the other post ? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87703
KH[spoiler]Time is always against us[/spoiler]
Yes. you are right..i want to do batch update..so im thinking that i can use cursor for that..i dont have any other soltion as of now. |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-13 : 08:50:07
|
| post some sample data if possible and table which you are trying to update.there can be a way around cursors sometimes.Ashley Rhodes |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-13 : 08:54:24
|
quote:
Originally posted by sara
quote:
Originally posted by khtan
is this question related to your the other post ? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87703
KH[spoiler]Time is always against us[/spoiler]
Yes. you are right..i want to do batch update..so im thinking that i can use cursor for that..i dont have any other soltion as of now.
You didnt specify anything on Tan's queryMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
basic question abt cursor