Date functions SQL Server

SQL Server > Date&Time > Date Functions



-- Selecting the Current Year/Get Current Year/Separate Year Part from Date
Select DatePart(YY, GetDate()) as Current_Year
-- Selecting the Current Quarter/Get Current Quarter/Separate Quarter Part from Date
Select DatePart(QQ, GetDate()) as Current_Quarter
-- Selecting the Current Month/Get Current Month/Separate Month Part from Date
Select DatePart(MM, GetDate()) as Current_Month
-- Selecting the Current Hour/Get Current Hour/Separate Hour Part from Date
Select DatePart(HH, GetDate()) as Current_Hour
-- Selecting the Current Minute/Get Current Minute/Separate Minute Part from Date
Select DatePart(minute, GetDate()) as Current_Minute

-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(month, GetDate()) as Current_Month_Name
-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(day, GetDate()) as Current_Day
-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(wk, GetDate()) as Current_Week

Restart asp.net application

ASP.NET > HttpRuntime > UnloadAppDomain


HttpRuntime.UnloadAppDomain Method

Terminates the current application. The application restarts the next time a request is received for it.

UnloadAppDomain is useful for servers that have a large number of applications that infrequently receive requests. Rather than keep application resources alive for the lifetime of the process, UnloadAppDomain allows programmatic shutdown of unused applications.

Example

Restart asp.net application

using System;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace editor.Admin
{
    public partial class restart : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            System.Web.HttpRuntime.UnloadAppDomain();
        }
    }
}

 

Setting up a Sent Mail rule in Thunderbird

Setting up a Sent Mail rule in Thunderbird
1. Click on Tools > Account Settings
2. Under your Account Name (the example below shows Work Account, you may have simply named yours IMAP), select Copies and Folders

Make sure there is a tick next to Place a copy in: You then have TWO choices.
OPTION ONE
"Sent" folder on By default Thunderbird selects "Sent" folder on This means that Thunderbird will create a folder for you called Sent under your IMAP account and all your sent items will filter into this folder.
OPTION TWO
Other You may already have a Sent Mail folder set up on your IMAP account. By selecting Other you can specify which folder you would like your sent mail to filter into. To select an alternative folder: Click on the following icon: Select your Account Name (not Local Folders) Choose the Sent Mail folder you require
Click OK to save your changes.

Extract hour, minute from date column Oracle

Oracle > Extract hour, minute from date column

SELECT

  to_char(column_date,'HH24') hh
  ,to_char(column,'mi') min
from
  table;

SQL Server Deadlocks

SQL Server > Deadlocking

Deadlocking occurs when

•  two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has.

SQL Server identifies the problem and ends the deadlock by: 

• automatically choosing one process and aborting the other process
• allowing the other process to continue.

The aborted transaction is rolled back and an error message is sent to the user of the aborted process.
Generally, the transaction that requires the least amount of overhead to rollback is the transaction that is aborted.

Avoid deadlocking on your SQL Server:

• Ensure the database design is properly normalized.
• Have the application access server objects in the same order each time.
• During transactions, don't allow any user input.
• Avoid cursors.
• Keep transactions as short as possible.
• Reduce lock time.
• If appropriate, reduce lock escalation by using the ROWLOCK or PAGLOCK.
• Consider using the NOLOCK hint to prevent locking if the data being locked is not modified often.
• If appropriate, use as low of an isolation level as possible for the user connection running the transaction.

Select a random records SQL SERVER, Oracle, MySql

Database > Random Records

--Select random rows with Microsoft SQL Server
--NEWID Creates a unique value of type uniqueidentifier.

SELECT * FROM table ORDER BY NEWID()

--Select random rows with MySQL
SELECT * FROM table ORDER BY RAND()

--Select random records with Oracle:
SELECT * FROM table ORDER BY dbms_random.value

How to extract words out from a string c#

C# > String > Spilt

 
Split returns a string array that contains the substrings in this instance that are delimited by elements of a specified Unicode character array. 

Example
 

string _strInput = "aaa bbb ccc ddd";

string[] words = _strInput.Split ( new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries );

foreach(string s in words)

{

  // value of s: aaa, bbb, ccc, ddd

}