-
-
MSSQL DateTime Conversions
Sometimes a basic function like MSSQL Format Date Function can not work as you do not have permission to create a function or you simply need something quick. To get day of week from DateTime column and order it by the proper day of week order. This is rather easy to update for those that…
-
Clear Form Field Inputs
Reference: http://stackoverflow.com/questions/4872364/clearing-all-fields-in-an-asp-net-form
-
-
-
Code | MSSQL | MSSQL - Audit | SQL
Count All Rows In All Tables
There are a few ways to count all of the rows in all of your tables in a database. The “Fastest Option” actually pulls the information from the database where the numbers are stored rather than taking time to count rows.
-
-
Simple FTP Download
Reference: http://stackoverflow.com/questions/2781654/ftpwebrequest-download-file
-
Distinct Query On One Column
While this query has more than what may be needed this will help you to get data based on one unique column.
-