update UserInfo
set Enable = 1
update UserInfo
set Enable = 1
From UserInfo
join userGroupList
On userGroupList.USERID = UserInfo.ID
AND userGroupList.GROUPID = 'Test'
Thanks for your reply. I agree we can turn the value from 0 to 1 in field enabled. For e.g.
Update userinfo set enable=1 // this statement will enable all the users in table.
But our situation is a bit tricky. We don’t want to enable all the users. We have a list of users that needs to be enabled.
We're thinking to run a sql script before database refresh, and the output of script should be run on database after refresh to enable only users which was enabled before DB refresh. Can this be achieved by sql script?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156