.Net Core Concepts
Composite key e.g. In SQL, a composite key, also known as a compound key or composite primary key, is a key that consists of two or more columns in a database table. Unlike a simple key, which is made up of a single column, a composite key uses multiple columns to uniquely identify a row in a table. This means that the combination of values in the composite key columns must be unique for each row in the table.
Cursor: In SQL, a cursor is a database object that is used to retrieve and manipulate data from a result set, typically within a stored procedure or a block of code. Cursors are especially useful when you need to process rows of data one at a time, rather than fetching the entire result set at once. Cursors are often used in procedural SQL languages like PL/SQL (used in Oracle databases) or T-SQL (used in Microsoft SQL Server). There are 2 types of Cursors: Implicit Cursors, and Explicit Cursors.
Query Concepts click >>>
OOP Concepts click >>>
CRUD Operations
#AbdurRahimRatulAliKhan #ARRAK #Code #Programming #Panjeree #PBS #Viva
>>>