ms sql print from new line 1

ms sql print from new line

	-- CHAR(10) makes new line in windows
    PRINT 'line 1' + CHAR(10) + 'line 2'

Here is what the above code is Doing:
1. Create a table called ‘test’ with a column called ‘name’
2. Insert a row into the table with the value ‘test’
3. Select the row from the table
4. Print the row
5. Print a new line
6. Print ‘line 1’ and ‘line 2’ on separate lines

Similar Posts