Results for "substr"
6 / 14 posts
Filter by Category
substring() in PySpark
📌 What is substring() ? The substring() function in PySpark is used to extract a portion of a string from a column in a DataFrame. It is part of the PySpa…
SQL Server Database Metadata Automation – Complete Dynamic Schema Capture Framework
Managing database schema changes manually becomes difficult as projects grow. Tables change, columns get added, constraints evolve, and documentation quickly...
SQL Server Deadlock & Performance Monitoring Made Easy
Introduction In SQL Server, performance issues are very common. Sometimes queries run slow, sometimes users get stuck, and sometimes the system becomes unres...
PySpark Built-in Functions
These functions are commonly used with groupBy() , agg() , or select() to compute things like sum, average, max, min, count, etc. PySpark functions come fr…
Split full name into first name and last name in SQL
Split full name into first name and last name : SELECT EmployeeName, CASE WHEN CHARINDEX(' ', EmployeeName) > 0 -- Check if there is a space (indicating…
How to Two series with comma separate(any Delimiter) value split into in rows respectively
If we have two series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitTwoSe…