Buy Questpond's video subscriptions on
huge discount
.
Online: 1008
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
What will be the output of
declare @t table(names varchar(MAX))
insert into @t
select 'Ram' union all
select 'Shyam' union all
select 'Jadhu' union all
select 'Madhu'
DECLARE @NamesList VARCHAR(8000);
SELECT @NamesList =
COALESCE(@NamesList + ', ', '') + CAST(names AS varchar(20))
FROM @t
SELECT @NamesList INTERSECT SELECT NULL
Posted by
Rajnilari2015
on 11/7/2015 | Category:
Sql Server Interview questions
| Views: 1913 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
Ram, Shyam, Jadhu, Madhu
Madhu,Jadhu,Shyam,Ram
No Result
Error
All Above
Since no element is common in the SET
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
What will be the output of declare @t table(na ...
Next > :
What will be the output of declare @t table(na ...
Comments or Responses
Login to post response
More Interview Questions by Rajnilari2015
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
What will be the output of declare @t table(names varchar(MAX)) i ...
Latest Interview Questions
What is Angular Prefixes $ and $$?
How AngularJS handle the security?
What is the size of angular.js file?
Is AngularJS a library, framework, plugin or a browser extension?
What is jQLite or jQuery lite?
How to use jQuery with AngularJS?
What IDEs you can use for AngularJS development?
How AngularJS is different from other JavaScript Framework?
More ...