how to call crud 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: 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