Posts: 21
Name: Hesham
Location: Ismailia , EGYPT
|
ohhhhhhhhhhh thats so cool ,,, i did what you said and its work well thank you soooooooooooooooo much ,, here is my Right Syntax
ALTER PROCEDURE InsertEmployee
@EmployeeID int output,
@FirstName varchar(10),
@LastName varchar(20),
@TitleOfCourtesy varchar (25)
AS
INSERT INTO Employees(TitleOfCourtesy,LastName,FirstName,HireD ate)VALUES(@titleOfCourtesy,@LastName,@FirstName,GetDate());
SET @EmployeeID=@@IDENTITY
RETURN
thank you sooooooooooooooooooooooooooo much god bluess you
|