does anyone see anything wrong with my stored procedure, its suppose to update the terminations table through an insert. I need it to pull the data from another table the EmployeeGamingLicense_tbl and insert it into the Terminations table
Code:
CREATE PROCEDURE [insert_TERMINATION_TestSp]
(@TM_#_1 [int],
@FirstName_2 [nvarchar](50),
@LastName_3 [nvarchar](50),
@SocialSecurityNumber_4 [int],
@DateHired_5 [datetime],
@Status_6 [nvarchar](50),
@Title_7 [nvarchar](50),
@DepartmentName_8 [nvarchar](50))
AS INSERT INTO [GamingCommissiondb].[dbo].[TERMINATION]
( [TM #],
[FirstName],
[LastName],
[SocialSecurityNumber],
[DateHired],
[Status],
[Title],
[DepartmentName])
VALUES
( @TM_#_1,
@FirstName_2,
@LastName_3,
@SocialSecurityNumber_4,
@DateHired_5,
@Status_6,
@Title_7,
@DepartmentName_8)
GO
ASP Free Forums Sponsor:
August 2nd, 2004, 05:02 PM
stored procedure
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
