GO
/****** Object: StoredProcedure [dbo].[sp_SetMusteri] Script Date: 06/19/2010 15:08:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[sp_SetMusteri]
@MusteriNo int,
@Adi nvarchar(50),
@Soyadi nvarchar(50),
@Tel nvarchar(20),
@Cep nvarchar(20),
@Adres text,
@Tarih DateTime,
@E1 bit,
@E2 bit,
@E3 bit,
@E4 bit,
@Durum int,
@Il nvarchar(50),
@Ilce nvarchar(50),
@Nott text
As
Begin
Insert Into tblMusteri
(
MusteriNo,
Adi,
Soyadi,
Tel,
CepTel,
Adres,
Tarih,
E1,
E2,
E3,
E4,
Durum,
Sehir,
Ilce,
Nott
)
Values
(
@MusteriNo,
@Adi,
@Soyadi,
@Tel,
@Cep,
@Adres,
@Tarih,
@E1,
@E2,
@E3,
@E4,
@Durum,
@Il,
@Ilce,
@Nott
)
End