Comma Separated values in SQL | XML PATH | SQL to XML Format | Row Tag| Root Tag | SQL Interview Q&A

Veröffentlicht am: 27 Dezember 2020
auf dem Kanal: SQL With RaviMartha

7,189

134

SQL Scripts used in this video, you can run and explore:

CREATE TABLE Employees (empname varchar(50) , empLocation varchar(50))

INSERT Employees Values ('smith','Newyork'),('Jones','London'),('smith','Scotland')
,('Adams','Chicago'),('Jones','Dallas')

select * From Employees

select * From Employees FOR XML PATH;

select * From Employees FOR XML PATH ('Employee');

select * From Employees FOR XML PATH ('');

select * From Employees

select DISTINCT EmpName,
STUFF(( SELECT ',' + Emplocation FROM Employees b WHERE a.EmpName = b.EmpName FOR XML PATH('')),1,1,'') EMpLocation
From Employees a

select * From Employees FOR XML PATH ('Employee'), ROOT ('Employees');

Blog: https://sqlwithravimartha.blogspot.com/

Facebook Page:
  / sql-with-ravimartha-109497027391239
  / etl-dwh-testing-100494175057349

YouTube Channel:
   / @sqlwithravimartha6357

This channel would provide new videos on SQL, ETL and Data warehouse concepts. I would create a separate play list for SQL Tutorials for beginners, advanced concepts, Interview questions and data warehousing concepts

Feel free to drop me an email at sql.ravimartha@gmail.com in case of any queries you have in SQL or clarifications on the videos I have done :)

Blog: https://sqlwithravimartha.blogspot.co...

Video 12: Import Tables from one Server to another Using SSMS | Import tables using SQL Query in SSMS --*   • Import Tables from one Server to anot...
Blog: https://sqlwithravimartha.blogspot.co...

Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --*   • Table Variables in SQL Server | Pound...
Blog: https://sqlwithravimartha.blogspot.co...

Video 10: Quick Practical onTemporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table--*   • Quick Practical on Temporary tables i...
Blog: https://sqlwithravimartha.blogspot.co...

Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- *   • Temporary tables in SQL Server | Temp...
Blog: https://sqlwithravimartha.blogspot.co...

Video 8: Running total & Avg in SQL | Cumulative Sum & Avg in SQL | Calculating running total & Avg in SQL -- *   • Running total & Avg in SQL | Cumulati...
https://sqlwithravimartha.blogspot.co...

Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- *    • Length Vs DataLength Vs ColumnLength ...
https://sqlwithravimartha.blogspot.co...

Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- *    • Tricky CASE Statement Interview Quest...
https://sqlwithravimartha.blogspot.co...

Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- *    • Delete Duplicates in SQL by retaining...
https://sqlwithravimartha.blogspot.co...

Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- *    • Difference between TRUNCATE, DELETE a...
https://sqlwithravimartha.blogspot.co...

Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting -- *   • Sorting in SQL | Order By | Condition...
https://sqlwithravimartha.blogspot.co...

Video 2 Title: Difference between Primary Key and Unique Key -- *   • Difference between Primary Key and Un...
https://sqlwithravimartha.blogspot.co...

Video 1 Title: Logical Processing of SELECT Statement -- *   • Logical Processing of SELECT Statemen...
https://sqlwithravimartha.blogspot.co...

Auf dieser Seite können Sie das Online-Video Comma Separated values in SQL | XML PATH | SQL to XML Format | Row Tag| Root Tag | SQL Interview Q&A mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer SQL With RaviMartha 27 Dezember 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 7,189 Mal angesehen und es wurde von 134 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

9,539

401