Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 408
Incorrect syntax near 'end'.
ممكن حل
دة البروسيد
كود بلغة HTML:
if(@Operation = 41 and @ItemRefID= '42279')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '5' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42280')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '6' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '422811')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '7' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42282')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '8' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42283')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '9' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42284')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '10' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42285')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '11' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42286')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '12' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42287')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '13' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42288')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '14' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42289')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '15' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42290')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '16' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42291')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '17' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42292')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '18' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42293')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '19' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42294')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '20' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42295')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '21' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42296')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '22' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42297')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '23' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42298')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '24' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42299')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '25' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42300')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '26' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42301')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '27' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42302')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '28' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42303')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '29' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42304')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '30' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42305')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '31' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42306')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '32' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42307')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '33' Where CharID = @CharID
if(@Operation = 41 and @ItemRefID= '42308')
BEGIN
Update SRO_VT_SHARD.._Char Set HwanLevel = '34' Where CharID = @CharID