English: Data Retrieval: SELECT statement, DISTINCT, Sorting and filtering data: WHERE, ORDER BY, GROUP BY, HAVING, DESC clauses, operators: AND, OR, IN, LIKE, NOT, BETWEEN, AS, '%' and '_' signs, ...

Use SQL table valued function to parse a whole name and separate it into it's components - softwareNuggets/SQL_Server_parse_fullname_into_parts ...

📢 💧 Do you know what is SUBSTRING Function in SQL Server The SUBSTRING() function extracts some characters from a string. Today Morning, I was… ...