SQL functions – CodeRavo

Understanding Day-of-Week Calculation in SQL Server

Introduction In SQL Server, extracting specific components of a date, such as the day of the … Understanding Day-of-Week Calculation in SQL ServerRead more

datefirst, datename, datepart, dayofweek, set-datefirst, SQL functions, SQL Server

Advanced SQL Search: Finding Rows Containing All Specified Words

Introduction In database management, a common task is retrieving records where specific words are present within … Advanced SQL Search: Finding Rows Containing All Specified WordsRead more

CHARINDEX, Full-Text Search, LIKE operator, SQL, SQL functions