Click here to Skip to main content
15,919,749 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have Four Text Boxes Name,Adress,EmailId & Mob for TablE 'EMP'

Now, Can u Please Tell me Stored Proc for insert for this...


Thanks & regards

Rakesh
Posted

1 solution

Hi.

try this:

SQL
-- Drop stored procedure if it already exists
IF EXISTS (
  SELECT * 
    FROM Emp 
)
   DROP PROCEDURE <--procedure name>
GO
--create a new procedure
CREATE PROCEDURE [dbo].[Insert](
 @Name nvarchar(50),
 @Address nvarchar(100),
 @Email Nvarchar(20),
 @Mob nvarchar(20)
)
	
AS
	begin 
	insert into Emp(Name , Addres,Email,Mob)
	values (@Name,@Address,@Email,@Mob)
	end
GO


-- if it is helpful please vote.--
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900