UPDATE SET FieldsName = SUBSTRING(FieldsName,1,2)+'0'+SUBSTRING(FieldsName,3,8) FROM TableName WHERE LEN(FieldsName)<9
UPDATE SET FieldsName = SUBSTRING(FieldsName,1,2)+'0'+SUBSTRING(FieldsName,3,8) AS FieldsName FROM TableName WHERE LEN(FieldsName) <9
第一个对,没有AS FieldsName,呵呵
UPDATE SET FieldsName = SUBSTRING(FieldsName,1,2)+'0'+SUBSTRING(FieldsName,3,8) AS FieldsName FROM TableName WHERE LEN(FieldsName) <9
select fieldName = case len(fieldName) when 8 then substring(fieldName,1,1)+'0'+substring(fieldName,2,7) else fieldName end from temp select fieldName = case len(fieldName) when 8 then substring(fieldName,1,1)+'0'+substring(fieldName,2,len(fieldName)-1) else fieldName end from temp
应该为: select fieldName = case len(fieldName) when 8 then substring(fieldName,1,2)+'0'+substring(fieldName,3,6) else fieldName end from tempselect fieldName = case len(fieldName) when 8 then substring(fieldName,1,2)+'0'+substring(fieldName,2,len(fieldName)-2) else fieldName end from temp
select fieldName = case len(fieldName) when 8 then substring(fieldName,1,2)+'0'+substring(fieldName,3,len(fieldName)-2) else fieldName end from temp
update后面加个tablename就可以了,正解
UPDATE TableName SET FieldsName = SUBSTRING(FieldsName,1,2)+'0'+SUBSTRING(FieldsName,3,8) AS FieldsName WHERE LEN(FieldsName) <9 呵呵,有点晕了,给高混了
select fieldName = case len(fieldName)
when 8 then substring(fieldName,1,1)+'0'+substring(fieldName,2,7)
else fieldName end
from temp
select fieldName = case len(fieldName)
when 8 then substring(fieldName,1,1)+'0'+substring(fieldName,2,len(fieldName)-1)
else fieldName end
from temp
应该为:
select fieldName = case len(fieldName)
when 8 then substring(fieldName,1,2)+'0'+substring(fieldName,3,6)
else fieldName end
from tempselect fieldName = case len(fieldName)
when 8 then substring(fieldName,1,2)+'0'+substring(fieldName,2,len(fieldName)-2)
else fieldName end
from temp
when 8 then substring(fieldName,1,2)+'0'+substring(fieldName,3,len(fieldName)-2)
else fieldName end
from temp
update后面加个tablename就可以了,正解
呵呵,有点晕了,给高混了