Guru E. Technology

need of every business.


October, 2013

How to Update a Column Value from Another Table

While working with SQL Table and queries most of the time we have to face this scenario to create or update a table with another table values. So I am going to demonstrate a simple example here. I have a table1 which has following structure. ID | Name | State =================== 1 | Ap | […]

Posted in Developer Solutions, SQL Server | No Comments »

How to Load XML file into SQL Temporary Table

Well, this is very interesting! We can load complete XML file into SQL table and Add/Update records for the table. It was not easy earlier as it seems to be iterating all the nodes picked the value and then insert into table hu! really tough Job. I will explain you how you can load XML […]

Tags: , , ,

Posted in SQL Server | No Comments »