Sql datepart is a date and time function to get a specific part of a datetime value. Sql datepart can be used to get either the day, month, year or any other part of the datetime value. Sql datepart returns an integer value.

Sql charindex is a sql server function that indicates the first position of a character or a character string within another character string. When a character or character string is found with sql charindex, the starting position is indicated with a non-zero positive integer value. If a character or character string is not found with charindex, a zero integer value is returned. charindex's starting position is 1, unlike other index search functions that would normally return 0 as the first position.

Sql newid() is a Transact-Sql function for returning a “uniqueidentifier”, commonly known as globally unique identifier. Sql newid() can be used to randomly sort records.