Insert and Update Procedures

sturner333

I have 2 stored procedures tied to a dataset in vb 2008 for updating and inserting info in a datagrid. The Update works, insert does not. Error:
Conversion failed when converting the varchar value '2009-11-02
00:00:00 ' to data type bit.

Expand|Select|Wrap|Line Numbers

 ALTER PROCEDURE dbo.InsertTimeLog

(

@id [int],

@dateEntered [smalldatetime] = '2/2/2000'

)

AS

Begin

INSERT INTO [dbo].[TimeLogEntered]

VALUES (       @id,

                      CONVERT(char, @dateEntered, 120))

end

@dateEntered gets a Use CONVERT error

ck9663

Check the structure of your table, relative to the value you're trying to insert.

-- CK

Insert and Update Procedures

Post your reply

Similar topics