Friday, April 29, 2016

Convert SQL Table to XML in SQL Server

Convert SQL Table to XML in SQL Server  --> XML stands for EXtensible Markup Language. --> XML was designed to store and transport data. --> XML was designed to be both human- and machine-readable. SQL Table DECLARE @Employee as table (Sno int identity(1,1),EmpName varchar(50),Company varchar(50), Location varchar(50),Stream varchar(50)) insert into @Employee(EmpName,Company,Location,Stream)...
Read More »