Results for "LIKE"
12 / 184 posts
What is View in SQL server
A view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. IF OBJECT_ID('ViewTable','…
Implementing Transactions,Error Handling, and Dynamic SQL in SQL
Think of a transaction as a complete package deal. It's like when you buy something from a store. You give them money, and in return, you expect to get the…
EasyDict dictionaries
EasyDict is a subclass of Python's built-in dictionary that allows accessing dictionary keys as attributes like JavaScript object. pip install easydict fro…
What is Blocking in SQL, How to solve blocking, and Kill Session
What is Blocking in SQL? Blocking occurs in SQL Server when one query or transaction holds a lock on a resource (like a row or table) and prevents other qu…
Database Permissions in SQL Server
In SQL Server, database permissions control what actions users can perform on specific database objects (like tables, views, and stored procedures). Permis…
Understanding Decision Trees: A Simple Guide
Decision Trees are a popular machine learning tool. They help in making decisions, much like how people make choices. In this blog, we will explain what de…
SQL Logical Operators with Examples
SQL logical operators are used to filter data by combining multiple conditions in SQL queries. These operators help in refining queries to fetch specific r…
Understanding DataFrames in PySpark
DataFrames are an important data structure in PySpark. They help in handling structured and semi-structured data efficiently. DataFrames are like tables in…
where() & filter() in PySpark
The filter() function in PySpark is used to create a new DataFrame by selecting rows that meet a specified condition or SQL expression. Alternatively, the …
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…
Advance Python Concept
The @property decorator in Python is used to make a method behave like an attribute . It allows you to define getters, setters, and deleters in an elegant …
SQL Server Multi-Level Approval Workflow with Auto Skip Logic
In many enterprise applications like HRMS, Travel Requests, Expense Approval, Purchase Approval , we need a multi-level approval workflow . But real system…