RSS Feed
Twitter
Example to demonstrate the “Update From” Statement in SQL Server. This example can be used in scenarios where developer wants to update the Table with the help of Inner Join.
Archive for the ‘SQL Server’ Category
Posted in 
Tags: 
What is ODBC and OLEDB – Interview Question
Posted by jitendra on December 5th, 2010
This articles explains in detail description of ODBC and OLEDB component of Microsoft and its Usage
Difference in ADO and ADO.Net – Interview Question
Posted by jitendra on December 5th, 2010
Basic comparison between ADO and ADO.Net component in .Net Framework
Use of OPENXML in SQL Server
Posted by jitendra on December 4th, 2010
In SQL Server, OpenXML is very powerful method for the XML data manipulation. This article shows that how to use the OpenXML for XML string.
Manually attach database in SQL Server
Posted by jitendra on October 6th, 2010
Download sample database of SQL server and Manually attach database in SQL Server – AdventureWorksDB
Convert rows into comma separated values column – SQL Server
Posted by jitendra on October 4th, 2010
Convert rows into comma separated values column – SQL Server
Get Login Session count, Session Mode, User Name, Machine name in SQL Server
Posted by jitendra on September 29th, 2010
Get Login Session count, Session Mode, User Name, Machine name in SQL Server
SQL Server Pivot Table Example
Posted by jitendra on September 29th, 2010
Example and tutorial of using PIVOT in SQL Server
Between Clause problem in Date comparison – SQL Server
Posted by jitendra on September 23rd, 2010
SQL Server Date Comparison Tips : Never user Between clause with DateTime in SQL Server
Get Table information (Column Name, Data Type) in SQL Server
Posted by jitendra on September 18th, 2010
Get Table information like Column Name, Data Type, Character length, Default Values etc in SQL Server