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 |
|
dzabor
Posting Yak Master
138 Posts |
 Posted - 2010-05-23 : 13:48:01
|
| I need to update security roles in a table. Everyone in the table is currently assigned one role based on their member type. We are opening up a committee role based on the members committee involvement. I need to add this to the same security role field and separate by a comma.Current record:Role = 'ChapterMemberRole'Need to add committee role: 'Board' |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-05-23 : 15:59:27
|
| What is that?? |
 |
|
|
dzabor
Posting Yak Master
138 Posts |
Posted - 2010-05-23 : 16:13:26
|
| ID |
|
|
|
dzabor
Posting Yak Master
138 Posts |
Posted - 2010-05-23 : 16:13:26
|
| ID |
|
|
|
dzabor
Posting Yak Master
138 Posts |
Posted - 2010-05-23 : 16:13:26
|
| ID |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-24 : 09:44:55
|
| Update tableset security_role=security_role+','+'Board'where some_conditionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Append query