what is a crud operation code example

Example 1: crud operations

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

Example 2: 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

Tags:

Sql Example

Related