如何将连接的列拆分成独立的列并使用数据？(VB.Net + SQL Management Studio)

Imports System.Data.SqlClient

Public Class Form1
    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim connectionString As String = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword"
        Dim query As String = "SELECT CONCAT(FirstName, ' ', LastName) AS FullName FROM Customers"

        Using connection As New SqlConnection(connectionString)
            connection.Open()

            Using command As New SqlCommand(query, connection)
                Using reader As SqlDataReader = command.ExecuteReader()
                    While reader.Read()
                        Dim fullName As String = reader("FullName").ToString()
                        ' 在这里可以对fullName进行拆分和处理
                        ' 例如，可以使用字符串函数来拆分fullName并将其存储到独立的列中
                    End While
                End Using
            End Using
        End Using
    End Sub
End Class

Dim names() As String = fullName.Split(" ")
Dim firstName As String = names(0)
Dim lastName As String = names(1)

SELECT 
    SUBSTRING(ColumnName, 1, CHARINDEX(' ', ColumnName) - 1) AS FirstName,
    SUBSTRING(ColumnName, CHARINDEX(' ', ColumnName) + 1, LEN(ColumnName)) AS LastName
FROM TableName