Results for "Text"
8 / 184 posts
Insert <br> tag in SQL text string
CREATE or ALTER FUNCTION dbo.Fn_InserBRtag(@inputString NVARCHAR(MAX)) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @resultString NVARCHAR(MAX) = ''; DECLARE @st…
Spark session vs Spark context
In Apache Spark, SparkSession and SparkContext are both essential components, but they serve different purposes and have different scopes. Here's a detaile…
Calculate and Calculatetable Function in Power BI
CALCULATE : It's used to modify or filter the context in which a calculation is being performed CALCULATE(<expression>, <filter1>, <filter2&…
Excel formulas
Function What it Counts Syntax Example Range Output Example COUNT Only numeric data =COUNT(range) A1(e.g. 1, "Text", 3, "", 5) =COUNT(A1:A5) → 3 (counts 1,…
SQL Interview Q&A
Here are the questions along with their corresponding answers extracted from the provided context: What is SQL? SQL stands for Structured Query Language. I…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
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…
In-Memory Databases (Data Warehouse Context)
🔹 In-Memory Database kya hoti hai? In-memory database wo database hoti hai jisme: 👉 Data hard disk par store nahi hota 👉 Data directly RAM (memory) me s…