2011年3月28日 星期一

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