create procedure test_insert_studey

-- exec  test_insert_studey 9003, 'kljjkljlk','l;k;lk;lk'
(
@code_bimar int,
@name nvarchar(50) , 
@famil nvarchar(50)
)        
as
begin
  INSERT INTO db_triana.dbo.tb_study (
			IdxStudy,
			ID,
			OtherID,
			Name
			, BirthDate
			, Age
			, [GUID]
			, Tempate_PA
			, Tempate_CP
			, Tempate_OX
			, Tempate_OV
			, Tempate_DC
			, CountPX
			, CountCX
			, CountOX
			, CountOV
			, CountDC
			, CountCT
			, LastName
			, Email
			, Address1
			, Address2
			, HomePhone
			, MobilePhone
			, Fax
			, OtherName
			, CountTOMO)
          VALUES (@code_bimar,@code_bimar, @code_bimar, @name + ' ' + @famil, 'Birth', 'Age', NEWID(),NEWID(),NEWID(),NEWID(), NEWID(), NEWID(), '1', '1', '1', '1', '1', '1', 'LastName', 'Email', 'Address1', 'Address2', 'HomePhone', 'MobilePhone', 'Fax', 'OtherName', '1')
     
	 end                   