Q 1 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 11 ,3) as output
1> ‘Microsoft’
2> ‘SQL’
3> BLANK
4> Invalid Substring statement
Answer
Q 2 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 11 ,0) as output
1> ‘Microsoft’
2> ‘SQL’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 3 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , -1 ,9) as output
1> ‘Microso’
2> ‘SQL’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 4 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 1 ,9) as output
1> ‘Microsoft’
2> ‘Microsof’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 5 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT ‘SQL ‘ + SUBSTRING( @stringtxt , 15 ,6) as output
1> ‘SQLย SQL SERVER’
2> ‘SQL SER’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 6 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt +‘ SQL’ , 15 ,6) as output
1> ‘SQL SER’
2> ‘SQL SERVER’
3> BLANK
4> ‘SERVER’
Answer
Q 7 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 11 ,Len(@stringtxt)-10) as output
1> ‘Microsoft SQL SERVER’
2> ‘SQL SERVER’
3> ‘Microsoft’
4> Invalid Syntax
Answer
Q 8 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , null , null)ย as output
1> ‘SQL SERVER SQL’
2> ‘SQL SERVER’
3> null
4> ‘Microsoft SQL SERVER’
Answer
Q 9 >ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 0 ,0) as output
1> ‘Microsoft’
2> ‘SQL’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 10>ย
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , null , null)ย as output
1> ‘SQL SERVER SQL’
2> ‘SQL SERVER’
3> null
4> ‘Microsoft SQL SERVER’
Answer
Recommended Posts..
SQL Interview Q & A Quiz on Select Statement
SQL Interview Q & A Quiz on Create statement
2,781 total views, 8 views today