Results for "Object"
14 / 184 posts
Added columns in a table by dynamic ways
IF OBJECT_ID('AddedDynamicColumn','P') IS NOT NULL BEGIN DROP PROC AddedDynamicColumn END GO CREATE PROCEDURE AddedDynamicColumn AS BEGIN SELECT ED.empid,E…
How to one series with comma separate(any Delimiter) value split into in rows
If we have one series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitSerie…
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…
What is an Index? Explain its different types in SQL
✅ Index in SQL Server (इंडेक्स इन SQL सर्वर): Index SQL Server में एक database object (डेटाबेस ऑब्जेक्ट) है जो टेबल के डेटा को जल्दी से प्राप्त करने के लिए…
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','…
What is Resilient Distributed Datasets (RDDs)
Resilient Distributed Datasets (RDDs) are a data structure of Apache Spark. They represent an immutable, distributed collection of objects that can be proc…
CLASSES in Python
ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग (Object-Oriented Programming या OOP) एक तरीका है प्रोग्राम लिखने का, जिसमें हम क्लास (class) और ऑब्जेक्ट (object) का इस्तेमा…
Basic in NumPy
NumPy is a Python library. NumPy is used for working with arrays. NumPy is short for "Numerical Python". The array object in NumPy is called ndarray, it pr…
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…
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…
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…
Working with JSON Data in Python (Using APIs and Built-in JSON Module)
इस टॉपिक में हम Python में JSON (JavaScript Object Notation) के साथ कैसे काम करते हैं, ये सीखते हैं। JSON एक डेटा फॉर्मेट है जो डेटा को store और transfer क…
Static Methods and Class Methods in Python
🧠 First, the Basics: In Python, there are 3 main types of methods inside a class: Instance Method → Works with object (instance) Class Method → Works with…
JSON Data – Complete Conceptual Guide (SQL Server Perspective)
🔹 JSON kya hota hai? (Quick recap) JSON (JavaScript Object Notation) ek lightweight text format hota hai data exchange ke liye. Example: { "empId…