I'm calling my stored procedure and the fact having the first field as an incremental value is causing me trouble.
first field is an INT and setup as IDENTITY. However, in the stored procedure I must specify it and I"m not passing any values to it but then I get an error message as Error converting data type varchar to int.
since my 2nd field being passed to SP is varchar. What is the right approach here?
here is the code:
insert into test(category_Id, name, lft, rgt, visible, description)
values(@p0, @p1, @p2, @p3, @p4, @p5)
add_node 'test', 200, 300, 0 ,'some info here ...'
select * from test