Tip of the day

SQL Server : 3 Tricky SQL Queries Interview Questions and Answers

1). SELECT 16    what is the output of this query?

A). Throw error
B). 16
C). 0
D). 1


2).SELECT $     what is the output of this query?

A). Throw error
B). $
C). 1
D). 0.00


3). SELECT COUNT(*)     what is the output of this query?

A). Throw error
B). 0
C). 1
D). *

- by Venkateswarlu Cherukuru

Question of the day

SQL Server : How to concatenate multiple rows into a single text string ?

Let us have a table with the following data:

CourseID    CourseName
1                 .Net
2                 SQL Server
3                 SSRS
4                 SharePoint
5                 WCF

We need to concatenate the ClientName column like the following:

.Net, SQL Server, SSRS, SharePoint, WCF

Solution - Method 1

SELECT CourseName + ', '
From CoursesTable
For XML PATH('')

Solution - Method 2

DECLARE @CourseNames VARCHAR(MAX);
SET @CourseNames = '';

SELECT @CourseNames = @CourseNames + IsNull(CourseName + ', ', '')
FROM CoursesTable
Select @CourseNames

- by Venkateswarlu Cherukuru

We are inviting Tips & Questions from you. Click Here to share your valuable Tips & Questions on this website.

• Your Tips & Questions will be displayed on website, after validating the information you provided.
• Tips & Questions will be refreshed on every day 12:00 AM IST.