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
-
Another Entry to My Blog
I’ve decided to buy a domain which basically link to the same server. My new domain is http://www.fransiscus.com.au and at the same time I’ll migrate my content from Joomla to Wordpress .I will try to blog…
-
CSV parsing in SQL server
I’ve got this SQL Function to parse comma separated value into a table. We need this function when our application commit separated comma value in a text. We normally do this when we want to send…
-
Project item ‘4294967294’ does not represent a file
Project item ‘4294967294’ does not represent a file, this error comes out when I try to open a solution which results in some of the projects can not be loaded (the source file is on the…