SQL CRUD operation using Stored Procedures
SQL CRUD operation using Stored Procedures Step One: create SQL table Step Two: create stored Procedure CREATE PROCEDURE [dbo].[TeacherSubject_CRUD] @Action VARCHAR(10) ,@TId INT = NULL ,@Subject nvarchar(50) = NULL ,@Sid int = NULL AS BEGIN SET NOCOUNT ON; --SELECT IF @Action = 'SELECT' BEGIN SELECT * FROM TeacherSubject END --INSERT IF @Action = 'INSERT' BEGIN INSERT INTO TeacherSubject(Subject,sid) VALUES (@Subject, @Sid) END --UPDATE ...