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- Posted in: Visual Studio Tools for Office
Recent Comments