是不是首字母大写,其他小些??
declare @input varchar(20)
set @input='abcd'
insert tablename(fieldname) values(UPPER(LEFT(@input,1)+LOWER(RIGHT(@input,LEM(@input)-1)))
declare @input varchar(20)
set @input='abcd'
insert tablename(fieldname) values(UPPER(LEFT(@input,1)+LOWER(RIGHT(@input,LEM(@input)-1)))
set @input='abcd'
insert tablename(fieldname) values(UPPER(LEFT(@input,1))+LOWER(RIGHT(@input,LEN(@input)-1)))
@input varchar(20)
AS
insert tablename(fieldname) values(UPPER(LEFT(@input,1))+LOWER(RIGHT(@input,LEN(@input)-1)))
GOEXEC INPUT_CHAR 'EFGH'