CREATE PROCEDURE Insert
@Id nvarchar(150),
@Name nvarchar(150),
@Addr nvarchar(500)
AS
BEGIN
Insert Into Sample(Id,Name,Address) Values(@Id,@Name,@Assr )
END
GO
CREATE PROCEDURE Upadte
@Id nvarchar(150),
@Name nvarchar(150),
@Addr nvarchar(500)
AS
BEGIN
Update sample set Name=@Name,Address=@Addr where Id=@Id
END