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
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!