{{theTime}}

Search This Blog

Total Pageviews

Construct String from Set using any delimiter


public static String getSetAsString(Set ids, String delimiter){
   StringBuffer idsSql = new StringBuffer() ;
   Iterator it = ids.iterator();    
   while(it.hasNext()) {
        idsSql .append((Long)it.next()) ;
        idsSql .append(delimiter) ;
   }    
   return idsSql .toString().substring(0, idsSql .length()-1) ;

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...