将列拆分为各个列

-- Create table dbo.FullNameTest
IF OBJECT_ID('FullNameTest') IS NOT NULL BEGIN
   DROP TABLE dbo.FullNameTest;
END;

CREATE TABLE FullNameTest
(
   ID           INT          Not Null IDENTITY
   , FullName   NVARCHAR(80) Not Null
   , CONSTRAINT PK_ID  PRIMARY KEY CLUSTERED(ID)
);
GO

INSERT INTO FullNameTest
VALUES('Mr Hog Finn Gad'), ('Grace Bruce'), ('Dr.Paul'), ('Master Clark James'), ('Mrs.Rignald')

SELECT * FROM FullNameTest
-- Create table dbo.FullNameTest
IF OBJECT_ID('