Creating a Stored Procedure for Insertion….!

Hi All…. This code shows us how to write a stored procedure…. First of all we have to define parameters which must be of same data type as of SQL DataBase….

 

 

ALTER PROCEDURE SP_CreateProjectTeam

@ProjectCode

varchar(50),

@ProjectName

varchar(50),

@TeamMembers varchar(50)

AS

/* SET NOCOUNT ON */

INSERT INTO TblProjects

(ProjectCode, ProjectName)

VALUES (@ProjectCode,@ProjectName)

INSERT INTO

TblProjectTeams

(Members, ProjectCode)

VALUES

(@TeamMembers,@ProjectCode)

RETURN

Advertisements

• Posted in: Visual Studio Tools for Office