title: Autogenerate ID in stored procedure -SQL
body: <p>I have this stored procedure in SQL Server which I use in visual net to generate values for some table. </p>
  
  <pre><code>CREATE PROCEDURE grabardatos
  @codigocliente  int,
  @nombre  varchar(50),
  @apellido varchar(50),
  @sexo char(1),
  @direcion varchar(50),
  @telefono varchar(50),
  @tipo varchar(50)
  
  AS
  
  BEGIN
  
  INSERT INTO CLIENTES(Numero,Nombre,Apellido,Sexo,Direcion,Telefono,Tipo)
  
  VALUES ( @codigocliente,@nombre,@apellido,@sexo,@direcion,@telefono,@tipo)
  
  END
  </code></pre>
  
  <p>The parameter <code>@codigocliente</code> is the id of the table which, according to this code, has to be entered manually in visual net. How Can the id be autogenerated in the sql code of the stored procecure instead of being entered manually in visual net?</p>