crud operations meaning code example

Example 1: crud applications means

Create , Read , Update , Delete
CRUD is an acronym for the four basic types of SQL commands: Create , Read , Update , Delete . Most applications have some kind of CRUD functionality, and we can assume that every programmer had to deal with CRUD at some point. A CRUD application is one that uses forms to get data into and out of a database.

Example 2: crud operations meaning

-- (C)reate (R)ead (U)pdate (D)elete
INSERT INTO my_table (my_col) VALUES ('Hello');         -- (C)reate
SELECT my_col FROM my_table WHERE my_id = 33;           -- (R)ead
UPDATE my_table SET my_col = 'Holla' WHERE my_id= 33;   -- (U)pdate
DELETE FROM my_table WHERE my_id = 33;                  -- (D)elete

Example 3: crud operations

Create, Read, Update and Delete are the main operations of CRUD.

Example 4: To give permission to the specific user for the CRUD operation in the database at a time

USE OnlineRestaurant1
GO
EXEC sp_addrolemember N'db_datawriter', N'RAHBARINFOTECH\LOVE'
GO
EXEC sp_addrolemember N'db_datareader', N'RAHBARINFOTECH\LOVE'
GO