RSS Feed
Twitter
This articles explains in detail description of ODBC and OLEDB component of Microsoft and its Usage
Archive for the ‘SQL’ Category
Posted in 
Tags: 
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.
ETL , DTS and SSIS Introduction
Posted by jitendra on December 4th, 2010
Introduction to ETL Services, Data transformation services, SQL Server Integration Services, Advantages of SSIS over DTS, New features of SSIS 2008
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