SQL 筆記未整理版本

update dbo.TB_User

set sec_primary=1, sec_content=1

where struserid in ('unalisgm11', 'unalisgm12', 'unalisgm13','unalisgm14', 'unalisgm15')

-- ''una*"

select sec_primary, sec_content from dbo.TB_User where struserid in ('unalisgm11', 'unalisgm12', 'unalisgm13','unalisgm14', 'unalisgm15')

In Not Exists (select * from _ModuleVersion Where nModuleID = 9 AND nVersion > 250)

BEGIN

Print("Error - Not Exist...')

END

ELSE

BEGIN

UPDATE _ ModuleVersion

SET nValid = 1

Where nModuleid = 9 AND nVersion = 250

DELETE

FROM _ModuleVersion

Where nModuleID = 9 AND nVersion > 250

end