Tech Point Fundamentals

2.76K subscribers

119 videos

Articles, videos, tutorials, and interview questions and answers related to software development technologies. Please visit our website for blog posts: www.t...

Latest Videos

Dynamic Data Filtering Dynamic Where Condition Filter data based on dynamic criteria D-SQL

Dynamic Data Sorting Sorting data based on parameterized column name Use of Dynamic SQL Query

Dynamic Schema Name Fetching Data from Dynamic Schema Fetch the data from Parameterized Schema

Fetching Data from Dynamic Linked Server Fetch the data from Parameterized Linked Server D-SQL

Dynamic Source Database Fetching Data from Parameterized Dynamic Database Use of Dynamic SQL

Dynamic Source Table Fetching Data from Dynamic Table Dynamic SQL Query Use of Dynamic SQL

Dynamic DDL Command Creating Table at Runtime Creating database at Runtime Use of Dynamic SQL

Dynamic Output Column Name Returning Data From Dynamic Column Use of Dynamic SQL D-SQL

Dynamic Alias Name Returning Dynamic Alias Name from Stored Procedure Use of Dynamic SQL

CSV Parameters in SQL SP Returning matching records for CSV parameter Use of Dynamic SQL

Extension Methods in C# Extension Method vs Static Method Extension Method vs Inheritance

Volatile Keyword in C# How Volatile Keyword Works in C# What is Volatile Keyword C# Volatile

How Yield Keyword Works in C# C# yield return C# yield break Yield Statement in C#

Difference between Under-Posting and Over-Posting UnderPosting vs OverPosting Anomalies of REST

Difference between Web API and RESTful WCF Service What are REST Principles REST vs SOAP Service

Content Negotiation in Web API MediaTypeFormatter MediaTypeMapping Accept vs Content-type

SQL Injection Attacks Prevention of SQL Injection Attacks Dynamic SQL Injection SQL Injection

Real Use Case of Dynamic SQL Query When and How to use Dynamic SQL Application of Dynamic SQL

Dynamic SQL Query - DSQL EXECUTE vs sp_executesql Static SQL vs Dynamic SQL

Difference Between COUNT(), COUNT(1), and COUNT(col) COUNT() vs COUNT(1) COUNT() vs COUNT_BIG()

Difference between INSERT INTO and SELECT INTO Clause INSERT INTO SELECT vs INSERT INTO EXEC SQL

Difference between WHERE and HAVING Clause Difference between GROUP BY and PARTITION BY clause

Deleting Duplicate Records in SQL Different Ways to Delete Duplicate Records in SQL

SQL NULL Value Consequence of NULL values in SQL NULL vs ISNULL vs IS NULL vs COALESCE

SQL Three Valued Logic SQL Ternary Logic SQL Trinary Logic SQL Trivalent Logic -SQL 3VL Logic

SQL UNIQUE Index UNIQUE INDEX vs UNIQUE KEY UNIQUE Index vs NOT NULL Constraint Indexed View

SQL Non-Clustered Index SQL Non-Clustered Indexed View Non-Clustered Index Structure

Does the CLUSTERED INDEX really physically store the rows in the key value order CLUSTERED INDEX

SQL CLUSTERED INDEX CLUSTERED INDEX vs PRIMARY KEY HEAP Table vs CLUSTERED Table Scan

Clustered vs Non-Clustered Index HEAP vs Clustered Table SQL Index Page Non-Clustered Index