RSS Feed
Twitter
Example of using pagination and switch case in where clause in SQL server
Posts Tagged ‘SQL Server 2005’
Posted in 
Tags: 
“Update From” Statement in SQL Server
Posted by jitendra on December 17th, 2010
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.
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
I am Jitendra Zaa having more than 5 years of experience in web development using J2EE, Salesforce, .Net , PHP, JQuery etc...