26-Jun-2015SQL Server, avoid encoding special character when using FOR XML PATH
From SQL 2005, we are using FOR XML PATH('') for the string concatenation. I have also mentioned the same in very old blog: Generate Comma Separated List with SELECT statement.
22-Oct-2009SQL SERVER SSIS: Basic Example Of Data Flow Task
Today I am going to give Basic example of Data Flow Task in SSIS, import CSV file to SQL SERVER Database
Many times user asked to import their data from their files. They might have data in Microsoft Access, Microsoft Excel, CSV File, Text Tile etc..
05-May-2009SQL SERVER: Read values from Comma Separated variable
As we have seen, How to generate Comma separated List in SQL. Today we know, how to get values from Comma separated column. Many times developers asked, How can I read comma separated values from variable? There are many ways to get solution for this. Lets discuss about the best way, I think so. We can use XML to read values from comma separated values. XML made our life easy.