Self Inner Join with Group By in SQL Server
This is the case: I have a table and basically this table has many redundancy. The solution is to create a link table and this table will contains record association. So what I need to do…
-
-
Linq.Binary(SQL Image Data Type) Type to File Stream
I got a column with Data Type of Image in SQL Server. What I would like to do is to omit this data to a FileStream or to a file. I tried to read the data…
-
SQL Methods in LINQ
I’m trying to implement DateDiff in LINQ. I would like to get all records with the same date and ignoring the timestamp. Here is my code snippet which doesn’t work public int tblExpReceiptFileUniqueID(string chCreateStaffCode, string vcFileName,…
-
Check Existence of temp table in memory
How to check whether the temp table is exists on the memory or not?The reason why you need this is because your stored procedure can throw the error when you try to drop a temp table…
-
Find Index in all the tables SQL Server
This is a query to find all the indexes in your table including when it was last updated Find all indexes on all tables SELECT OBJECT_NAME(OBJECT_ID) AS ‘Table Name’, [name] as ‘Statistic’, STATS_DATE(object_id, index_id) AS ‘Last…
-
Convert DataTable to CSV Function
This is the class that you can use to create a CSV file from DataTable. Basically what it does is to iterate each column and row in datatable and separate them with comma. Class/Function: using System;…
-
Generic Logging Class in .NET
This is a snippet code which is useful in creating your own logging class. You can compile this as a library and use it accross the projects. using System; using System.Configuration; using System.Diagnostics; using System.Reflection; namespace…
-
overriding maximum file upload size in ASP.NET
To override maximum file size that can be uploaded in you website, you need to put this in your web.config