Hi
I have the folowing stored proc.

CREATE PROC NewDoc
@Vrsta nvarchar(3),
@Sifra int OUTPUT
AS

INSERT Doc(Vrsta)
VALUES ( @Vrsta)

SELECT @Sifra = @@IDENTITY

declare @sifra int
exec novidokument '06', @sifra output
print @sifra

The field Vrsta in table Doc is varchar(3), but after insert into the table the value in the table is not 06 then 6. The same thing is with everty string containing zero on the begining.
How can i resolve this problem?
Thanks
Alex

Hi

The value in the varchar field will be stored as '06' if you pass it into the procedure. Try running this piece of code to see :-

CREATE table mytable
(
Vrsta nvarchar(3)
)

INSERT mytable
VALUES ('06')

SELECT * from mytable


In your procedure you are only retrieving the identity column value.

Try selecting the data in your 'Doc' table to see exactly whats in there.

Nickie

Your script work fine
but please try mine and you'll see that is not working if you select after inserting from table Doc

Hi

I have tried your script and selected from 'Doc' table and my result is :-

Vrsta Sifra
----- -----------
06 1

Nickie