question

karthick 1 1 avatar image
karthick 1 1 asked

updating row by using cursor

Want to Write a cursor to update the acc opening balance for salary account to be 0.0 and savings account to be 1000 and student account to be 500 and others 100....i dont know how to query it..help me if u can...

thankz....

sql-server-2005
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

graz avatar image graz ♦ commented ·
As the first response said, please edit your post to add some information like table structure and expected output.
0 Likes 0 ·

1 Answer

·
RickD avatar image
RickD answered

To help you, we would need more details about what you are trying to achieve.

Please post some structures and examples of what you have and what you want.

Thanks.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.