ALTER PROCEDURE dbo.FioInsertCommand
(
	@CompanyID int,
	@vid decimal( 1 ,  0 ),
	@fio char( 30 ),
	@rabota char( 40 ),
	@npolis char( 40 ),
	@nist char( 6 ),
	@nnapr char( 6 ),
	@kemnapr char( 30 ),
	@diag_osn char( 30 ),
	@diag_sop char( 20 ),
	@pal_otd char( 40 ),
	@datap datetime,
	@datav datetime,
	@kod_usl decimal( 4 ,  0 ),
	@summa decimal( 10 ,  2 ),
	@vibor char( 1 ),
	@ndok decimal( 2 ,  0 ),
	@datr datetime,
	@adres char( 20 ),
	@telefon char( 7 ),
	@srok_str char( 10 ),
	@zvanie char( 15 )
)
AS
	SET NOCOUNT OFF;
INSERT INTO [komp_fio] ([CompanyID], [vid], [fio], [rabota], [npolis], [nist], [nnapr], [kemnapr], [diag_osn], [diag_sop], [pal_otd], [datap], [datav], [kod_usl], [summa], [vibor], [ndok], [datr], [adres], [telefon], [srok_str], [zvanie]) VALUES (@CompanyID, @vid, @fio, @rabota, @npolis, @nist, @nnapr, @kemnapr, @diag_osn, @diag_sop, @pal_otd, @datap, @datav, @kod_usl, @summa, @vibor, @ndok, @datr, @adres, @telefon, @srok_str, @zvanie);
	
SELECT komp_fioID, CompanyID, vid, fio, rabota, npolis, nist, nnapr, kemnapr, diag_osn, diag_sop, pal_otd, datap, datav, kod_usl, summa, vibor, ndok, datr, adres, telefon, srok_str, zvanie FROM komp_fio WHERE (komp_fioID = SCOPE_IDENTITY())

Concurrency violation: the UpdateCommand affected  0  of the expected  1  records