Even though the SQL value is a string, SQL Server executes the string as if it is SQL code. Transact SQL, or T-SQL, provides you with the language to create the dynamic code.

SELECT * FROM student Verify data insertion into the “student” table 1. Use STRING_SPLIT Function to Split the String An easy way to split strings in SQL Server is by using the STRING_SPLIT function.