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

Publié le: 27 décembre 2020
sur la chaîne: 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...

Sur cette page du site, vous pouvez voir la vidéo en ligne Comma Separated values in SQL | XML PATH | SQL to XML Format | Row Tag| Root Tag | SQL Interview Q&A durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur SQL With RaviMartha 27 décembre 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 7,189 fois et il a aimé 134 téléspectateurs. Bon visionnage!

9,539

401