CREATE TABLE [dbo].[tbl_registration]
SELECT * FROM [dbo].[tbl_registration]

sp_helptext Sp_Get_registration
CREATE table[dbo].[tbl_registration]
id
    [Sr_no]    INT            IDENTITY (1, 1) NOT NULL,
    [Email]    NVARCHAR (100) NULL,
    [Password] NVARCHAR (MAX) NULL,
    [Name]     VARCHAR (MAX)  NULL,
    [Address]  NVARCHAR (MAX) NULL,
    [City]     NVARCHAR (MAX) NULL,
    CONSTRAINT [PK_tbl_registration] PRIMARY KEY CLUSTERED ([Sr_no] ASC)
    );

  Alter proc Sp_Get_registration

    @Sr_no int,
    @Email    NVARCHAR (100),
    @Password NVARCHAR (MAX),
    @Name     VARCHAR (MAX),
    @Address  NVARCHAR (MAX),
    @City     NVARCHAR (MAX)
    AS
    BEGIN
    INSERT INTO tbl_registration VALUES( @Email, @Password,@Name,@Address,@City )
    END
    BEGIN
    UPDATE tbl_registration SET
    Email= @Email,
    [Password]=  @Password,
    Name= @Name,
    [Address]=@Address,
    City=@City
    WHERE Sr_no=@Sr_no
    END
    BEGIN
    DELETE FROM tbl_registration WHERE Sr_no=@Sr_no
    END
    BEGIN
    SELECT * FROM tbl_registration
    end


INSERT INTO tbl_registration VALUES(@[Sr_no],@

INSERT INTO [dbo].[tbl_registration] VALUES
(
'r@gmail.com','4654545','Praveen kumar','Ghaziabad 432',' New Delhi');
INSERT INTO [dbo].[tbl_registration] VALUES
(
'r@gmail.com','4654545','Praveen kumar','Ghaziabad 432',' New Delhi');
INSERT INTO [dbo].[tbl_registration] VALUES
(
'd@gmail.com','9954545','Dhananjay sir ji','Faizabad 432',' Ambedkar NAgar');
INSERT INTO [dbo].[tbl_registration] VALUES
(
'v@gmail.com','8889545','Vikaas Kumar','Lucknow789',' Kesarbagh');