Tags
Complex SQL Challenges, Complex TSQL Challenge, Interesting Interview Questions, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Learn complex SQL, Learn SQL, Learn T-SQL, Objective Puzzle, PL/SQL Challenges, puzzle sql developer, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Interview Questions, SQL Joins, SQL pl/sql puzzles, SQL Puzzles, SQL Queries, SQL Quiz, SQL Server Database, SQL SERVER Interview questions, SQL Skills, SQL Sudoku, SQL Top clause, SQL Trikcy question, sql/database interview for puzzle sql developer, SQLSERVER, T SQL Puzzles, T-SQL Challenge, TOP Clause, Tough SQL Challenges, Tough SQL Puzzles, Tricky Questions, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries
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