.NET, MVC, C#.NET, ASP.NET , Jquery, SQL, Kendo UI

private string GetFileMimeType(string extension)         {             char[] arr = extension.ToCharArray();             arr = Array.FindAll<char>(arr, (c => (char.IsLetterOrDigit(c))));             extension = new String(arr).ToLower();             Dictionary<string, string> lstMimeTypes = new Dictionary<string, string>               {                 {"ai", "application/postscript"},                 {"aif", "audio/x-aiff"},              ...

select top 0 * into # mytemptable from myrealtable Ref : http://stackoverflow.com/questions/9206433/best-way-to-create-a-temp-table-with-same-columns-and-type-as-a-permanent-table