问使用sql server从全名获取带有初始值的名称。

EN

SELECT LEFT(FirstName, 1), LastName FROM Table

SELECT LEFT(FirstName, 1), LEFT(MiddleName, 1), LastName FROM Table

DECLARE @name as nvarchar(50)
DECLARE @nSpace as int
DECLARE @i as int
DECLARE @nameResult as nvarchar(50)
DECLARE @index as int
DECLARE @newname as nvarchar(50)
--you can replace the name for test if all works well
--that variable @name you need to pass in store procedure
SET @name = 'John Cena'
--get the number of the spaces in the string
SET @nSpace = LEN(@name)-LEN(REPLACE(@name, ' ', ''))
--check if the number the spaces is even or odd, if is even need add a space at the end
if @nSpace % 2 = 0 
    SET @name = @name + ' '

--SELECT @nSpace
--index used in the loop
SET @i = 1
--inicialization the variable nameresult
SET @nameResult = ''

while @i <= @nSpace
begin
    --get the index of the position of the space
    SET @index = CHARINDEX(' ',@name)
    --get the first letter of the substring
    SET @newname = SUBSTRING(@name,1,@index)
    --start to mount the name
    SET @nameResult = @nameResult + LEFT(@newname,1) + ' '
    --remove from the name the part already usend
    SET @name = RIGHT(@name,len(@name)-(@index-1))
    --increase the loop
    SET @i = @i + 1

end
--finish with the last name
SET @nameResult = @nameResult + @name
--show the result, in the store procedure that should be the return of the function
SELECT @nameResult