SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
go


-- =============================================
-- Author:      <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[SP_INSERTAR]
    -- Add the parameters for the stored procedure here
    --<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
    --<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
    @cedula NVARCHAR(50),
    @nombre NVARCHAR(50),
    @apellido NVARCHAR(50),
    @telefono NVARCHAR(50),
    @direccion NVARCHAR(50),
    @fllegada NVARCHAR(50),
    @fsalida NVARCHAR(50),
    @thabit NVARCHAR(50),
    @nhabit INT,
    @numero INT,
    @status NVARCHAR(50),
    @costo MONEY

AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    --SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
    INSERT INTO Cliente(cedula,nombre,apellido,telefono,direccion)VALUES(@cedula,@nombre,@apellido,@telefono,@direccion)
    INSERT INTO Cliente_Habitaciones(cedula,nohabit,num,fllegada,fsalida,costo,estatus)VALUES(@cedula,@nhabit,@numero,@fllegada,@fsalida,@costo,@status)
END