Stored Procedures
-
C#
Pagination in APIs vs. Simple GET Methods: A Deep Dive
Introduction When developing APIs, retrieving data efficiently is crucial for performance and scalability. Two common approaches are: Simple GET Method:…
Read More » -
Insert and Update in SQL Using User-Defined Table Type and XML
In this article I show various ways to insert in SQL. Using Datatable Using XML By showing examples of inserts…
Read More » -
SQL Helper for C#.Net
using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.VisualBasic; using System.Collections; using System.Data; using System.Diagnostics; using System.Data.SqlClient; using System.Xml;…
Read More »