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: sqlwithravimartha.blogspot.com/
Facebook Page:
/ sql-with-ravimartha-10...
/ etl-dwh-testing-100494...
KZitem 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: 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...
Blog: sqlwithravimartha.blogspot.co...
Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --* • Table Variables in SQL...
Blog: 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 Tem...
Blog: sqlwithravimartha.blogspot.co...
Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- * • Temporary tables in SQ...
Blog: 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...
sqlwithravimartha.blogspot.co...
Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- * • Length Vs DataLength V...
sqlwithravimartha.blogspot.co...
Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- * • Tricky CASE Statement ...
sqlwithravimartha.blogspot.co...
Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- * • Delete Duplicates in S...
sqlwithravimartha.blogspot.co...
Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- * • Difference between TRU...
sqlwithravimartha.blogspot.co...
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting -- * • Sorting in SQL | Order...
sqlwithravimartha.blogspot.co...
Video 2 Title: Difference between Primary Key and Unique Key -- * • Difference between Pri...
sqlwithravimartha.blogspot.co...
Video 1 Title: Logical Processing of SELECT Statement -- * • Logical Processing of ...
sqlwithravimartha.blogspot.co...
Негізгі бет Comma Separated values in SQL | XML PATH | SQL to XML Format | Row Tag| Root Tag | SQL Interview Q&A
Пікірлер: 13