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.

Background: I'm working on a windows machine with GB2312 as the native encoding. The SQL Server uses GB2312 as the default encoding as well (what I mean is that the result it returns is GB2312 and it ...

When selecting the data, I was expecting the zero values to be returned as 0.00 or 0, but they were returning as .00.<BR>So, I changed some fields to numeric (8,2), hoping that would help.