CREATE PROCEDURE dbo.zzBlock @fileName varchar (255), @data int AS INSERT INTO dbo.ZZHLPDocInformation (docInfoBlocked) VALUES (@data) WHERE (docInfoDocFilename = @fileName) GO
I want to insert a variable (@data) into the docInfoBlocked column, where the filename is @filename.... I get a syntax error near WHERE.... any suggestions????
Thanks!!!! works like a charm... one more question... what do i do since its the column accepts the 'bit' datatype... i either want the value to be 1 or null??? how do i input a null value for @data???? (NOTE: im using ASP)
stored procedure error???
Forum Locked
Posted - 07/06/2006 : 14:16:03
