1: function isInteger(val) {

   2:  

   3:    return (val == null || isNaN(val)) ? false : 

   4:       ( ((1.0 * val) == Math.floor(val)) && (val.indexOf(".") == -1));

   5:  

   6: }

CREATE FUNCTION dbo.CreateInlineTable (

    @Param AS VARCHAR(7999), -- Deliminated string

    @Deliminator AS VARCHAR(10) -- Deliminator

    )   RETURNS TABLE

AS

    RETURN ( SELECT Substring(@Deliminator + @Param + @Deliminator, Number + LEN(@Deliminator), 

                    CHARINDEX(@Deliminator, @Deliminator + @Param + @Deliminator, Number + LEN(@Deliminator)) - Number - LEN(@Deliminator) ) AS PARAM

               FROM InlineNumbers Numbers

              WHERE Number <= LEN(@Deliminator + @Param + @Deliminator) - LEN(@Deliminator)

                    AND Substring(@Deliminator + @Param + @Deliminator, Number,LEN(@Deliminator)) = @Deliminator)

GO

   1: /// <summary>

   2: /// Converts a DataTable to a string with an html table.

   3: /// </summary>

   4: /// <returns></returns>

   5: public static string DataTableToString(DataTable datatable, bool headers)

   6: {

   7:     StringBuilder sb = new StringBuilder();

   8:  

   9:     sb.Append("<table border=\"1\">");

  10:  

  11:     if (headers)

  12:     {

  13:         //write column headings

  14:         sb.Append("<tr>");

  15:         foreach (DataColumn datacolumn in datatable.Columns)

  16:         {

  17:             sb.Append("<td>" + datacolumn.ColumnName + "</td>");

  18:         }

  19:         sb.Append("</tr>");

  20:     }

  21:  

  22:     //write table data

  23:     foreach (DataRow datarow in datatable.Rows)

  24:     {

  25:         sb.Append("<tr>");

  26:         foreach (DataColumn datacolumn in datatable.Columns)

  27:         {

  28:             sb.Append("<td>" + datarow[datacolumn].ToString() + "</td>");

  29:         }

  30:         sb.Append("</tr>");

  31:     }

  32:     sb.Append("</table>");

  33:  

  34:     return sb.ToString();

  35: }

   1: backup log db_name with truncate_only 

   2: go 

   3: dbcc shrinkfile (db_name_log,0) 

   4: go