MS SQL

MS SQL RSS

Help with Stored Procedure

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Help with Stored Procedure

Aug 4th, 2005

ok, here is the script I ran to create the stored procedure

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
 
 
 
 
CREATE PROCEDURE [insertFunction] (@Id [int], @class [nvarchar], @type [nvarchar], @name [nvarchar]) AS 
 
declare @classID [int]
SELECT @classID = tblClass.ID FROM tblClass WHERE tblClass.Name = @class
 
 
 
INSERT INTO tblFunction
	([ID],[Name],[ReturnType],[Class])
VALUES 
	(@Id,@name,@type,@classID)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE [insertFunction] (@Id [int], @class [nvarchar], @type [nvarchar], @name [nvarchar]) AS 

declare @classID [int]
select @classID = tblClass.ID from tblClass where tblClass.Name = @class



INSERT INTO tblFunction
	([ID],[Name],[ReturnType],[Class])
VALUES 
	(@Id,@name,@type,@classID)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

but when I run it I keep getting
Cannot insert the value NULL into column 'Class', table 'documentation.dbo.tblFunction'; column does not allow nulls. INSERT fails.
The statement has been terminated.

when i run the procedure substituting values for the variables, it works fine.

Any ideas?