Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


T-SQL Output Query | [ The Single SELECT Puzzle List – Part 3 ]

Please go through the below objective type queries and provide output..


--

--Query 1
SELECT SPACE(1) + 1

--Query 2
SELECT LEN(SPACE(1) + CAST(1 AS VARCHAR(1)))

--Query 3
SELECT LEN(SPACE(1) + 1)

--Query 4
SELECT LEN(' AB ')

--Query 5
SELECT LEN('AB ')

--Query 6
SELECT DATALENGTH(' A B ')

--Query 7
SELECT CONCAT('Pawan',1)

--Query 8
SELECT 'PAWAN' + 1

--Query 9
SELECT LEN(SPACE(1) + 'PAWAN')

--Query 10
SELECT DATALENGTH(SPACE(1) + 1)

--

Keep Learning