Wednesday, November 10, 2021

Stored procedure in SQL server with Insert query

 CREATE PROCEDURE AddTest1

@name varchar(50),

@uniqueID varchar(50)

AS

BEGIN

INSERT INTO TEST1 

VALUES(@name,@uniqueID)

END

Table structure(screenshot below)

And we can call stored procedure by ------------ AddTest1 'NAVEEN','TEST'

No comments:

Post a Comment